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 |
|
|