This is an instructional workshop for the practitioners to learn base SAS and SAS macros to be a professional programmer/analyst.

Topics Covered

Module 1 - Base SAS Hours -7 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 Means Module 2 - Advanced SAS Hours -7 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 what it do not cover! Statistical Modeling

Who should attend

Anyone willing to hone SAS skills

Pre-requisites

Basic programming knowledge in any environment is an addition advantage. As sucj no pre requisite.

What you need to bring

Laptop with SAS 9.1 installed""

Key Takeaways

Will have hands on experience on SAS computation and go for a SAS certification.