Course Overview
SAS Advance Modules – PROC SQL:
SAS which stands for Statistical Analysis System is a software developed by the SAS Institute a private company based out of Cary, North Carolina, USA. Its primary objective is to be able to process large chunks of data and analyse it to aid in the process of intelligent decision making. SAS has has been widely accepted in the world and it accounts for almost 70% of the data processing market place. SAS/Graph® Training is an essential course, as it is a prerequisite for many courses in the statistical analysis domain.
Through this training you shall be able to Create SAS data sets and run SAS programs effectively.
- SAS SQL Overview
- Data Step V/S. Proc Sql Processing
- Proc SQL Basics
- Performing Advanced Queries using Proc SQL
- Combining Tables Horizontally using Proc SQL
- Combining Tables Vertically using Proc SQL
- Creating and Managing Indexes using Proc SQL
- Creating and Managing Views using Proc SQL
- Managing Processing using Proc SQL
The training will include the following;
Target Customers:
- Statistical Business Analysts
- Data analysts
- Risk analysts
- Market researchers
- Statisticians
- Anyone who wants to learn statistical analysis using SAS
Pre-Requisites:
- Basic computer working knowledge
- Idea of creating data sheets with help of Excel software and workings of the same.