SAS Function
| Spectrum Writer Function
| Description
|
| COMPBL
| #COMPRESS
| compress blanks out of a string
|
| INPUT
| #MAKENUM, #MAKEDATE, #MAKETIME
| convert character string to numeric, date or time value
|
| LOWERCASE
| #LCASE
| make characters all lower case
|
| PUT
| #FORMAT
| convert numeric value to character string
|
| SUBSTR
| #SUBSTR
| extract a substring from a string
|
| TRANSLATE
| #TRANSLATE
| translate all occurences of one character to another character within a string
|
| UPCASE
| #UCASE
| make characters all upper case
|
| FLOOR
| #INT
| return integer portion of a numeric value
|
| MIN
| #MIN
| return lower of two or more values
|
| MAX
| #MAX
| return higher of two or more values
|
| MOD
| #MOD
| returns the integer remainder after a division of two numbers
|
| ROUND
| #ROUND
| change the decimal precision of a numeric value
|
| DATE
| #TODAY
| returns the system date
|
| DAY
| #DAYNUM
| returns the day part of a date
|
| MONTH
| #MONTHNUM
| returns the month part of a date
|
| TODAY
| #TODAY
| returns the system date
|
| YEAR
| #YEARNUM
| returns the year part of a date
|
