Here you find an overview of all the SAS functions on this website.
- CAT: Concatenates strings regardless of leading and trailing blanks.
- CATT: Concatenates strings removing trailing blanks.
- CATS: Concatenates strings removing leading and trailing blanks.
- CATX: Concatenates strings removing leading and trailing blanks using a separator.
- COALESCE: Returns the first non-missing numeric value.
- COALESCEC: Returns the first non-missing character value.
- COMPRESS: Removes whitespace or other characters from a string.
- COUNTC: Counts the number of specific characters in a string.
- DATEPART: Converts a DateTime into a Date variable.
- DAY: Extracts the Day from a Date variable.
- DHMS: Converts a Date into a DateTime variable.
- DIVIDE: Prevents division by zero.
- FIND: Checks if a string contains a specific pattern.
- HOUR: Extracts the Hour from a DateTime variable.
- INTCK(I): Calculates the difference between 2 dates.
- INTCK (II): Calculates the difference between 2 dates.
- INTNX (I): Increments a date by a day, week, month, etc.
- INTNX (II): Increments a date by a day, week, month, etc.
- LEFT: Remove leading blanks.
- LENGTH: Returns the number of characters in a string.
- LOWCASE: Converts a string in lowercase.
- MDY: Creates date variables.
- MINUTE: Extracts the Minute from a DateTime variable.
- MONTH: Extracts the Month from a Date variable.
- PROPCASE: Converts a string in proper case.
- QTR: Extracts the Quarter from a Date variable.
- ROUND: Rounds a number to the nearest multiple of a given constant
- SCAN: Gets the nth word of a string.
- SECOND: Extracts the Second from a DateTime variable.
- SQRT: Calculates the Square Root of a Number.
- STRIP: Remove leading and trailing blanks.
- SUBSTR: Gets a substring from a longer string.
- TRANSPOSE: Transposes a data set from long to wide.
- TRANWRD: Finds and replaces a string.
- TRIM: Remove trailing blanks.
- UPCASE: Converts a string in upper case.
- WEEK: Extracts the Week from a Date variable.
- YEAR: Extracts the Year from a Date variable.
Here you find an overview of all the SAS procedures on this website.
- PROC COMPARE: Compares two SAS datasets.
- PROC EXPORT (CSV): Exports data from SAS as a CSV file.
- PROC EXPORT (Excel): Exports data from SAS to Excel.
- PROC EXPORT (TXT): Exports data from SAS as a TXT file.
- PROC IMPORT (CSV): Imports a CSV file into SAS.
- PROC SGPLOT (Histogram): Creates a histogram.
- PROC SURVEYSELECT: Generates Random Samples.
You can find a complete list of all SAS functions and its documentation here.