Course materials and books will be supplied in the class. You must have your own SAS software to take the class.
Summary
This SAS class is unique to other classes, not only because all the base SAS programming skills are taught in the class, but also because the course content includes how to access Oracle and SQL Server databases from SAS (this topic is not taught in other SAS base classes or books) and how to use SAS PROC SQL. After completing the courses for this class, you will have the ability to import and export raw data files, manipulate and transform data, combine SAS data sets, create basic detail and summary reports using SAS procedures, and identify and correct data syntax and programming logic errors. The students should also be familiar with the enhancements and new functionality that are available in SAS 9
The course includes 10 sessions: Each session is 4 hours, taught by the top SAS expert in Silicon Valley.
You can buy a license of SAS OnDemand for Professionals which is SAS Enterprise Guide 4.3 version (Now only available in US and Canada) - $199 for 6 months:
http://support.sas.com/learn/ondemand/professionals/
http://support.sas.com/learn/ondemand/professionals/
SAS course content:
1 Getting Started with SAS
1.1 The SAS Language
1.2 SAS Data
1.3 SAS Program
1.4 The SAS DATA Steps
1.5 Choosing a Mode for Submitting SAS Programs
1.6 Reading the SAS Log
1.7 Viewing Your Results in the Output Window
1.8 SAS Data Libraries
1.9 Using SAS System Options
2 Getting Data into SAS
2.1 Methods for Getting Your Data into SAS
2.2 Where SAS Finds the Raw Data
2.3 Reading Raw Data Separated by Spaces
2.4 Reading Raw Data Arranged in Columns
2.5 Reading Raw Data Not in Standard Format
2.6 Selected Informats
2.7 Mixing Input Styles
2.8 Controlling Input with Options in the INFILE Statement
2.9 Reading Delimited Files with the DATA Step
2.10 Reading Delimited Files with the IMPORT Procedure
2.11 Reading PC Files with the IMPORT Procedure
2.12 Temporary versus Permanent SAS Data Sets
2.13 Using Permanent SAS Data Sets with LIBNAME Statements
2.14 Using Permanent SAS Data Sets by Direct Referencing
2.15 Listing the Contents of a SAS Data Set
3 Working with SAS Data
3.1 Creating and Redefining Variables
3.2 Using SAS Functions
3.3 Selected SAS Functions
3.4 Using IF-THEN Statements
3.5 Grouping Observations with IF-THEN/ELSE Statements
3.6 Subsetting Your Data
3.7 Working with SAS Dates
3.8 Selected Date Informats, Functions, and Formats
3.9 Using the RETAIN and Sum Statements
3.10 Simplifying Programs with Arrays
3.11 Using Shortcuts for Lists of Variable Names
4 Sorting, Printing, and Summarizing the SAS Data
4.1 Using SAS Procedures
4.2 Subsetting in Procedures with the WHERE Statement
4.3 Sorting Your Data with PROC SORT
4.4 Printing Your Data with PROC PRINT
4.5 Changing the Appearance of Printed Values with Formats
4.6 Selected Standard Formats
4.7 Creating Your Own Formats Using PROC FORMAT
4.8 Writing Simple Custom Reports
4.9 Summarizing Your Data Using PROC MEANS
4.10 Writing Summary Statistics to a SAS Data Set
4.11 Counting Your Data with PROC FREQ
5 Modifying and Combining SAS Data Sets
5.1 Modifying a Data Set Using the SET Statement
5.2 Stacking Data Sets Using the SET Statement
5.3 Interleaving Data Sets Using the SET Statement
5.4 Combining Data Sets Using a One-to-One Match Merge
5.5 Combining Data Sets Using a One-to-Many Match Merge
5.6 Merging Summary Statistics with the Original Data
5.7 Combining a Grand Total with the Original Data
5.8 Updating a Master Data Set with Transactions
5.9 Using SAS Data Set Options
5.10 Tracking and Selecting Observations with the IN= Option
5.11 Writing Multiple Data Sets Using the OUTPUT Statement
5.12 Making Several Observations from One Using the OUTPUT Statement
6 SAS Macro Facility
6.1 Macro Concepts
6.2 Substituting Text with Macro Variables
6.3 Creating Modular Code with Macros
6.4 Adding Parameters to Macros
6.5 Writing Macros with Conditional Logic
6.6 Writing Data-Driven Programs with CALL SYMPUT
7 SAS SQL
7.1 SAS proc SQL Concepts
7.2 SAS/ACCESS connection with relational database
7.3 SAS Pass-Through facility
7.4 SAS basic SQL language
8 Basic Statistical Procedures
8.1 Examining the Distribution of Data with PROC UNIVARIATE
8.2 Producing Statistics with PROC MEANS
8.3 Testing Categorical Data with PROC FREQ
8.4 Examining Correlations with PROC CORR
8.5 Using PROC REG for Simple Regression Analysis
8.6 Reading the Output of PROC REG
8.7 Using PROC ANOVA for One-Way Analysis of Variance
8.8 Reading the Output of PROC ANOVA
8.9 Graphical Interfaces for Statistical Analysis
9 Exporting SAS Data
9.1 Methods for Exporting Your Data
9.2 Writing Files Using the Export Wizard
9.3 Writing Delimited Files with the EXPORT Procedure
9.4 Writing PC Files with the EXPORT Procedure
9.5 Writing Raw Data Files with the DATA Step
9.6 Writing Delimited and HTML Files using ODS
9.7 Sharing SAS Data Sets with Other Types of Computers
1 Getting Started with SAS
1.1 The SAS Language
1.2 SAS Data
1.3 SAS Program
1.4 The SAS DATA Steps
1.5 Choosing a Mode for Submitting SAS Programs
1.6 Reading the SAS Log
1.7 Viewing Your Results in the Output Window
1.8 SAS Data Libraries
1.9 Using SAS System Options
2 Getting Data into SAS
2.1 Methods for Getting Your Data into SAS
2.2 Where SAS Finds the Raw Data
2.3 Reading Raw Data Separated by Spaces
2.4 Reading Raw Data Arranged in Columns
2.5 Reading Raw Data Not in Standard Format
2.6 Selected Informats
2.7 Mixing Input Styles
2.8 Controlling Input with Options in the INFILE Statement
2.9 Reading Delimited Files with the DATA Step
2.10 Reading Delimited Files with the IMPORT Procedure
2.11 Reading PC Files with the IMPORT Procedure
2.12 Temporary versus Permanent SAS Data Sets
2.13 Using Permanent SAS Data Sets with LIBNAME Statements
2.14 Using Permanent SAS Data Sets by Direct Referencing
2.15 Listing the Contents of a SAS Data Set
3 Working with SAS Data
3.1 Creating and Redefining Variables
3.2 Using SAS Functions
3.3 Selected SAS Functions
3.4 Using IF-THEN Statements
3.5 Grouping Observations with IF-THEN/ELSE Statements
3.6 Subsetting Your Data
3.7 Working with SAS Dates
3.8 Selected Date Informats, Functions, and Formats
3.9 Using the RETAIN and Sum Statements
3.10 Simplifying Programs with Arrays
3.11 Using Shortcuts for Lists of Variable Names
4 Sorting, Printing, and Summarizing the SAS Data
4.1 Using SAS Procedures
4.2 Subsetting in Procedures with the WHERE Statement
4.3 Sorting Your Data with PROC SORT
4.4 Printing Your Data with PROC PRINT
4.5 Changing the Appearance of Printed Values with Formats
4.6 Selected Standard Formats
4.7 Creating Your Own Formats Using PROC FORMAT
4.8 Writing Simple Custom Reports
4.9 Summarizing Your Data Using PROC MEANS
4.10 Writing Summary Statistics to a SAS Data Set
4.11 Counting Your Data with PROC FREQ
5 Modifying and Combining SAS Data Sets
5.1 Modifying a Data Set Using the SET Statement
5.2 Stacking Data Sets Using the SET Statement
5.3 Interleaving Data Sets Using the SET Statement
5.4 Combining Data Sets Using a One-to-One Match Merge
5.5 Combining Data Sets Using a One-to-Many Match Merge
5.6 Merging Summary Statistics with the Original Data
5.7 Combining a Grand Total with the Original Data
5.8 Updating a Master Data Set with Transactions
5.9 Using SAS Data Set Options
5.10 Tracking and Selecting Observations with the IN= Option
5.11 Writing Multiple Data Sets Using the OUTPUT Statement
5.12 Making Several Observations from One Using the OUTPUT Statement
6 SAS Macro Facility
6.1 Macro Concepts
6.2 Substituting Text with Macro Variables
6.3 Creating Modular Code with Macros
6.4 Adding Parameters to Macros
6.5 Writing Macros with Conditional Logic
6.6 Writing Data-Driven Programs with CALL SYMPUT
7 SAS SQL
7.1 SAS proc SQL Concepts
7.2 SAS/ACCESS connection with relational database
7.3 SAS Pass-Through facility
7.4 SAS basic SQL language
8 Basic Statistical Procedures
8.1 Examining the Distribution of Data with PROC UNIVARIATE
8.2 Producing Statistics with PROC MEANS
8.3 Testing Categorical Data with PROC FREQ
8.4 Examining Correlations with PROC CORR
8.5 Using PROC REG for Simple Regression Analysis
8.6 Reading the Output of PROC REG
8.7 Using PROC ANOVA for One-Way Analysis of Variance
8.8 Reading the Output of PROC ANOVA
8.9 Graphical Interfaces for Statistical Analysis
9 Exporting SAS Data
9.1 Methods for Exporting Your Data
9.2 Writing Files Using the Export Wizard
9.3 Writing Delimited Files with the EXPORT Procedure
9.4 Writing PC Files with the EXPORT Procedure
9.5 Writing Raw Data Files with the DATA Step
9.6 Writing Delimited and HTML Files using ODS
9.7 Sharing SAS Data Sets with Other Types of Computers
