1.

Name And Describe Three Sas Functions That You Have Used, If Any?

Answer»
  1. Compress - sas function which is used to remove spaces in string value and concatenate two values Without spaces.
  2. Input is another function of sas, it is one of conversion function in sas. It converts numeric into char.
  3. Put is another conversion function in sas. It converts char to numeric.
  4. SAS functions can be used to convert data and manipulate CHARACTER variable values.

different types of functions:

  1. TRIM
  2. SUBSTR
  3. ABS
  4. SCAN

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



Discussion

No Comment Found