Description

This course is a highly intense as well as a formal course in Statistical Analysis Software (SAS). Topics start from the basic concepts to advanced features of SAS. Topics include introduction to DATA and PROC steps, writing a sample SAS program, conversion of raw files into SAS data files, reading and writing date variables using INFORMATS and FORMATS, manipulating SAS variables, use of conditional and comparison operators,  introduction to the concepts of ARRAYs with examples ranging from simple to complex in nature, combining data sets, in-depth discussion of PROC SQL and SAS macros, generating reports using PROC PRINT and PROC REPORT procedures, introduction to Output Delivery System (ODS) to general HTML output.

Prerequisite

No prior knowledge of SAS is expected. However, participants are expected to have the knowledge of basic operations of PCs, such as creating folders, accessing files as well as an understanding of basic system commands on your operating systems. Knowledge of Microsoft products such as Excel, Access, Word and PowerPoint is helpful.

Statistical Analysis Software (SAS) is a very powerful and versatile as well as industry-standard statistical tool to manipulate and analyze large research data. This course prepares those participants who are interested in taking SAS Certification Examinations.

Learning Outcomes

After the completion, participants will be able to have an in-depth understanding of how to

• Create and read SAS data sets
• Use assignment statements as well as conditional and comparison operators to create and manipulate variables
• Manipulate data using arrays
• Combine SAS data sets using concatenation, interleaving, one-to-one reading & merging, match merging and update features
• Write SAS macros to improve the programming efficiency
• Use PROC SQL to query the data base
• Generate reports using PROC PRINT and PROC REPORT as well as HTML output using ODS

Topics of Study

• Fundamental Concepts
• Conversion of External Text Files into SAS Data Sets, Data Step Programming, and Creation and Implementation of User- Defined Formats
• Reading Raw Data and Date & Time Values
• Working with Variables
• Manipulating & Transforming Data with Built-in Subroutines
• Arrays and Reading Hierarchical Files
• Reading and Combining SAS Data Sets
• Introduction to Proc SQL (Structured Query Language)
• Macro Programming
• Generating a Basic Report using Proc Print statement
• Proc Report to Produce List and Summary Reports
• Generating Descriptive Statistics and HTML Output