SAS

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