SAS Administration course for Novice by Mitaja Corporation

SAS Course Content
How do I learn it?
Well, you are at the right place, our trainers have trained thousands of students in SAS for both retail as well as corporate clients before launching this initiative.

Base SAS Course Content
Data Structures
Introduction to SAS interface and library structure and definition
Reading data using Datalines and importing and exporting datasets
Infiles statement - reading raw data
Formats and Informats
Variable attributes and data modification using Data and Set statements
Data Management
Using conditional statements to modify data - Where, If and Nested IF
Appending and Merging datasets
SAS Functions for data manipulation
Loops and Arrays in SAS
Report Generation
Basic Proc steps - like Proc Contents
Proc Format, Proc Report and Proc Tabulate
Proc steps for basic statistics - like Proc Univariate and Proc Mean

Advanced SAS Course Content
Proc SQL
Introduction to SQL - basic DBMS and RDBMS concepts
Using SQL Procedures in SAS
Using conditional statements in SQL and aggregate functions
Data manipulation using Proc SQL
SAS Macros
Introduction to Macros
Local and Global declarations
Using built-in macro procedures and functions