**SAS Tutorial**

SAS (Statistical analysis system) is one of the most popular software for data analysis. It is widely used for various purposes such as data management, data mining, report writing, statistical analysis, business modeling, applications development and data warehousing. Knowing SAS is an asset in many job markets. It is tagged 'leader' in Advanced Analytics Platforms as per Gartner 2015 and 2016 reports.

SAS Tutorial For Beginner to Advanced Users |

SAS Tutorial for Beginners

The following tutorials are designed for beginners who have no programming background or new to SAS programming language. These tutorials explain how to download and install SAS software and how to get started with SAS.
SAS Tutorials - Base SAS

These tutorials are designed to cover all the topics of Base SAS certification. It includes explanation of topics on data structures, data management, data analysis and report generation.- Importing Excel Data into SAS
- Read Character Variable of Varying Length
- Creating or Modifying a Variable
- Dropping variables from a data set in SAS
- IF-Then-Else Statements
- Where Statement and Dataset Options
- WHERE vs. IF Statements
- How Data Step and PROC SQL Works
- Calculate Frequency Distribution with PROC FREQ
- Specify a list of variables
- Use of WildCard Character
- Character Functions
- SAS Date Formats and Informats
- Date Functions
- INTCK Function with Examples
- INTNX Function with Examples
- Missing Values in SAS
- Convert Character Variable to Date
- Convert Numeric Variable to Date
- Proc Format
- Delete empty rows in SAS
- First. and Last. Variables
- Proc Sort : Identifying and storing unique and duplicate values
- Proc Means : A Detailed Explanation
- Use of Multiple Set Statements
- Joining and Merging in SAS
- SAS Many to Many Merge
- Combining and Aggregating Data in SAS
- Retain Statement
- Proc Transpose Explained
- Proc Univariate Tutorial
- Proc Rank Explained
- Calculating Percentiles with SAS
- COALESCE Function
- COMPGED Function
- SAS Arrays and DO Loops
- Proc Tabulate Explained
- Length of Numeric Variables
- Pattern Matching with SAS
- Send SAS Output to Excel
- Handle Variable Name having Spaces
- Speed Up SAS Code with Index

SAS Advanced : Proc SQL

These tutorials are intended for people who are new to SQL programming language. PROC SQL is an advanced SAS procedure that helps to run SQL queries to manage and manipulate data. These tutorials include Introduction of SQL with examples, PROC SQL Joins, conditional statements and useful tips and tricks of SQL etc.- Proc SQL Tutorial for Beginners (20 Examples)
- Proc SQL Joins (Merging)
- Combining Tables Vertically with PROC SQL
- Insert Rows in the Table
- Alter Table and Update Column
- Intermediate PROC SQL Tutorial
- Proc SQL Self Joins
- Connect to Teradata using SAS
- Join on Multiple Columns
- Join on Multiple Tables
- Comparing two tables
- Find records only exist in one table
- Random Sampling with PROC SQL
- Alternative to _N_ in PROC SQL
- NODUPKEY with PROC SQL
- Use DISTINCT in CASE WHEN

SAS Advanced : SAS Macros

These tutorials provide useful guide for learning SAS Macros. It includes useful tips and tricks of SAS Macro programming and outlines real world examples of SAS Macros.
- SAS Macro Programming
- Difference between SYMPUT and SYMGET
- Multiple Ampersand Macro Variables
- CALL EXECUTE made easy
- Stop SAS Macro Processing on Error
- Count number of variables assigned in a macro variable
- Example of a dynamic %DO Loop
- Get Variable Names from a Dataset
- Run SAS Procedure on Multiple Datasets
- Building SAS Macro Library
- Dropping Variables Ending with a Specific String
- Importing multiple excel files in a single dataset
- Importing multiple excel sheets in a single dataset
- Imputing Missing Data
- Identify and Remove Outliers with SAS
- Test for Normal Distribution
- Reordering Variables

Practical Problem-Solving SAS Examples

It helps you to get your hands dirty with practical SAS coding examples. You would both learn and practice by understanding these examples.

- Read ZIP or GZ Files in SAS
- Avoid Truncation while Importing CSV Files
- Custom Sort Order in SAS
- Count Distinct Values in Variables
- Count Missing and Non-Missing across columns
- 4 ways to find maximum value in a group with SAS
- Extract last 4 characters / digits of value
- When to use IF and %IF in SAS Macro
- Find Variable with Max or Min across Rows
- 4 Ways to calculate LAG and LEAD
- Dropping Variables Ending with a Specific String
- Identifying and Storing Unique and Duplicate Values
- Delete empty rows in SAS
- Comparing two data sets
- Reordering Variables
- Transpose Multiple Variables
- Reverse order of data
- Extracting numbers and text from alphanumeric string
- Dropping variables ending with a specific string
- Add leading zeros
- Remove leading zeros
- Advanced String Manipulation
- Fuzzy String Matching
- Calculating Percentiles with SAS
- Extract Second Non-Missing Value
- Zip / Unzip SAS Datasets
- Clearing Log and Output Windows
- Variable Names Truncated in PROC Logistic
- Driving Distance with SAS
- Send Emails with Attachments via SAS
- Run R code from SAS
- VBA in SAS
- Wish Christmas with SAS

SAS Analytics / Statistics Tutorial

These tutorials would help you to understand data and statistical analysis with SAS. It includes tutorials on performing descriptive and inferential statistics, linear and logistic regression, time series analysis, variable selection and reduction, cluster analysis and predictive modeling with SAS etc.

- Data Exploration with PROC UNIVARIATE
- Linear Regression with SAS
- Logistic Regression with SAS
- Time Series Forecasting : ARIMA
- Cluster Analysis using SAS
- Ridge Regression with SAS
- Principal Component Analysis (PCA) with SAS
- Variable Selection (PROC VARCLUS) Explained
- Checking Assumptions of Multiple Regression
- Checking Homoscedasticity with SAS
- Scoring Linear Regression Model with SAS
- Detecting Interaction in Regression Model
- Bootstrapping Logistic Regression
- Chi-Square as Variable Reduction Technique
- Oversampling for rare event
- Multiple Imputation with SAS
- Brier Score for Model Calibration
- 2 Ways to score validation sample in PROC LOGISTIC
- Calculating AUC of Validation Dataset
- Calculating AUC from a predicted probability columns
- Calculating KS Test

SAS Certification Questions and Answers

These tutorials outline the sample SAS Base and SAS Statistical Business Analyst certification questions and answers which helps you prepare for the certification. All questions asked are multiple choice questions, in which there is only one correct answer. It includes questions on SAS functions, procedures, data management, ANOVA, regression, predictive modeling and report generation etc.

SAS Interview Questions and Answers

It covers more than 50 most frequently asked base and advanced SAS interview questions and answers. It is a collection of SAS Interviews questions beneficial for both freshers and experienced programmer.

Analytics Companies

It covers questions about "Scope of SAS", list of companies using SAS in India by geography and domain.

**SAS Graphs / Charts**

It includes tips and techniques to create common graphs or charts with SAS. It also provides methods to decorate charts so that they look professional and add WOW factor to your presentation.

Guide : Create Charts with SAS