SAS

LIVE ONLINE INTERACTIVE

Attend our Instructor Led Live OnLine Interactive Training

28000 Enroll now

Video Based Self Training

Attend our Video Based Selfed Paced Training

40 Hours Enroll now

OVERVIEW

The Course goes with the aim to understand key concepts about:

Professionals from IT field are constantly moving toward this amazing programming tool and there are several reasons behind this. Below are mentioned some of the reasons why you should pursue the SAS training course.

SAS is a remarkably popular data visualisation and management tool used by millions of organisations all over the world for the purpose of storing, retrieving, analysing and manipulating their large data.
It is very easy to learn and offers a great scope in the market where the candidate will easily earn a competitive income which will be increased with experience.
SAS is a flexible and powerful statistical tool which can run on many platforms such as Windows and Unix.
Since SAS is a fourth generation language, writing programming codes in SAS is very easy and the graphic user interface provides is quite flexible.
SAS can easily be integrated with other database software such as Oracle, DB2 and MS Excel.
SAS is able to fulfil any company’s data analysis demands very easily and thus companies all over the world are constantly looking for candidates who are skilled in SAS.
There is a huge community for SAS programming online, where you can find answers to your debt easily and instantly.
Statistics show that the number of SAS users has been increasing rapidly for the last couple of years and it will see no change in upcoming years as well.

COURSE MAP

Course Map:

	Topics
Introduction	-What is SAS
	-Introduction of SAS Software .
	-Parts of SAS Window.
	-Mode of Submitting SAS Programme.
	-Structure of SAS Dataset
	-Rules for Variable Name and Dataset
	-Types of Variables.
	-Types of Numeric Variables
	-Elements of the SAS Language.
Creating Data Structures	-Types of SAS library
	-Creating Library .
	-Assigning Library.
	-Create null, temporary and permanent SAS data sets.
	-Phases of Programme Processing-Data step processing.
	-Input buffer and PDV.
	-Title, Footnotes ,Commenting code, and Label.
	-Informats and Formats.
	-Proc Format.
	-Options
	-Control which observations and variables in a SAS data set are processed and output
	-Questions.
Accessing Data	-What is Raw Data.
	-Reading various Raw files .
	-Types of Inputs .Use of FORMATTED, LIST and COLUMN input to read raw data files.
	-Delimiters.
	-Reading delimited file.
	-Use INFILE statement options to control processing when reading raw data files.
	-Use various components of an INPUT statement to process raw data files including column and line pointer controls, and trailing @ controls.
	-Creating single records from multiple input row.
	– Null statement.
	-Import and export
	-Saving log automatically
	Use DATA Step statements to export data to standard and comma delimited raw data files
	-Questions.
Managing Data	-Sort observations in a SAS data set.
	-Removing Duplicates .
	-Types of Combining Datasets.
	-Transfering records or copy records from one dataset to another.
	-Transpose.
	-Questions.
Managing Data	-Conditionally execute SAS statements.
	-Create and manipulate SAS date values.
	-Use assignment statements in the DATA step.
	-Modify variable attributes using options and statements in the DATA step.
	-Accumulate sub-totals and totals using DATA step statements using by statement.
	-Use SAS functions to convert character data to numeric and vice versa.
	-Introduction to length and Retain Statements
	-Knowing contents of datasets.
	-Creating and modifiying the variables.
	-Creating Multiple Datasets in single step.
	-Questions.
Handling Errors	-Identify and resolve programming logic errors
	-Recognize and correct syntax errors.
	-Examine and resolve data errors.
Managing Data	-SAS Functions.
	-Use SAS functions to manipulate character data, numeric data, and SAS date values.
	-year cuttoff options.
	-Creating & Redefining Variables • Where Statement • If – Then Else Statement.
	-Goto, Stop And Error Statements • Output Statement, Put Statement.
	-Questions.
Managing Data	-Concept of SAS Array.
	-Array statement.
	-Two and Multidimension Array.
	-Concept of First.variable and last.variable.
	-Do until and while statement.
	-Questions.
Generating Reports	-Generate list reports using the PRINT and REPORT procedures.
	-Procedures like Means , Freq, append, update ..etc.
	-Generate summary reports and frequency tables using base SAS procedures.
	-Generate HTML reports using ODS statements.
	-Enhance reports through the use of labels, SAS formats, user-defined formats, titles, footnotes and SAS System reporting options.
	-Questions.

Advanced SAS

