| 1. |
Name And Describe Three Sas Functions That You Have Used, If Any? |
Answer»
different types of functions:
TRIM : REMOVING the trailing blanks from character expressions. syntax=trim(argument) SUBSTR: substr extracts the substring from an argument syntax=substr(argument, position<,n>) Abs: Returns the absolute of the argument Syntax=abs(argument) The most common functions that would be used are- Conversion functions - Input / Put / int / ceil / floor Character functions - Scan / substr / index / Left / trim / compress / cat / catx / upcase,lowcase Arithmetic functions - Sum / abs / Attribute info functions – Attrn / length Dataset – OPEN / close / exist Directory - dexist / DOPEN / dclose / dcreate / dinfo File functions – fexist / fopen/ filename / fileref SQL functions – coalesce / count / sum/ mean Date functions – date / today / datdif / datepart / DATETIME / intck / mdy Array functions – dim different types of functions: TRIM : Removing the trailing blanks from character expressions. syntax=trim(argument) SUBSTR: substr extracts the substring from an argument syntax=substr(argument, position<,n>) Abs: Returns the absolute of the argument Syntax=abs(argument) The most common functions that would be used are- Conversion functions - Input / Put / int / ceil / floor Character functions - Scan / substr / index / Left / trim / compress / cat / catx / upcase,lowcase Arithmetic functions - Sum / abs / Attribute info functions – Attrn / length Dataset – open / close / exist Directory - dexist / dopen / dclose / dcreate / dinfo File functions – fexist / fopen/ filename / fileref SQL functions – coalesce / count / sum/ mean Date functions – date / today / datdif / datepart / datetime / intck / mdy Array functions – dim |
|