SAS Online Training

SAS Training Overview
• SAS data sets
• The two parts of a SAS program
• Choosing a mode for submitting SAS programs
• Windows and commands in the SAS windowing environment
• Submitting a program in the SAS windowing environment
• Reading the SAS log
• Viewing your results in the output window
• Creating HTML Output
• SAS data sets with SAS explorer
• Using SAS system Options
• Creation of Independent and Dependent libraries
Getting your data into SAS
• Methods for getting your data into SAS
• Reading files with the Import wizard
• Reading raw data separated by spaces
• Reading raw data arranged in columns
• Selected formats
• Reading Messy raw data
• Reading delimited files with the data step
• Reading delimited files with the Import procedure
• Reading PC files with the Import procedure
• Using permanent SAS data sets with Libname statements
Exporting your data
• Methods for exporting your data
• Writing files using the wizard
• Writing delimited and HTML files using ODS
• Writing PC files with the export procedure
Modifying and combining SAS Data sets
• Modifying a Data set using the SET Statement
• Interleaving data sets using the SET Statement
• Combining Data sets using a One-to-one match-merge
• Combining Data sets using a One-to-many match-merge
• Updating a master data set with a transactions data set
• Using SAS data set Options
• Tracking and selecting Observations with the IN-Option
• Making several observations from one using the output statement changing observations to variables using
• proc transpose
• Reading messy raw data
• Converting character data type into numeric data type and vice-versa
Working with your data
• Creating and redefining a variable
• Using SAS functions
• Using IF-THEN statements
• Grouping observations with IF-THEN/ELSE Statements
• Subsetting your data
• Working with SAS dates
• Selected Date Informants, Functions and Formats
• Using the RETAIN and Sum statements
• Simplifying programs with Arrays
• Using of Put Statements
• Differences between the Put statement and the Put function
• Using of Label Statement
• Using of Length Statement
• Using of Location
• Using of Files statement
• Using of Put Functions
• Using of Where a statement
• Using of By statement
• Concept of Formats/Informants
• Creating of User-defined Formats and Informats
• Sum statement
• Using of OBS and FIRSTOBS
• Using of Modify statement
• Using of pointers
• File system in SAS
• Execution process of a data step
Enhancing your output with ODS
• Concepts of the Output Delivery system
• Tracing and Selecting procedure Output
• Creating SAS datasets from procedure Output
• Using ODS statements to create HTML output
• Using ODS statements to create PDF output
• Using ODS statements to create RTF output
• Using ODS statements to create PS output
• Using of ODS trace on and trace off statements
• Using of ODS select statement
Automatic Variables
• Using of Automatic Variables
• Using of N
• Using of Null
• Using of Error
Procedures in Base SAS
• Proc Contents
• Proc Append
• Proc Options
• Proc Import
• Proc Export
• Proc Compare
• Proc Datasets
• Proc Transpose
• Proc Format
• Proc Copy
• Proc Sort
• Using of Nodupkeys and noduprec in proc sort
Reporting procedures
• Proc Report
• Proc Tabulate
• Proc Forms
• Proc Chart
• Proc Gchart
• Proc Plot
SAS Macros
• Definition of Macro
• Calling of Macro Variables
• Using of Macro Program
• Adding parameters to Macros
• Examples on Macros
• Macro Functions
SAS SQL
• Introduction to SAS/SQL
• Proc SQL
• Proc SQL Statement
• Concepts of DDL Commands
• Concepts of DML Commands
• Concepts of DQL/DRL Commands
• Concept of Validate Statement
• Describe statement
• Coalesce function
• Upper function
• Order by & group by clauses
JOINS
• Reflexive jobs
• Inner Joins
• Outer Joins
• Normal Joins
• Natural Joins
• Cross Join
• Union Joins
OPERATORS
• Union all
• Intersect
• Except
SAS ACCESS & SAS CONNECT
• Introduction to SAS Access & SAS Connect
• Interface to the RDBMS
• Interface to the PC files
SAS / Warehouse Administrator
• Introduction to Database Management System
• Introduction to ETL
• Related Topic on ETL
SAS / STAT
• Introduction to SAS / Statistics
• Proc Univariate
• Proc Means
• Proc Summary
• Proc Rank
• Proc Freq
• Proc Corr
• Proc Reg
• Proc Anova
• Proc GLM
DEBUGGING YOUR SAS PROGRAMS
• Proc Print Writing SAS programs that work
• Proc Contents Writing SAS programs that don’t work
• Proc Append Searching for missing semicolon
• Proc Compare Lost card
• Proc Options Invalid Data
• Proc Datasets Numeric Values have been converted
• Proc Format to Character and vice-versa