Functions in SAS Character Functions in SAS Numeric Functions in SAS Date & Time Functions in SAS and Datatype Conversion Functions in SAS With Examples
------------------------------------
Character functions
-------------------------------------
Manipulating the character data
Change the Case of Characters
Remove Characters from Strings
Search for Characters
Extract Parts of Strings
Join Two or More Strings Together Remove Blanks from Strings Divide Strings into "Words" Compute the
Length of Strings
Count the Number of Letters or Substrings in a String Substitute Letters or Words in Strings
Compare Strings
✓ Length and LengthC
✓ Compbl
✓ Compress
✓ Index,Indexc,Indexw
✓ Find,Findc,Findw
✓ Upcase, Lowcase, Propcase
✓ Substr
✓ Scan
✓ Translate & Tranwrd
✓ Countc and Countw
✓ Compare
✓ Left,Right,Trim and Strip
✓ Cat,Catt,Cats,Catx,||
-------------------------------------------------------------
DATATYPE CONVERSION FUNCTIONS
--------------------------------------------------------------
✓ Input and Put Functions
Numeric functions –
✓ INT
✓ ABS
✓ CEIL
✓ FLOOR
✓ ROUND
✓ MIN
✓ MAX
✓ MEAN
✓ SUM
✓ SQRT
✓ LOG
✓ FACT
✓ MOD
✓ LAG
✓ DIF
-------------------------------------
Date & Time Functions
-------------------------------------
✓ TODAY
✓ DAY
✓ MONTH
✓ YEAR
✓ MDY
✓ HOUR
✓ MINUTE
✓ SECOND
✓ HMS
✓ DATEPART
✓ TIMEPART
✓ YRDIF
✓ INTCK
✓ INTNX