SAS Online Training

SAS Course Content

  • BASICS BEFORE STARTING SAS:

  • DATAWAREHOSING Concepts
  • What is ETL
  • ETL Concepts
  • What is OLAP
  • SAS:

  • What is SAS
  • History of SAS
  • Modules available SAS
  • GETTING STARTED WITH SAS SYSTEMS:

  • Basic operating system commands, operating system file structures
  • Managing windows in SAS window environment
  • Use of different kind of SAS products and how to use in SAS application.
  • Difference between the SAS products.
  • Why using the SAS 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
  • To run SAS application on different modes
  • Reading internal reading and printing l raw data into SAS
  • Read any type of external raw data into SAS
  • Reading raw data SAS 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
  • Using a single libref to reference some or all SAS libraries reading and printing mixed records formats.
  • Reading packed and zoned decimal data working with EBCDIC and ASCII data
  • Reading data from data set to another data set.
  • To manage the SAS window environment used with global options.
  • Reducing memory requirements with BUFFNO and BUFSIZE working with SAS data set 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
  • Generation data sets to create historical information SAS
  • To expert data from data sets to delimiter files using with data set block
  • Understand error messages in the SAS Log and debug your program
  • Use with Error Handling concepts
  • PERFORM ITERATIVE PROCESSING ON DATA:

  • Using Do loops for repetitive calculations and processing
  • Using Arrays to process across an observations and processing
  • Using DO WHILE and DO UNTIL statements for conditional looping
  • INDEXING TECHINIQUES AND USES:

  • When to use indexes
  • Creating and deleting indexes
  • Index advantages and disadvantages
  • UTILITIES TO MANAGE AND WORK WITH DATASETS:

  • Data using append procedure to add date values in existing dataset
  • Using the update statement to update data in existing dataset.
  • Using the MODIFY statements to update and modify data in place
  • Merging concepts
  • Data transformation
  • Concatenation concept in merging
  • Interleaving concept and merging
  • Different kind of match merging using MERGE statement using the contribution (IN=) option in merge concept
  • Using ODS concept to generate reports
  • BASE SAS PROCEDURES:

  • Organize and sort SAS data sets and working with duplicates
  • To generate listing output use print
  • Comparing data sets with proc compare
  • To create user defined informat and format statements use format
  • Using proc copy to copy data sets
  • Importance of contents procedure
  • Reading data from dataset for reporting use report
  • Using Proc Datasets to modify data set structure, attributes, how to use permanent formats, Setting up Integrity Constraints to maintain clean data and Setting up indexes
  • Role of ODS concepts to reporting SAS output
  • To generate SAS output in different panels like RTF, HTML,PDF and XML Using ODS
  • How to use PROC SQL to retrieve INFORMATION from their Data:

  • Introduction to SQL Concepts
  • The origin of SQL and why we use it.
  • Create new tables, indexes , views and reports
  • SIMPLE QUERIES:

  • Understanding to SQL Concepts
  • How to specify columns and subset rows
  • Using functions to summarize and group data
  • Ordering data and formatting out
  • Performing group analysis, remerging and sub queries
  • JOINING DATA:

  • What are Cartesian Products, what is join
  • Inner, FULL, OUTER, LEFT and RIGHT Joins
  • Set Operator us such as union and intersection joining multiple tables
  • PROC SQL as compared to the data step
  • WORKING WITH TABLES, VIEWS AND indexes:

  • Creating Indexes and table in SQL
  • Why we use Views in SQL
  • Performance and space ISSUES
  • ADVANCED SQL Topics:

  • HOW TO USE SAS MACROS IN SQL
  • How dictionary table and views can simplify programming SQL options
  • How to retrieve Raw data different from DATABASES to SAS environment using SQL Statements
  • To create table in different databases using SAS sql statement
  • To manage in different databases using SAS Sql Statements
  • PASS TROUGH FACILITY:

  • Uses of pass through facility
  • How to communicate with other database like Access, Oracle
  • To control and manage other databases fro the SAS.
  • To access required data from other databases
  • To create DATAWAREHOUSING environment
  • Basic Statistical Procedures (SAS/STAT) and reporting Procedure:

  • To summary statistical Analysis Summary Procedure
  • Producing Statistical with means Procedure
  • Testing Categorical Data with FREQ PROCEDURE
  • Reporting areas in SAS
  • To generate report use with Proc Report
  • How to work with SAS/ACCESS & SAS /Connect:

  • To import data from different PC files use import procedure
  • To export data from different source use access procedure
  • To export data from datasets to different PC files use export Procedures
  • Uses of DBLoad procedure and how to work
  • To transport datasets one environment to another environment and one version to another version to another version (windows to UNIX) use with cprot and cimport procedures
  • How to use Upload Procedure
  • How to use Download Procedure
  • How to work with MACRO LANGUAGE INTRODUCTION to MACROS:

  • How the SAS macros Language Works
  • What is the role of macro in SAS
  • Introduction to tokening, compiling and executing a SAS program
  • How the macro Processor Works
  • Applying MACRO VARIABLES in a SAS PROGRAM:

  • Applying automatic macro variables
  • Designing customized macro variables
  • Submitting the macro variables in SAS Programming
  • Displaying MACRO VARIABLES VALUES in the SAS log
  • Applying quoting functions with macros
  • Incorporating SAS Macros in the DATA STEP:

  • Designing macro variables during Data step Execution
  • In directing referencing Macro variables
  • Resolving Macro variables during DATA STEP EXECUTION
  • Under staining the functionality and application of the SYSMGET function and SYSMPUT routine
  • Using the INTO clause to build macro variables during PROC SQL execution
  • RUNNING MACRO PROGRAMS IN SAS SOFTWARE:

  • Designing and implementing simple macros and reduce customizing SAS application
  • To Develop Reusable Application use with MACRO
  • Specifying conditional coding inside a macro
  • The macro compilation and execution processes in the macro processor SAS system options used for debugging macros
  • Reviewing error and warning log messages displayed by the macro processor
  • Designing and using macros containing parameters within them
  • Using positional and keyword parameters in macro calls
  • Difference macros and symbol table Hierarchies
  • Concepts in MACRO FUNCTIONS, MACRO INTERFACE AND MACRO Quoting Functions and how to use MACRO CODING.
  • Techniques for Storing MACROS:

  • Understanding the auto call feature
  • Permanently storing and using compiled macros
  • Writing Efficient macro programs
  • DEBUGGING SAS PROGRAMS:

  • SAS programs that work
  • Fixing Programs that don't work
  • Searching for the missing semicolon
  • Input statement reaching past the end of line
  • Lost card
  • Invalid Data
  • How to handle different kind of SAS errors
  • Missing VALUES were Generated
  • Numeric values have been converted to Character
  • WRONG results but no error message
  • The data step Debugger
  • SAS Truncated a character variable
  • SAS stops in the middle of the job
  • SAS runs pout of memory or disk space

Contact Us

Tel: +91-8897400222
USA: +1-512-800-7568
EMAIL: info@mentorsinn.com

Testimonials

"The SAS training was good. Trainer helped me to learn the course quickly and perfectly... thanks to Mentors Inn" - Santhosh (SAS)