- SAS Introduction
- Fundaments of creating Datasets
- Create Temporary Datasets
- Handling Missing Values
- Define Variables Length
- Understanding of library
- Create Permanent Datasets
- Creating a SAS Programs
- Submitting SAS Program
- Reading SAS Log
- Browsing the Data Portion
- Components of SAS Programs
- Data from Excel/CSV
- Data from Text file
- List input
- Column input
- Formatted input
- Column Input
- Format Input
- Date and Time Input
- System Defined Formats
- User Defined Formats
- Numeric Formats
- Character Formats
- Date Formats
- Temporary Formats
- Permanents Formats
- Labeling of Variable Names
- Arithmetic Functions
- Character Functions
- Date Functions
- Subsetting a SAS Data Set
- Creating More Than One Subset Data Set in One DATA Step
- Adding Observations to a SAS Data Set
- Using IF-Then-Else Statement
- Nested If Statements
- Select and Case Statement
- Creating Multiple Datasets
- Proc Append
- Proc Print
- Proc Contents
- Proc Means
- Proc Sort
- Proc Datasets
- Proc plot
- Proc Gplot
- Proc Chart
- Proc Gchart
- Proc Summary
- Proc Freq
- Proc Tabulate
- Proc Report
- Proc Univariate
- Do Loop Statement
- Nested Loop Statement
- Conditional Loop
- While and Until
- Leave & Continue
- Simple Array
- Array with Dim Statement
- Lower and upper bound Arrary
- One Dimensional Array
- Two Dimensional Array
- Table Append using Data Steps
- Interleave
- Concatenation of Tables
- Inner Join using Data Steps
- Outer Join using Data Steps
- Full Join using Data Steps
- Anti Join using Data Steps
- Basic SQL Commands
- Case Statement
- Full Joins using SQL
- Inner Join using SQL
- Outer Join using SQL
- Anti Join using SQL
- SQL to create Macro Variable
- Rules to create Macro
- Compilation of program
- Creating Macro Variables
- Call Symput and call Symget Method
- Macro Functions
- Debugging Options
- Saving Macro Permanently
Course Detail
Fees:
15,000
Class Mode:
Classroom/Online
Duration
1 Months
Course Content
S-A-S Script
Course Benefits
STUDENT WILL ABLE TO LEARN BASE+ADVANCE SAS PROGRAMMING.
KEY FEATURES
1 Month (2 HOURS EACH CLASS) of Classroom Training.
Session have assignments and daily task.
Recorded Videos and presentation for reference.
Books and related data sets in form of excel and csv.
Interview Questions for related topic.
Used Case Study and Projects to understand real scenarios.