SAS programming Certification Training

✔ History
✔ SAS comes in ERP sector or not? Why?
✔ What is Clinical Research Study?
✔ What is SOP (Standard Operating Procedure)?
✔ What is DBMS?
✔ What is SAP (Statistical Analysis Plan)?

✔ Managing windows in window environment
✔ Why using the S-A-S in different sectors.
✔ How to use the data step to read and manipulate complex forms of data
✔ Write Data and Proc steps.
✔ Data step compile and execution
✔ Read any type of external raw data
✔ Reading raw data Environment into DATA SET using Input statement & advance INLIFE statement options
✔ Working with Data Storage in SAS libraries creation for user-defined libraries and multi-engine architecture
✔ Reading data from data set to another data set.
✔ To manage the SAS window environment used with global options.
✔ To manage existing data with controlling statements and expressions
✔ Creating Summary Information, SAS Functions, Transforming Data
✔ Changing variable types using the PUT and INPUT functions summarizing data files
✔ To expert data from data sets to delimiter files using with data set block
✔ Understand error messages in the Log and debug your program

✔ Using Do loops for repetitive calculations and processing
✔ Using Arrays to process across observations and processing

✔ Using the update statement to update data in the existing dataset.
✔ Using the MODIFY statements to update and modify data in place Merging concepts
✔ Concatenation concept in merging
✔ Interleaving concepts and merging
✔ Different kinds of match merging using MERGE statement using the contribution (IN=) option in merge concept
✔ Using ODS concept to generate reports
✔ Role of ODS concepts in reporting SAS output
✔ To generate output in different panels like RTF, HTML,PDF and XML Using ODS

✔ UTILITY PROCEDURES:

✔ IMPORT PROCEDURE
✔ EXPORT PROCEDURE
✔ DB LOAD PROCEDURE
✔ COPY PROCEDURE
✔ CPORT PROCEDURE
✔ COMFORT PROCEDURE
✔ DELETE PROCEDURE
✔ SETTING PROCEDURE
✔ OPTIONS PROCEDURE
✔ TEMPLATE PROCEDURE
✔ APPEND PROCEDURE
✔ COMPARE PROCEDURE
✔ SORT PROCEDURE
✔ DATASETS PROCEDURE
✔ PRINT TO PROCEDURE
✔ 1FORMAT PROCEDURE
✔ TRANSPOSE PROCEDURE
✔ ACCESS PROCEDURE

✔ REPORTING PROCEDURES:

✔ PRINT PROCEDURE
✔ TABULATE PROCEDURE
✔ REPORT PROCEDURE
✔ CHART PROCEDURE
✔ CHART PROCEDURE
✔ PLOT PROCEDURE
✔ GPLOT PROCEDURE

✔ STAT PROCEDURES:

✔ MEANS PROCEDURE
✔ SUMMARY PROCEDURE
✔ UNIVARIATE PROCEDURE
✔ CORR PROCEDURE
✔ FREQ PROCEDURE
✔ TEST PROCEDURE
✔ FREQ PROCEDURE
✔ RANK
✔ TEST PROCEDURE
✔ ANOVA PROCEDURE
✔ REG PROCEDURE
✔ GLM PROCEDURE

✔ Introduction to SQL Concepts
✔ Create new tables, indexes, views, and reports

✔ What are Cartesian Products, what is join
✔ Inner, FULL, OUTER, LEFT, and RIGHT Joins
Union join, Cross joins
✔ Set Operator us such as union and intersection joining multiple tables

✔ HOW TO USE SAS MACROS IN SQL
✔ How to retrieve Raw data different from DATABASES to SAS environment using SQL Statements
✔ To create tables in different databases using SAS SQL statement
✔ To manage in different databases using SAS SQL Statements

✔ Uses of pass-through facility
✔ How to communicate with other databases like Access, Oracle, DB2
✔ To control and manage other databases from SAS

✔ Macro Concepts & Advantages
✔ SAS Macro Language
✔ Macros And Macro Variables
✔ Creating Macro Variables & Using Macro Variables
✔ Creating Modular Code With Macros
✔ Invoking A Macro
✔ Adding Parameters to Macros
✔ Writing Macros With Conditional Logic
✔ Using Various Procedures in Macro Variables
✔ Nesting of Macros
✔ Multiple And Multi-Level Macros
✔ Macro Functions