Sentry Page Protection
Summary
1. When adding up numbers, the SUM function is always the preferred method than using the plus sign (+).
2. The MEAN, MIN and MAX functions allow you to compute the mean, minimum and maximum values from a set of variables, respectively.
3. The RAND function allows you to generate random values based on a specified distribution.
4. The ROUND function allows you to round numeric values based on a rounding factor.
5. The FLOOR function allows you to round down numeric values.
6. The SUBSTR function allows you to extract information from a character variable.
7. The LENGTH function allows you to check the length of a character variable. It is useful in identifying incorrect character values.
8. You can use the double strokes (||) to combine character variables.
9. The INDEX and INDEXC function allow you to search for text values from character variables.
10. The UPCASE, LOWCASE and PROPCASE functions allow you to convert character values into your desired case.
11. The RENAME statement allows you to rename variable.
12. The KEEP and DROP statements allow you to keep or drop certain variables from a data set
13. The DO statement is needed when executing multiple actions within an IF statement.
1. When adding up numbers, the SUM function is always the preferred method than using the plus sign (+).
2. The MEAN, MIN and MAX functions allow you to compute the mean, minimum and maximum values from a set of variables, respectively.
3. The RAND function allows you to generate random values based on a specified distribution.
4. The ROUND function allows you to round numeric values based on a rounding factor.
5. The FLOOR function allows you to round down numeric values.
6. The SUBSTR function allows you to extract information from a character variable.
7. The LENGTH function allows you to check the length of a character variable. It is useful in identifying incorrect character values.
8. You can use the double strokes (||) to combine character variables.
9. The INDEX and INDEXC function allow you to search for text values from character variables.
10. The UPCASE, LOWCASE and PROPCASE functions allow you to convert character values into your desired case.
11. The RENAME statement allows you to rename variable.
12. The KEEP and DROP statements allow you to keep or drop certain variables from a data set
13. The DO statement is needed when executing multiple actions within an IF statement.