Important SAS Functions

 

Sas Functions: Syntex

            Scan: New Variable =Scan(variable name, position, “dlm”)  - Extract word                     

            Substr: New Variable = Substr(Variable name,position, length) – Extract Letter 

            Find: Newvariable=Find(variable name,”letter”, ”Modifier”,Position). – Find Position

                                    Modifier helps to ignore case sensitive

            Index: Newvar=Index(Var name,”letter”) – Find Position

            Compress: newvar=compress(var name,modifier) – Compress           

Upcase: var name=upcase(var name)

Propcase: var name=propcase(var name)

lowcase: var name=Lowcase(var name)

Tranwrd: var name=Tranwrd(var name, “old char”, “new char”)

Compbl: Var name=Compbl(var name) – compress mult blank

Strip: Var name= Strip( var name) – Remove the leading and trailing blank

Catx: New var= Catx(“Dlm”,Var1, Var2)

Trim: New var=Trim(Var1) ||”,”|| trim(var2)

Left: Var name=Left(Var name) – Move the blanks to left

Length:  New Var= length(var name)

Count: New variable = count(name,"a")