Advance SAS Training
SAS BASE TRAINING SYLLABUS
INTRODUCTION TO SAS PROGRAMMING
- Working in the SAS Environment
- Working with the Windows
- Enhance Editor
- Result Window
- Log Window
- Explorer Window
- Output Window
- Program Editor Window
BASICS OF SAS LANGUAGE
- SAS Libraries
- Data Sets
- Cube
- Data View
- Referencing Files in Catalog
- Creating a SAS Program
- Components of SAS Program
- Characteristics of SAS Program
- Layout of SAS Progra
ACCESSING DATA
- Use FORMATTED, LIST and COLUMN input to read raw data files
- Use INFILE statement options to control processing when reading raw data files
- Use various components of an INPUT statement to process raw data files including column and line pointer controls, and trailing @ controls
- Combine SAS data sets using the DATA step
CREATING SAS DATA SETS
- Create temporary and permanent SAS data sets
- Create and manipulate SAS date values
- Control which observations and variables in a SAS data set are processed and output
DATA STEP PROCESSING
- Program Data Vector (PDV)
- Execution Phase and Compilation Phase
- Get Started with Output Delivery System ( ODS )
STATEMENT OPTIONS
- Global Statements
- Local Statements
- List Input
- Modified Input
- Column Input
- Named Input
MANAGING DATA
- Exploring SAS data libraries using base SAS utility procedures
- Sorting observations in a SAS data set
- Conditionally execute SAS statements
- Use assignment statements in the DATA step
- Modify variable attributes using options and statements in the DATA step
- Use SAS functions to manipulate character data, numeric data, and SAS date values
- Use SAS functions to convert character data to numeric and vice versa
COMBINING SAS DATA SETS
- Concatenation
- One-One Merging
- Match Merging
- One-One Reading
- Updating or Setting
CONDITIONAL STATEMENTS
- IF & IF THEN statement
- IF ELSE statement
- Where condition
- Like , Into Statements
- Loops ( Do, While )
WRITING DATA TO EXTERNAL FILES
- File Statement
- Put Statement
GENERATING REPORTS
- Generate list reports using the PRINT and REPORT procedures
- Enhance reports through the use of labels, SAS formats, user-defined formats
- Generate summary reports and frequency tables using base SAS procedures
DEBUGGING AND HANDLING ERRORS
- Identify and resolve programming logic errors
- Checking for Errors, Warnings, Un-Initialization , missing values
- Recognize and correct syntax errors
- Examine and resolve data errors
PROCEDURES
- Proc Sort
- Proc Transpose
- Proc Print
- Proc Contents
- Proc Formats, Proc Compare
- Proc Append, Proc Tabulate
- Proc Report
- Proc Import, Proc Export
- Proc Freq
- Proc Means
SAS ADVANCE TRAINING SYLLABUS
ADVANCE SAS TRAINING SYLLABUS
- Introduction to SAS Macro Language Elements
- Introduction to Macro Variables
- Automatic Macro Variables
- User define Macro Variables
- How Macro processing will undergo inside the SAS system
- Macro Statements
- Macro Functions
- Autocall Macros
SAS MACROS
- SAS Libraries
- Introduction to SAS Macro Language Elements
- Introduction to Macro Variables
- Automatic Macro Variables
- User define Macro Variables
- How Macro processing will undergo inside the SAS system
- Macro Statements
- Macro Functions
- Autocall Macros
ACCESSING DATA USING SQL
- Introduction to Proc SQL
- Generate detail reports by working with a single table or joining tables using PROC SQL
- Generate summary reports by working with a single table or joining tables using PROC SQL
- Inserting data into Tables
- Alter & update the tables
- Construct sub queries within a PROC SQL step
- SQL pass through Facility
- Connecting to DBMS
- Natural Joins
- Inner Joins
- Outer Joins
- Access Dictionary Tables using the SQL procedure
- Work with indexes using the macro interface/creating macro variables with SQL, defining integrity constraints
MACRO PROCESSING
- Creating and using user-defined and automatic macro variables within the SAS Macro Language
- Automating programs by defining and calling macros using the SAS Macro Language
- Various system options available for macro debugging
- Displaying values of user-defined and automatic macro variables in SAS log
- Understand the use and implantation of macro function
SAS DI STUDIO (Data Integration Studio)
- Exploring SAS Data Integration Studio
- Working on Change Management
- Explaining how to define source, target data structures and designing jobs.
- Introduction to jobs and the job editor
- Working with propagation and mappings
- working with intermediate files
- working with the extract transformation
- working with summary statistics transformation
- explore status handling for transformations and jobs
- working with the data validation transformation
- working with the sort transformation
- working with the append transformation
- working with the transpose transformation
- working with the apply lookup standardization transformation
- iterating a job with Loop transformations
- basics of the Table Loader transformation
- load styles of the Table Loader transformation
- table properties and load techniques of the Table Loader transformation
- Defining slowly changing dimensions
- Using the SCD type 2 Loader and Change Data capture transformations (Pre & Post Process).
- analyzing metadata using impact analysis
Who Should do this course ?
Candidates from various quantitative backgrounds, like Engineering, Finance, Maths, Statistics, Business Management who want to develop hands-on SAS skills and clear the Base SAS certification exam.
- Course Duration 40 Hours
- Classes 12
- Tools SAS
- Learning Mode Live/Video Base
- Fees 26,499
NOTE; FEE IS NON-REFUNDABLE