The Basics of SAS Functions( Definition)
The Basics of SAS Functions( Uses of SAS Functions)
The Basics of SAS Functions( SAS Functions Categories)
SAS Functions Syntax (Arguments and Variable Lists )
Example: Multiple Arguments
SAS Functions Syntax (Target Variables)
Converting Data with Functions (A Word about Converting Data)
Converting Data with Functions (Potential Problems of Omitting INPUT or PUT)
Converting Data with Functions (Automatic Character-to-Numeric Conversion)
Converting Data with Functions (When Automatic Conversion Occurs)
Converting Data with Functions (A Word about Converting DataRestriction for WHERE Expressions )
Converting Data with Functions (Explicit Character-to-Numeric Conversion)
Example: INPUT Function
Converting Data with Functions (Automatic Numeric-to-Character Conversion)
Converting Data with Functions (Explicit Numeric-to-Character Conversion)
Manipulating SAS Date Values with Functions (SAS Date Functions)
Manipulating SAS Date Values with Functions(YEAR, QTR, MONTH, and DAY Functions)
Example: Finding the Year and Month
Example: Finding the Year
WEEKDAY Function( Overview of the WEEKDAY Function)
Example: WEEKDAY Function
MDY Function( Overview of the MDY Function)
Example: MDY Function
Example: Finding the Date
DATE and TODAY Functions (Overview of the DATE Function )
DATE and TODAY Functions (Overview of the TODAY Function )
Example: The DATE and TODAY Functions
INTCK Function (Overview of the INTCK Function )
INTCK Function (Details )
Examples: INTCK Function
Example: The INTCK Function and Periodic Events
INTNX Function (Overview of the INTNX Function )
INTNX Function (Details)
Example: INTNX Function
DATDIF and YRDIF Functions
Modifying Character Values with Functions (SCAN Function)
Modifying Character Values with Functions (Details)
Example: Create New Name Variables
Specifying Delimiters
Modifying Character Values with Functions (Specifying Multiple Delimiters )
Modifying Character Values with Functions (Default Delimiters)
Modifying Character Values with Functions (Specifying Variable Length)
SUBSTR Function (Overview of the SUBSTR Function)
Example: SUBSTR Function
SUBSTR Function(Replacing Text Using SUBSTR)
SUBSTR Function(Positioning the SUBSTR Function)
SCAN versus SUBSTR Functions
LEFT and RIGHT Functions (Overview of the LEFT and RIGHT Functions )
Example: LEFT Function
Example: RIGHT Function
Concatenation Operator
TRIM Function (Overview of the TRIM Function )
Example: TRIM Function
CATX Function (Overview of the CATX Function )
Example: Create New Variable Using CATX Function
INDEX Function (Overview of the INDEX Function )
Example: Search for Occurrences of a Phrase
Finding a String Regardless of Case
FIND Function( Overview of the FIND Function)
FIND Function( Details)
Example: Find Word Processing Jobs in a Data Set
UPCASE Function
LOWCASE Function
PROPCASE Function
TRANWRD Function( Overview of the TRANWRD Function)
Example: Update Variables in Place Using TRANWRD Function
COMPBL Function
COMPRESS Function( Overview of the COMPRESS Function )
Example: Compress a Character String
Example: Compress a Character String Using a Modifier
Modifying Numeric Values with Functions
Modifying Numeric Values with Functions(CEIL and FLOOR Functions )
INT Function
ROUND Function
Nesting SAS Functions
quiz