Introduction to SAS Base Certificate
SAS Base Certificate
Introduction to SAS and SAS Fundamental Concepts
- Overview of the SAS System
- What Can SAS Do?
- Components of the SAS Language
- SAS Display Manager System
- Basic Structure of SAS
- Preliminary Concepts and Rules
- SAS Resources
Accessing Data and Creating Data Structures
Accessing existing SAS Data sets
- Introduction to SAS datasets
- Accessing existing SAS data sets
Reading Raw data file
- Introduction
- Reading fixed-width files
- DATA step processing
- Reading delimited raw data files
SAS Expression and Functions
- Overview of Operators in SAS
- Infix Operators in SAS
- SAS expression & Conditional expression (WHERE and IF)
- Numeric functions
- SAS Time and Date
- Character functions
- Global Statements
Overview of Multiple Data Sets
- Concatenating data set using Set statement
- Interleaving several datasets
- Modifying (creating) data set
- Concatenating data set using PROC APPEND
- Merging datasets (Match-merging SAS data set, eliminating Non-matches)
- Updating dataset
- Outputting multiple observation
- Writing to multiple SAS datasets
- PROC EXPORT/IMPORT
- PROC CONTENTS
Managing Data
- Conditionally IF-THEN-ELSE execute SAS statements
- SORT observations in a SAS data set
- Controlling the output of variables and observations
- KEEP, DROP, DELETE, RENAME, RETAIN, BY, FILE, PUT and OUTPUT Statements
- Applying formats and creating user-defined format by PROC FORMAT
- SAS DO-LOOPS
- SAS Array
Summarizing DATA
- Generating summary statistics by numerical functions
- Creating an accumulating total variable
- Accumulating totals for a group of data
Generating Reports
- Generating reports using the PRINT procedure
- Generating frequency tables using PROC FREQ procedure
- Generating report using MEANS procedure
- Generating report using REPORT procedure
- Enhancing report through the use of labels, SAS format, titles, footnotes and SAS System reporting options
- Introduction to ODS
- Generating HTML/PDF output
Debugging Techniques
- Using the PUT Statement