SAS

Statistical Analysis System

(BASE and ADVANCE)

About SAS

SAS is a scalable integrated software environment designed for data access, transformation and reporting. SAS provides a set of tools that perform data analysis for an organization.SAS is a set of solutions for enterprise-wide business users and provides a powerful fourth-generation programming language for performing tasks such as these: data entry, retrieval, and management report writing and graphics.

SAS programmer/Analyst jobs do not require a degree incomputer science.

Module 1 - Base SAS

• Data Structures
  
• Introduction to SAS interface and library structure and definition
  
• Reading data using Datalines and importing and exporting datasets
  
• Infiles statement - reading raw data
  
• Formats and Informats
  
• Variable attributes and data modification using Data and Set statements
  
• Data Management
  
• Using conditional statements to modify data - Where, If and Nested IF
  
• Appending and Merging datasets
  
• SAS Functions for data manipulation
  
• Loops and Arrays in SAS
  
• Report Generation
  
• Basic Proc steps - like Proc Contents
  
• Proc Format, Proc Report and Proc Tabulate
  
• Proc steps for basic statistics - like Proc Univariate and Proc Means
  

Module 2 - Advanced SAS

• Proc SQL
  
• Introduction to SQL - basic DBMS and RDBMS concepts
  
• Using SQL Procedures in SAS
  
• Using conditional statements in SQL and aggregate functions
  
• Data manipulation using Proc SQL
  
• SAS Macros
  
• Introduction to Macros
  
• Local and Global declarations
  
• Using built-in macro procedures and functions
  

The training is provided as per SAS Foundation Certified Course Contents.

The course also includes :

• Basics of SQL
• Data Management Techniques
• Case Studies
• Course Notes
• Project
• Interview questions