PROC SQL	-Generate summary reports by working with a single table or joining tables using PROC SQL and the appropriate options
	-Construct sub queries within a PROC SQL step.
	-Compare solving a problem using the SQL procedure versus using traditional SAS programming techniques.
	-Access Dictionary Tables using the SQL procedure.
	-Demonstrate advanced PROC SQL skills by creating and updating tables, updating data values, working with indexes using the macro interface/creating macro variables with SQL, defining integrity constraints, SQL views and SET operators.
Macro Processing	-Creating and using user defined and automatic macro variables within the SAS macro Language
	-Automate programmes by defining and calling macros using the SAS macro Language.
	-Understand the use of macro functions.
	-Recognize various system options that are avai.
Advanced Programming Techniques	-Demonstrate advanced data set processing techniques such as updating master data sets, transposing data, combining/merging data, sampling data, using generation data sets, integrity constraints and audit trails -Reduce the space required to store SAS data sets and numeric variables within SAS data sets by using compression techniques, length statements or DATA step views
	-Develop efficient programmes by using advanced programming techniques such as permanent formats and array processing.
	-Use SAS System options and SAS data set options for controlling memory usage.
	-Control the processing of variables and observations in the DATA step.
	-Create sorted or indexed data in order to avoid unnecessary sorts, eliminate duplicate data and to provide more efficient data access and retrieval
	-Proc Graph.
	-Use PROC DATASETS to demonstrate advanced programming skills (e.g. renaming columns, displaying metadata, creating indexes, creating integrity constraints, creating audit trails)
Creating Data Structures	-Types of SAS library
	-Creating Library .
	-Assigning Library.
	-Create null, temporary and permanent SAS data sets.
	-Phases of Programme Processing-Data step processing.
	-Input buffer and PDV.
	-Title, Footnotes ,Commenting code, and Label.
	-Informats and Formats.
	-Proc Format.
	-Options
	-Control which observations and variables in a SAS data set are processed and output
	-Questions.
Accessing Data	-What is Raw Data.
	-Reading various Raw files .
	-Types of Inputs .Use of FORMATTED, LIST and COLUMN input to read raw data files.
	-Delimiters.
	-Reading delimited file.
	-Use INFILE statement options to control processing when reading raw data files.
	-Use various components of an INPUT statement to process raw data files including column and line pointer controls, and trailing @ controls.
	-Creating single records from multiple input row.
	– Null statement.
	-Import and export
	-Saving log automatically
	Use DATA Step statements to export data to standard and comma delimited raw data files
	-Questions.
Managing Data	-Sort observations in a SAS data set.
	-Removing Duplicates .
	-Types of Combining Datasets.
	-Transfering records or copy records from one dataset to another.
	-Transpose.
	-Questions.
Managing Data	-Conditionally execute SAS statements.
	-Create and manipulate SAS date values.
	-Use assignment statements in the DATA step.
	-Modify variable attributes using options and statements in the DATA step.
	-Accumulate sub-totals and totals using DATA step statements using by statement.
	-Use SAS functions to convert character data to numeric and vice versa.
	-Introduction to length and Retain Statements
	-Knowing contents of datasets.
	-Creating and modifiying the variables.
	-Creating Multiple Datasets in single step.
	-Questions.
Handling Errors	-Identify and resolve programming logic errors
	-Recognize and correct syntax errors.
	-Examine and resolve data errors.
Managing Data	-SAS Functions.
	-Use SAS functions to manipulate character data, numeric data, and SAS date values.
	-year cuttoff options.
	-Creating & Redefining Variables • Where Statement • If – Then Else Statement.
	-Goto, Stop And Error Statements • Output Statement, Put Statement.
	-Questions.
Managing Data	-Concept of SAS Array.
	-Array statement.
	-Two and Multidimension Array.
	-Concept of First.variable and last.variable.
	-Do until and while statement.
	-Questions.
Generating Reports	-Generate list reports using the PRINT and REPORT procedures.
	-Procedures like Means , Freq, append, update ..etc.
	-Generate summary reports and frequency tables using base SAS procedures.
	-Generate HTML reports using ODS statements.
	-Enhance reports through the use of labels, SAS formats, user-defined formats, titles, footnotes and SAS System reporting options.
	-Questions.

Total 40 Hrs Includes 2.5 months if taken(Sat/Sun Batch) 4 months if Taken (Sun Batch Only)	-Technical Knowledge Transfer
	-Doubt Session
	-Assignments Discussion and Reviews
	-Test Assessment ( Preferring Candidates scoring 65% Min. Marks)
	-HR Session
	-Resume Building
	-LinkedIn Account Updation