Course Details
SAS Programming I
Course ID : QI-PRG-201
Duration : WEEKDAY sessions from mid-May - Sept 2017 (40 hr SESSIONS): Refer below for details - intensive In-Class Training to assist students complete assignments; PLEASE send email to register_qicrb@quantument.com for pricing/group discounts
Location : New Jersey, USA & Bangalore, India (depending on no. of students)
Mode of Training : In-Class (Weekends/Weekdays)/On-line (depending on no. of students registered)
Weekend Session 1 : 40 hrs: 9.00AM - 5.00PM: Includes a weekday, Saturday and Sunday for 2017 Summer and beyond
Evening Session 1 : 40 hrs: To be announced
Dates: Instructor Access via Email : Post-class access
For Registration/Pricing, call: : Please call our office in New Jersey at 609-454-5635 and email info_india@quantument.com for pricing/registration
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