This course can help prepare you for the following certification exam(s): SAS Certified Specialist: Base Programming Using SAS 9.4, SAS Certified Associate: Programming Fundamentals Using SAS 9.4.

Formats available	Standard Duration
Classroom:	2.0 days
Live Web Classroom:	5 half-day session(s)	System Requirements
e-Learning:	14 hours/180 day license	System Requirements

This course addresses Base SAS software.

• Setting up for this course.
• Understanding DATA step processing.
• Directing DATA step output.

• Setting up for this course.
• Understanding DATA step processing.
• Directing DATA step output.

• Creating an accumulating column.
• Processing data in groups.

• Creating an accumulating column.
• Processing data in groups.

• Understanding SAS functions and CALL routines.
• Using numeric and date functions.
• Using character functions.
• Using special functions to convert column type.

• Understanding SAS functions and CALL routines.
• Using numeric and date functions.
• Using character functions.
• Using special functions to convert column type.

• Creating and using custom formats.
• Creating custom formats from tables.

• Creating and using custom formats.
• Creating custom formats from tables.

• Concatenating tables.
• Merging tables.
• Identifying matching and nonmatching rows.

• Concatenating tables.
• Merging tables.
• Identifying matching and nonmatching rows.

• Using iterative DO loops.
• Using conditional DO loops.

• Using iterative DO loops.
• Using conditional DO loops.

• Restructuring data with the DATA step.
• Restructuring data with the TRANSPOSE procedure.

• Restructuring data with the DATA step.
• Restructuring data with the TRANSPOSE procedure.