Duration : 60 Hrs | 1hr theory/day 1hr Practical


course logistics

overview of Foundation SAS

SAS syntax review

navigating the SAS windowing environment (self-study)


Getting Started with SAS

introduction to SAS programs

submitting a SAS program


Working with SAS Syntax

mastering fundamental concepts

diagnosing and correcting syntax errors


Getting Familiar with SAS Data Sets

examining descriptor and data portions

accessing SAS data libraries

accessing relational databases (self-study)


Reading SAS Data Sets

introduction to reading data

using SAS data as input

subsetting observations and variables

adding permanent attributes


Reading Excel Worksheets

using Excel data as input

doing more with Excel worksheets (self-study)


Reading Delimited Raw Data Files

using standard delimited data as input

using nonstandard delimited data as input


Validating and Cleaning Data

introduction to validating and cleaning data

examining data errors when reading raw data files

validating data with the PRINT and FREQ procedures

validating data with the MEANS and UNIVARIATE procedures

cleaning invalid data


Manipulating Data

creating variables

creating variables conditionally

subsetting observations


Combining SAS Data Sets

introduction to combining data sets

appending a data set (self-study)

concatenating data sets

merging data sets one-to-one

merging data sets one-to-many

merging data sets with nonmatches

Enhancing Reports


using global statements

adding labels and formats

creating user-defined formats

subsetting and grouping observations

directing output to external files


Producing Summary Reports

using the FREQ procedure

using the MEANS procedure

using the TABULATE procedure (self-study)


Introduction to Graphics Using SAS/GRAPH (Self-Study)

creating bar and pie charts

creating plots

enhancing output


Controlling Input and Output

outputting multiple observations

writing to multiple SAS data sets

selecting variables and observations


Summarizing Data

creating an accumulating total variable

accumulating totals for a group of data


Reading Raw Data Files

reading raw data files with formatted input

controlling when a record loads

additional techniques for list input (self-study)


Data Transformations

manipulating character values

manipulating numeric values

converting variable type


Debugging Techniques

using the PUTLOG statement

using the DEBUG option


Processing Data Iteratively

DO-loop processing

SAS array processing

using SAS arrays


Restructuring a Data Set

rotating with the DATA step

using the TRANSPOSE procedure


Combining SAS Data Sets

using data manipulation techniques with match-merging


Other SAS Languages

an overview of other languages

using the SQL procedure

the SAS macro language

Related course


Related Links