SAS stands for Statistical Analysis System. It is an integrated system of software products provided by SAS Institute that enables the programmer to perform: data entry, retrieval, management, and mining, report writing and graphics, statistical analysis, business planning, forecasting, and decision support, OR and Project management, Data warehousing, Remote computing etc. It integrates with many SAS business solutions that enable large scale software solutions for areas such as HR management, financial management, business intelligence, customer relationship management and more. The duration of the training is 2 months. Classes will be conducted for 1.5 hour a day (Monday - Friday). We have a well equipped computer lab for students to practice at their feasible time.

Topics Covered

TOPICS HISTORY OF SAS BASIC THEORY & RULES ETC. SAS WINDOWING ENVIRONMENT CREATION OF LIBRARIES SAS PROGRAMMING (BRIEFLY) • DATASTEP • PROC STEP WAYS TO READ DATA (BRIEFLY) BACK END PROCESS INSTALLATION PROCESS DATASTEP: DATA STATEMENT & OPTIONS INFILE STATEMENT & OPTIONS INPUT STATEMENT & OPTIONS DATALINES & OPTIONS INFORMATS & FORMATS HOW DATES WORKS IN SAS LENGTH, LABEL STATEMENTS ATTRIB STATEMENT & INDIVIDUAL ATTRIBUTES SUM STATEMENT STOP, RETAIN STATEMENTS IF, IF/THEN/ELSE STATEMENT WHERE STATEMENT DO, DO ITERATIVE, DO UNTIL & DO WHILE CONCATENATION & INTEREAVING MERGE & UPDATE FUNCTIONS • DATE FUNCTIONS • CHARACTER FUNCTIONS • NUMERIC FUNCTIONS ARRAYS OTHERS MISSING CONCEPTS REVIEW OF DATASTEP EXAM & DISCUSSION PROC STEP: UTILITY PROCEDURES • PROC IMPORT • PROC EXPORT • PROC CONTENTS • PROC APPEND • PROC SORT • PROC COPY • PROC DATASETS • PROC OPTIONS • PROC SETINIT • PROC PWENCODE • PROC COMPARE • PROC TRANSPOSE • PROC FORMAT • PROC RANK • PROC CPORT • PROC CIMPORT • PROC MIGRATE REPORTING PROCEDURES • PROC PRINT • PROC TABULATE • PROC REPORT • _NULL_ REPORT (Data step Reporting) SAS/GRAPHS & ODS CONCEPTS • PROC GPLOT • PROC GCHART • PROC SGHART • ODS SAS/STAT BASICS OF STATISTICS STATISTICAL PROCEDURES • PROC MEANS • PROC SUMMARY • PROC UNIVARIATE • PROC FREQ • PROC CORR • PROC REG • PROC ANOVA • TTEST • Chi SQUARE • HYPOTHESIS • OTHER STATISTICAL PROCEDURES REVIEW OF PROC STEP EXAM & DISCUSSION SAS/ACCESS BASIC THEORY OF SAS/ACCESS WAYS TO ACCESS DATA FROM DIFFERENT SOURCES LIKE NOTEPADS, EXCEL SHEETS, MSACCESS, ORACLE, DB2, SYBASE AND TERRADATA etc… • PROC IMPORT • INFILE STATEMENT • SQL PASS THRU QUERY • LIBNAME STATEMENT • PROC DBLOAD • PROC ACCESS SQL (PROC SQL) REVIEW, EXAM & DISCUSSION SAS/MACROS REVIEW, EXAM & DISCUSSION PERFORMANANCE TUNING TESTING/DEBUGGING TECHNIQUES ADDITIONAL FEATURES BETWEEN SAS VERSIONS

Who should attend

Bachelors with Mathematics, Computer Science, Statistics and commerce for entry level programming positions. M.C.A., B. Tech, M.Sc., (Mathematics, Statistics, Computer science, Operations Research, Physics, Life Sciences) B. Pharma, M. Pharma, M. Sc Biotechnology, Chemistry and life sciences for positions in Pharma industry as clinical data analyst and other positions relating to clinical trials. People with Domain experience in Accounts, HR, Banking, Insurance, Pharma industry, etc,.

Pre-requisites

There are no pre-requisites for learning SAS.

What you need to bring

N/A

Key Takeaways

This course can help prepare you for the following certification exam(s): SAS Base Programming Exam for SAS 9. Learn how to: * Navigate the SAS windowing environment * Plan and write SAS programs to solve common data analysis problems * Read various types of data into SAS data sets * Validate and clean SAS data sets * Create SAS variables and subset data * Combine SAS data sets * Create and enhance listing and summary reports. * Using various SAS Procs. * Creating fancy reports using ODS * Making your code dynamic using macros Don’t hesitant to take your first step towards starting to learn SAS, and don’t be afraid of investing your time and money in a system which makes your career shine better.