SAS course Beginner level by RoboDatics

Complete Base and Advance course with real time examples and case studies.
This course will be conducted at RoboDatics office located at Saket MB Road. Please see below the course content:

TECHNICAL

• Introduction
Introduction to SAS Programming
Working in the SAS Environment
Working with the windows
• Enhance editor window
• Log window
• Output window
• Result window
• Explorer window
• Program editor window

Overview of libraries, Dataset, Variables and Metadata
• Datasets
• Referencing Files in SAS Libraries
• Contents
• Variable Names and Values
• Data step execution
• Data Handling

Basic concepts
• Creating a SAS Programs
• Components of SAS Programs
• Characteristics of SAS Programs
• Layout of SAS Programs

Understanding Data step Processing
• Program data vector(PDV)
• Compilation Phase
• Execution Phase

Reading Raw Data from External File
• Infile statement
• Filename statement

Options & Titles
• Global options
• Local Options

Statements
• Global Statements
• Local Statements
Input Styles
• List input
• Column input
• Formatted input
• Modified input
• Named input

Trailing
• @
• @@

Informats and Formats
Informats
• Character informats
• Numeric informats
• Date and time informats

Formats
• Character formats
• Numeric formats
• Date and time formats

Functions
• Arithmetic Functions
• String Functions
• Date and Time Functions

Combining SAS Datasets
• Concatenating
• Merging
• One-to-one merging
• One-to-many merging
• Many-to-one merging
• Many-to-many merging
• Matching merging
• Interleaving
• Updating

Control Statements
• If statement and if else statement
• If then else statement
• Where statement
• Loops (do, do until, do while)
Writing Data to External Files
• File Statement
• Put Statement

Output Delivery System (ODS)
• Fundamentals of the ODS
• ODS and the Data step
• Syntax for ODS Enhanced features in a Data step

• Introduction to ODS language Statements
• Dictionary of ODS language Statements

Debugging of Errors
• Writing SAS programs that work
• Fixing programs that Don’t work
• Types of Errors

Working with SAS Inbuilt Procedures
• Proc Print Proc Transpose
• Proc Sort Proc Freq
• Proc Contents Proc Formats
• Proc Append Proc Tabulate
• Proc Import Proc Report
• Proc Export Proc Printto
• Proc Datasets Proc Means
• Proc Surveyselect Proc Summary
• Proc Ttest Proc Anova and many more.

SAS/GRAPH
• Introduction to Graphs
• Types of Graphs
 Chart
 Plot
 Illustration of symbol options

SAS/MACROS
• Introduction to Macro Language Elements
• Introduction to Macro Variables
 Automatic Macro Variables
 User defined Macro Variables

• Introduction to Macro Processing
• Macro Statements
• Macro Functions

SAS/SQL
• Introduction to Proc SQL
• Creating tables
• Inserting data into tables
• Alter the tables & etc…
• Update
• Modifying the tables
• Integration of Database
• Connecting to a DBMS Using the SQL Procedure Pass-Through Facility
• Connecting to a excel Using the SQL Procedure Pass-Through Facility
• Connecting to a access Using the SQL Procedure Pass-Through Facility

• Connecting to a DBMS Using the Libname Statement
Retrieving Data from Multiple tables
• Inner Join
• Outer Join (Right, Left, Full)