SAS course for Intermediate trainees by PValue Solutions

BASE SAS
Getting Started with SAS
• overview of the SAS System
• introduction to SAS programs
• running SAS programs
• mastering fundamental concepts
• diagnosing and correcting syntax errors
• exploring the SAS environment
Getting Familiar with SAS Data Sets
• explaining the concept of a SAS data library
Producing List Reports
• getting started with the PRINT procedure
• sequencing and grouping observations
• identifying observations
• using special WHERE statement operators
Enhancing Output
• customizing report appearance
• formatting data values
• creating HTML reports
Creating SAS Data Sets
• reading raw data files using column input and formatted input
• examining data errors
• assigning variable attributes
• changing variable attributes
• reading Microsoft Excel spreadsheets
Programming with the DATA Step
• reading SAS data sets and creating variables
• executing statements conditionally
• dropping and keeping variables
• reading date fields from Microsoft Excel spreadsheets
Combining SAS Data Sets
• concatenating SAS data sets
• merging SAS data sets
• combining SAS data sets using additional features
Producing Summary Reports
• introduction to summary reports
• generating basic summary reports
• using the REPORT procedure
• creating reports using the TABULATE procedure
SAS/GRAPH Software
• producing bar and pie charts
• enhancing output
• producing plots
CONTENTS OF SAS PROG
Course Contents – BASE SAS
Introduction
• review of SAS basics
• review of DATA step processing
• review of displaying SAS data sets
• working with existing SAS data sets
Controlling Input and Output
• outputting multiple observations
• writing to multiple SAS data sets
• selecting variables and observations
• writing to external files
Summarizing Data
• creating an accumulating total variable
• accumulating totals for a group of data
Reading and Writing Different Types of Data
• reading delimited raw data files
• controlling when a record loads
• reading hierarchical raw data files
Data Transformations
• manipulating character variables
• manipulating numeric variables
• manipulating numeric variables based on dates
• converting variable type
Processing Data Iteratively
• performing DO loop processing
• performing SAS array processing
Combining SAS Data Sets
• match-merging two or more SAS data sets
• performing simple joins using the SQL procedure