Overview of SAS Functions & Procedures

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.

You can find a complete list of all SAS functions and its documentation here.