SAS Programming

SAS - base and advance
Course duration:

50 hours | 2 months (Live online/classroom training+ Projects + assignment/case studies + Interview preparation)

Training Mode:​

Online & Classroom

Course Fees:
  • Group training – INR 20000 | USD 550 (Other countries)
  • Individual training – INR 35000 | USD 750 (Other countries).
Pre-requisites for SAS Course:

To attend this highly evolved Python course, candidates must have basic understanding of computer and MS Excel.

SAS Programming Certification:

At end of our course, you will be work on various projects. Once you completed your assigned projects with expected results we will issue SAS Certificate.

Syllabus - program of study:

  • What is SAS
  • SAS GUI
  • Installation of SAS tool
  • SAS Windows – Log, Explorer, Output, Search, Editor etc.
  • SAS Products and Components
  • Syntax rules
  • SAS modules
  • Working with data sets
  • Overview of SAS Functions
  • Creating the SAS libraries
  • Permanent library
  • Temporary library
  • Importing different types of raw data
  • Connecting to data bases
  • Exporting SAS data file
  • SAS Procedures for data Import/Export - Proc import/Proc export
  • Data understanding - Proc contents/Proc print etc.
  • Variable attributes - Format, In-format, Length, SAS Labels, Commenting etc.
  • SAS Operators
  • Arithmetical
  • Logical
  • Comparison
  • Understanding about Input Buffer and PDV
  • Data execution
  • Debugging SAS Codes
  • Data & Proc Steps - Statements & options
  • SAS Options - OBS, FSTOBS, NOOBS, Keep and Drop etc
  • SAS Conditional Statements - (If, Where, If else, select when etc.)
  • Difference between WHERE and IF
  • PROC SORT
  • PROC FREQ
  • PROC SUMMARY
  • PROC RANK
  • PROC EXPORT
  • PROC DATASET
  • PROC TRANSPOSE
  • PROC CORR etc.
  • Data Manipulation Steps
  • Sorting,
  • Filtering,
  • Duplicates,
  • Derived Variables,
  • Sampling,
  • Data type conversions,
  • Renaming,
  • Formatting
  • Merging and Appending
  • Data manipulation Tools
  • Operators
  • Functions
  • Procedures
  • Loops
  • Arrays
  • SAS Functions (Text, Numerical, Contains, Input/Put, Date/Time etc.)
  • By Group processing
  • Accumulation of variables
  • Explicit Output Statements
  • Constructing DO Loops
  • DO Loop Execution
  • Decrementing Do Loops
  • Nesting DO Loops
  • Conditionally Executing DO Loops
  • Creating Samples
  • Creating and Understanding SAS Arrays
  • Defining an Array
  • Variable Lists as Array Elements
  • Referencing Elements of an Array
  • Compilation and Execution, Using the DIM Function
  • Creating Variables in an ARRAY Statement
  • Creating Temporary Array Elements
  • Basics of exploratory data analysis
  • Descriptive statistics - Frequency tables
  • Univariate Analysis - Distribution of data
  • Bivariate Analysis - Cross Tabulation
  • SAS Procedures for Data Analysis
  • proc freq
  • proc means
  • proc summary
  • proc tabulate
  • Proc univariate etc.
  • Introduction to Reporting
  • Introduction to ODS
  • Data Optimization
  • How to generate files (pdf, html, docs etc.) using SAS
  • Exporting data sets into different formats - proc export
  • Understanding PROC GCHART
  • Various Graphs and Charts
  • Pie chart
  • Bar chart
  • Histogram
  • Boxplot
  • Line chart
  • Scattered plot
  • Plotting variables with PROC GPLO
  • SQL Statements in SAS
  • SELECT,
  • CASE,
  • JOIN,
  • UNION,
  • Sorting Data etc.
  • Combining tables vertically with PROC SQL
  • Understanding select statement
  • From
  • Where
  • Group by
  • Having
  • Order by
  • Proc SQL Joins (Merging)
  • Full join
  • Inner Join
  • Left Join
  • Right Join
  • Outer Join
  • Data creation/extraction
  • Data Manipulation in Proc SQL
  • Summarizing and grouping data in Proc SQL
  • Concept of sub queries, indexes etc.
  • Connecting SAS to external databases
  • Comparing two tables
  • Reporting in proc SQL
  • Understand SAS macro
  • Creating/defining macro variables
  • SAS Macro Variables
  • SAS Global Macro Variables
  • SAS Local Macro Variables
  • Comparison – Global vs Local Variables
  • Defining/calling macros
  • Create a macro variable using a %LET assignment statement
  • Use a macro variable in a SAS program
  • Write and invoke a basic SAS macro
  • Write and invoke a SAS macro that uses parameters
  • Write a macro with conditional macro %IF-%THEN-%ELSE statements
  • Use and understand automatic macro variables such as & SYSDATE and & SYSDAY
  • Use CALL SYMPUT to write data-driven programs
  • Functions of SAS Macros
  • %UPCASE() Function
  • %SUBSTR() Function
  • Case studies
  • Assignments
  • projects with industry data
  • Case studies
  • Assignments
  • projects with industry data