Course Introduction
The course is designed to provide advanced, intense, hand-on training on SAS programming, and prepare students for profession as skillful SAS programmers. The focus is on SAS macro facility and SQL programming, as well as statistical procedures. Comprehensive projects give students insight and experience into SAS programming in the real world.
· Students need to familiar with Windows desktop navigation and software installation techniques.
·
Individuals who need to carry out advanced analytics like business intelligence predictive analysis, or be a sas programmer in pharmaceutical industry.
At the end of this course, students should be able to:
1. Understand the concept and benefit of macro programming.
2. Create and reference macro variables.
3. Efficiently utilize macro functions.
4. Develop and apply macro programs to handle complex projects.
5. Develop, maintain and utilize macro library to achieve modular programming.
6. Utilize SQL programming within SAS.
7. Understand the difference between traditional SAS programming and SQL programming.
8. Connect to DBMS, and exchange data between various DBMS and SAS.
9. Understand the difference between pass-through facility and LIBNAME statement in establishing connection to DBMS.
10. Utilize different methods to improve program efficiency
11. Optimize performance of SAS programs
12. Understand commonly used statistical procedures
13. Generate table and listing for clinical studies.
Chapter 1. SAS Macro Facility
¨ Overview of macro facility
¨ Methods to create macro variables
¨ Characteristics of macro variables
¨ Reference macro variables
¨ Use macro variable as prefix vs. suffix
¨ Scanning macro variables
¨ Automatic macro variables
Chapter 2. SAS Macro Statements and Programs
¨ Two types of macro statements
¨ Methods to create macro programs
¨ How to run a macro program
¨ Usage of macro library
Chapter 3. SAS Macro Functions
¨ Macro character functions
¨ Macro evaluation functions
¨ Macro quoting functions
¨ Usage of CALL SYMPUT routine
¨ Usage of SYSFUNC functions
Chapter 4. SQL Fundamental
¨ General information
¨ SQL language adopted by SAS
¨ Feature of PROC SQL
¨ Commonly used SQL statements
¨ Perform query and subquery using PROC SQL
¨ Usage of functions within PROC SQL
Chapter 5. Combine Tables With SQL
¨ Join operation
¨ Category of Joins
¨ Difference between SQL Join and Data Step Merge
¨ Set operations
¨ Category of Set operations
Chapter 6. Manage Tables With SQL
¨ Create tables with PROC SQL
¨ Load data into tables with PROC SQL
¨ Creation and usage of index
¨ Update values within table
¨ Change table structure
¨ Deletion using PROC SQL
Chapter 7. Data Exchange Between SAS and Other Database
¨ General information
¨ SQL Pass-through facility
¨ Use LIBNAME to establish connection between SAS and Database
¨ Update Database table using SQL
¨ Dynamic Data Exchange(DDE)
Chapter 8. Clinical Study Overview
¨ Pharmaceutical Industry and Clinical Study
¨ Four phases of Clinical Studies
¨ Protocol
¨ Process of Clinical Study
¨ Biostatistics vs. Data Management
¨ Responsibility of SAS programmers
Chapter 9. Clinical Study Design and Clinical Data
¨ Commonly used terminology
¨ Parallel vs. Crossover
¨ Randomization
¨ Blinding
¨ Safety data vs. efficacy data
¨ Explanation of different clinical data
Chapter 10. Topic on Efficiency in SAS
¨ Overview of efficiency when using SAS software
¨ Description of Program efficiency
¨ Approaches to improve programming efficiency
¨ Performance in SAS programs
¨ Methods to optimize performance in SAS programs
Chapter 11. Statistics Fundamental
¨ Type I and II Errors
¨ Alpha and beta statistics
¨ Sample Size
¨ Confidence interval
¨ One-tailed vs. two-tailed test
¨ Standard deviation
¨ Standard error
¨ Hypothesis
¨ Relative Risk
Chapter 12. Applied Statistics in Industry
¨ Analysis of variance
¨ Analysis of covariance
¨ Multiple regression analysis
¨ Logistic regression
¨ Factor analysis
SAS Certified Base Programmer for SAS 9.4
SAS Certified Advanced Programmer for SAS 9.4