top of page
Person Analyzing Statistics

Introduction to Base and Advance SAS

Master SAS Programming: Unlock Data Insights with Confidence!

18 hours of 1:1 lessons

Course Overview 

In this SAS Base and Advanced course, students will learn to create and analyze datasets, generate informative reports, query and subset data, and apply advanced techniques like merging datasets, using SQL queries, and leveraging macros for efficient data manipulation. By the end of the course, students will have the skills to confidently work with SAS programming, perform data analysis, and present insights effectively.

18 High Quality 



hands on learning

Customized course structure

Flexible payment plan

By the End of the course Student will be able to

Topic Covered


Data Manupulation

Proc SQL



  1. Students will learn to create, manipulate, and analyze datasets using SAS programming.

  2. They will gain proficiency in generating reports, including frequency distributions and summary statistics, to summarize and present data effectively.

  3. Students will develop skills in data querying and subsetting, enabling them to extract specific information from large datasets.

  4. They will learn advanced techniques such as merging datasets, using arrays, applying SQL queries, and utilizing macros to streamline data manipulation and analysis processes.

What we will be covering in 18 Lesson :
  1. Lesson 1: SAS Course Introduction and SAS Datasets Creation

    • Introduction to the SAS environment and creating permanent libraries.

    • Learning to create SAS datasets, including character and numeric variables.

    • Formatting variables, renaming, labeling, and modifying variable properties.

  2. Lesson 2: Report Generation on SAS

    • Generating reports using PROC PRINT and PROC REPORT.

    • Customizing reports with titles, footnotes, and formatting options.

    • Saving reports in different formats (HTML, PDF, RTF).

  3. Lesson 3: Basic Queries and Subsetting in SAS

    • Subsetting datasets using the KEEP and DROP statements.

    • Using conditional statements (IF-THEN) and operators (WHERE, IN, BETWEEN) for data selection.

    • Performing basic data transformations and calculations.

  4. Lesson 4: Creating Variables in SAS

    • Creating new variables using assignment statements and expressions.

    • Working with SAS functions for data manipulation and transformation.

    • Modifying variable attributes, lengths, and formats.

  5. Lesson 5: SAS and Categorical Data - Splitting Data Sets and Sorting

    • Splitting datasets based on condition statements using IF-THEN and SELECT CASE.

    • Sorting datasets by variables in ascending or descending order.

    • Identifying unique observations using NODUPKEY and NODUP.

  6. Lesson 6: Displaying Frequency Distribution and Using PROC TABULATE

    • Generating frequency distribution reports using PROC FREQ.

    • Cross-tabulating variables and creating summary tables with PROC TABULATE.

    • Applying formats, adding rows and columns, and customizing tabular reports.

  7. Lesson 7: Quantitative Data and SAS - Saving Reports using ODS and PROC MEANS

    • Saving reports in different output formats using the Output Delivery System (ODS).

    • Generating means reports for variables and applying formats.

    • Segmenting reports using CLASS variables and applying conditions with WHERE statement.

  8. Lesson 8: Generating Summary Reports and Descriptive Reports using PROC UNIVARIATE

    • Creating summary reports using PROC PRINT, PROC SUMMARY, and PROC MEANS.

    • Generating descriptive statistics and histograms using PROC UNIVARIATE.

    • Analyzing and visualizing data distributions and outliers.

  9. Lesson 9: Functions in SAS - User-defined Formats, In-built Functions, DATE, TIME, TEXT, and Numeric Functions

    • Creating and using user-defined formats for data manipulation.

    • Exploring in-built functions for date, time, text, and numeric manipulations.

    • Applying functions such as INPUT, PUT, DATE, TIME, SUBSTR, CATX, ROUND, and more.

  10. Lesson 10: Advanced Options - Converting Data Types, Generating Advanced Reports using Procedure Report

    • Converting data types using INPUT and PUT functions.

    • Generating advanced reports with headers, footers, page numbers, and titles using PROC REPORT.

    • Utilizing options like COLUMN, DEFINE, COMPUTE, and BREAK to customize report output.

  11. Lesson 11: Transposing, Combining, and Appending Data Sets

    • Transposing observations into variables using PROC TRANSPOSE.

    • Combining and appending datasets using SET, MERGE, and UPDATE statements.

    • Manipulating data structures and variable names during combining and appending.

  12. Lesson 12: Advanced Options - Merging Data Sets, Using Arrays, Reading from RAW and Delimited Files

    • Merging datasets using different types of joins (FULL, INNER, LEFT, RIGHT).

    • Working with arrays for efficient processing of multiple variables.

    • Reading and importing data from raw and delimited files.

  13. Lesson 13: Learning Proc SQL - Selecting, Creating, Grouping, and Joining Data

    • Performing data manipulations and queries using PROC SQL.

    • Selecting columns, filtering rows, and creating new variables.

    • Grouping and summarizing data, joining datasets using SQL syntax.

  14. Lesson 14: SAS Macros - Creating and Using Macro Programs and Variables

    • Understanding the concept of SAS macros and macro variables.

    • Creating and executing macro programs with positional and keyword parameters.

    • Managing local and global macro variables and incorporating macros in data steps and PROC SQL.

  15. Lesson 15: Advanced SAS (I) - Proc SQL, Advanced Data Manipulation Techniques

    • Using advanced techniques in PROC SQL, including subqueries, correlated queries, and set operators.

    • Performing advanced data manipulations using advanced SQL functions.

    • Leveraging SQL with SAS data step and other procedures.

  16. Lesson 16: Advanced SAS (II) - SAS Macros, Creating and Managing Macro Variables

    • Advanced techniques in SAS macros, such as conditional processing and looping.

    • Creating and managing macro variables within macro programs.

    • Integrating macros with other SAS procedures and data steps.

  17. Lesson 17: Advanced SAS (III) - Advanced Data Manipulation Techniques, PROC SQL and Macros Integration

    • Exploring advanced data manipulation techniques using SAS functions and techniques.

    • Integrating PROC SQL and SAS macros for advanced data processing and manipulation.

    • Creating complex data transformation and analysis scenarios.

  18. Lesson 18: Review and Practice, Final Project or Case Study


+91 8334077555


  • Instagram
  • Facebook
  • Twitter
  • TikTok

Feature Course 

Starting Soon

Just Added

Most View 

Top Paid 



Assignment Help!

Self Help video


Useful Link


Success Page


Private Policy

bottom of page