Course Overview
Advanced SAS – 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 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 PROC SQL programs effectively.
The training will include the following;
1) Introduction
2) Difference between Data & Proc Step
3) Procedures Using Proc SQL
- Creation
- Reading
- Updation
- Deletion
- Sorting
- Summarizing & grouping
- Querying multiple tables
4) SQL JOIN
- CROSS JOIN
- INNER JOIN
- LEFT JOIN
- RIGHT JOIN
- FULL JOIN
5) Subqueries
6) Set Operators
Target Customers:
- Statistical Business Analysts
- Data 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.