Home » Uncategorized

100 Free Tutorials to learn SAS

The following links describe a set of free SAS tutorials which help you to learn SAS programming online on your own. It includes tutorials for data exploration and manipulation, predictive modeling and some scenario based examples.

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 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.

  1. Free Download and Install SAS Software
  2. Free SAS Access – No Install Required
  3. Getting Started with SAS
  4. What SAS stands for
  5. Reading / Importing Raw Data into SAS
  6. SAS keyboard shortcuts that every analyst must know

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.

  1. Importing Excel Data into SAS
  2. Read Character Variable of Varying Length
  3. Creating or Modifying a Variable
  4. Dropping variables from a data set in SAS
  5. IF-Then-Else Statements
  6. Where Statement and Dataset Options
  7. WHERE vs. IF Statements
  8. How Data Step and PROC SQL Works
  9. Calculate Frequency Distribution with PROC FREQ
  10. Specify a list of variables
  11. Use of WildCard Character
  12. Character Functions
  13. SAS Date Formats and Informats
  14. Date Functions
  15. INTCK Function with Examples
  16. INTNX Function with Examples
  17. Missing Values in SAS
  18. Convert Character Variable to Date
  19. Convert Numeric Variable to Date
  20. Proc Format
  21. Delete empty rows in SAS
  22. First. and Last. Variables
  23. Proc Sort : Identifying and storing unique and duplicate values
  24. Proc Means : A Detailed Explanation
  25. Use of Multiple Set Statements
  26. Joining and Merging in SAS
  27. SAS Many to Many Merge
  28. Combining and Aggregating Data in SAS
  29. Retain Statement
  30. Proc Transpose Explained
  31. Proc Univariate Tutorial
  32. Proc Rank Explained
  33. Calculating Percentiles with SAS
  34. COALESCE Function
  35. COMPGED Function
  36. SAS Arrays and DO Loops
  37. Proc Tabulate Explained
  38. Length of Numeric Variables
  39. Check number of observations
  40. Pattern Matching with SAS
  41. Send SAS Output to Excel
  42. Handle Variable Name having Spaces
  43. 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.

  1. Proc SQL Tutorial for Beginners (20 Examples)
  2. Proc SQL Joins (Merging)
  3. Combining Tables Vertically with PROC SQL
  4. Insert Rows in the Table
  5. Alter Table and Update Column
  6. Intermediate PROC SQL Tutorial
  7. Proc SQL Self Joins
  8. Connect to Teradata using SAS
  9. Join on Multiple Columns
  10. Join on Multiple Tables
  11. Comparing two tables
  12. Find records only exist in one table
  13. Random Sampling with PROC SQL
  14. Alternative to _N_ in PROC SQL
  15. NODUPKEY with PROC SQL
  16. 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.

  1. SAS Macro Programming
  2. Difference between SYMPUT and SYMGET
  3. Multiple Ampersand Macro Variables
  4. CALL EXECUTE made easy
  5. Stop SAS Macro Processing on Error
  6. Count number of variables assigned in a macro variable
  7. Example of a dynamic %DO Loop
  8. Get Variable Names from a Dataset
  9. Run SAS Procedure on Multiple Datasets
  10. Building SAS Macro Library
  11. Dropping Variables Ending with a Specific String
  12. Importing multiple excel files in a single dataset
  13. Importing multiple excel sheets in a single dataset
  14. Imputing Missing Data
  15. Identify and Remove Outliers with SAS
  16. Test for Normal Distribution
  17. Reordering Variables

Click on the link to view tutorials