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