ISQS 7000-081, Advanced Problem Solving with SAS

Spring 2009 Schedule  

Weekly meeting: 1-2;30p Friday, classroom (TBD)

 

Textbooks

Data Preparation for Data Mining Using SAS® Software (DPDM)

SAS® Programming II (SASII)

SAS® Programming III (SASIII)

Design and Analysis of Probability Surveys, SAS® Course Notes (SUPRB)

SAS® Neural Network Modeling (DMNN)

SAS 9.1 Macro Language Reference (MACRO)

 

Stage 1: Data Preparation for Analytics

 

Course Components:

·         Input and output

·         Summarizing data

·         Handling different types of data

·         Data transformations

·         Data processing

·         SAS SQL

 

Deliverables:

1)     A summary report of the project

2)     A knowledge structure of your learning process and the suggested structure

 

Note:

 

Two primary instructor-led courses by SAS for the certificate exam of SAS base programming:

 

SAS Programming 1: Essentials

SAS Programming 2: Data Manipulation Techniques
(these are available in the training centers as well as Live Web)

 

SAS self-paced e-learning: SAS Certification: Base Programming for SAS 9 (Self-Paced e-Learning)

 

For exam candidates with considerable SAS programming experience, this review course provides a thorough overview of the programming knowledge representative on the examination.

*       SAS Certification Review: Base Programming for SAS 9

Date

Days

Contents

Readings

Notes

Week1

Jan 7-9

Orientation, Schedule

DPDM, SAS II

Read the materials and prepare a plan for the learning of this stage  

Week2

Jan12-16

SAS Data Step

DPDM, SAS II

  

Week3

Jan 19-23

SAS Data Mart

DPDM, SAS II

 

Week4

Jan 26-30

SAS Data Mart

DPDM, SAS II

 

Week5

Feb 2-6

Presentations

DPDM, SAS II

 

Stage 2: Simulation and Data Processing

 

Course Components:

·         Combining data

·         Lookup tables

·         By-group processing and sorting

·         Data storage space control

·         SAS program efficiency improvement

·         Generating SAS Code Using Macros

·         Use of Macro variables

·         Manipulating Macro Variable Values with Macro Functions

·         Macro processing

·         Macro expression

·         Macro quoting

·         Interfacing Macro facilities

 

Deliverables:

1)     A summary report of the project

2)     A knowledge structure of your learning process and the suggested structure

 

Note:

 

For those intending to take the certification exam of advanced SAS programming, SAS provides three primary instructor-led courses for the exam:

*       SAS Programming 3: Advanced Techniques and Efficiencies

*       SAS SQL 1: Essentials

*       SAS Macro Language 1: Essentials
(these are available in the training centers as well as Live Web)

Date

Days

Contents

Readings

Notes

Week6

Feb 9-13

SASIII, SAS Macro

Week7

Feb 16-20

SASIII, SAS Macro

 

Week8

Feb 23-27

Presentations

SASIII, SAS Macro

Week9

Mar 2-6

SASIII, SAS Macro

 

Week10

Mar 9-13

SASIII, SAS Macro

Week11

Mar 16-20

Spring Break

 

Week12

Mar 23-27

SASIII, SAS Macro

Stage 3: Data Analysis Programming

 

Course Components:

·         Supervised prediction

·         Network architecture

·         Model training

·         Model complexity

·         Neural Net for predictive modeling

·         Nonlinear autoregression

·         Simple random sampling

·         Stratified sampling

·         Cluster sampling

·         Handling nonresponse

·         Case studies

Deliverables:

1)     A summary report of the project

2)     A knowledge structure of your learning process and the suggested structure

Date

Days

Contents

Readings

Notes

Week13

Mar 30-Apr 3

DMNN, SUPRB

 

Week14

Apr 6-10

DMNN, SUPRB

Week15

Apr 13-17

DMNN, SUPRB

 

Week16

Apr 20-24

DMNN, SUPRB

Week17

Apr 27-May 1

Presentations

DMNN, SUPRB

 

 

Week18

May 4-8

Final Exam