SAS is an integrated system of software solutions that enables you to perform the following tasks:
- Data entry, Retrieval, and management
- Report writing and graphics design
- Statistical and mathematical analysis
- Business forecasting and decision support
- Operations research and project management
- Applications development.
Anybody who is working in the data must know SAS to grow in their career and first step towards this is always a certification and fundamental knowledge of language. Hence we brings you a Hands On SAS( Base and Advance) Training which will help you not only for your SAS certification, but even make you master in SAS Programming. Once you do or complete all the hands on session by your own given in our training you will become very comfortable in SAS programming.
- Business Intelligence professionals
- Software developers and architects
- Project managers
- ETL, SQL, data warehouse and analytics professionals
- Mainframe and testing professionals
- Graduates wanting to enter Big Data analytics
Any Graduate from any stream can learn SAS and get trained , Having a basic knowledge of SQL can help.
As part of this Base SAS Certification training you will be working on projects and assignments that have immense implications in the real world industry scenario thus helping you fast track your career effortlessly.
Introduction to SAS
Introduction to Base SAS, Installation of SAS tool, Getting started with SAS, various SAS Windows – Log, Explorer, Output, Search, Editor, etc. working with data sets, overview of SAS Functions, Library Types and programming files
Hands-on Exercise – Import Excel,CSV,TEXT files in workspace, Read data, Export the workspace to save data
SAS Operators & Functions
Various SAS Operators – Arithmetic, Logical, Comparison, various SAS Functions – NUMERIC, CHARACTER, IS NULL, CONTAINS, LIKE, Input/Put, Date/Time, Conditional Statements (Do While, Do Until, If, Else)
Hands-on Exercise- Apply logical, arithmetic operators and SAS functions to perform operations
Compilation & Execution
Understanding about Input Buffer, PDV (Backend), learning what is Missover
Defining and Using KEEP and DROP statements, apply these statements, Format and Labels in SAS.
Hands-on Exercise- Use KEEP and DROP statements
Creation and Compilation of SAS Data sets
Understanding Delimiter, dataline rules, DLM, Delimiter DSD, raw data files and execution, list input for standard data.
Hands-on Exercise-Use delimiter rules on raw data files
The various SAS standard Procedures built-in for popular programs – PROC SORT, PROC FREQ, PROC SUMMARY, PROC IMPORT, PROC EXPORT, PROC DATASETS, PROC TRANSPOSE, PROC MEANS, PROC FORMAT, PROC COMPARE etc.
Hands-on Exercise- Use SORT, FREQ, SUMMARY, MEANS and other procedures
Input statement and formatted input
Reading standard and non-standard numeric inputs with Formatted inputs, Column Pointer Controls, Controlling while a record loads, Line pointer control / Absolute line pointer control, Single Trailing , Multiple IN and OUT statements, DATA LINES statement and rules, List Input Method, comparing Single Trailing and Double Trailing
Hands-on Exercise- Read standard and non-standard numeric inputs with Formatted inputs, Control while a record loads, Control a Line pointer, Write Multiple IN and OUT statements
Understanding PROC GCHART, various Graphs, Bar Charts – Pie, Bar, 3D, plotting variables with PROC GPLOT
Hands-on Exercise- Plot graphs using PROC GPLOT Display charts using PROC GCHART
Interactive Data Processing
SAS advanced data discovery and visualization, point-and-click analytics capabilities, powerful reporting tools.
Data Transformation Function
Character Functions, Numeric Functions, Converting Variable Type
Hands-on Exercise- Use Functions in data transformation
Output Delivery System (ODS)
Introduction to ODS, Data Optimization, How to generate files (rtf, pdf, html, doc) using SAS
Hands-on Exercise-Optimize data, generate rtf, pdf, html and doc files
Syntax, Macro Variables, Positional Parameters, Keyword Parameters, Macro String Functions, in a Macro, Macro Step, Macro interface Functions, Stored Macros.
Hands-on Exercise-Write a macro, Use positional parameters and Keyword Parameter.
SQL Statements in SAS, SELECT, CASE, JOIN, UNION, Sorting Data
Hands-on Exercise-Create sql query to select and add a condition Use a CASE in select query
Report Enhancement, Global Statements, User-defined Formats, PROC SORT, ODS Destinations, ODS Listing, PROC FREQ, PROC Means, PROC UNIVARIATE, PROC REPORT, PROC PRINT
Hands-on Exercise-Use PROC SORT to sort the results, List ODS, Find mean using PROC Means, print using PROC PRINT