SAS Base Certification Training - Melbourne, Australia

1. Fundamentals of SAS and its environment
2. Creating reports and graphs
3. Interactive data processing
4. Deploying SAS procedures
5. SAS variables, functions and operators
6. Compiling and executing SAS datasets
7. Advanced SAS and Base SAS

• Business Intelligence Professionals
• Software Developers and Architects
• Project Managers
• ETL, SQL, Data Warehousing and Analytics Professionals
• Mainframe and Testing Professionals
• Graduates wishing to enter Big Data Analytics domain

Anybody can learn SAS and get trained. However, having a basic knowledge of SQL can help.

The average salary of a SAS Developer goes up to AU$151,325 per annum in Melbourne.

Melbourne is an emerging city with a lot of top MNCs residing in this location. The IT sector is booming like anything, and companies have gradually started acquiring advanced technologies for better operations. SAS is one such technology which has helped companies predict the market’s future conditions. Hence it is used by IT and non-IT firms as well. This has created a huge pool of job opportunities for SAS professionals in this city.

Big Data Analytics has already taken the world by storm and is applied in almost every industry for various purposes. With the developing technology market, Big Data has led to the emergence of smart tools like SAS which helps the firms extract meaningful insights from bulks of data. This has made SAS professionals some of the most-coveted individuals in Melbourne.

• 70% of companies say that analytics is integral to how they make decisions – IBM Study
• Most companies estimate that they’re analyzing a mere 12% of the data they have – Forrester Research
• A Principal SAS Programmer in the United States can earn up to $102,000 – indeed.com

SAS software stack is one of the most widely known analytical tools that is capable of performing analytics and forecast the future scenarios with least number of errors. Due to this reason, SAS has gained immense popularity in the domain of analytics. The SAS certification training course is perfectly aligned with the skills required to qualify for the SAS Certified Base Programmer exam. As part of this training, learners will be getting rich experience through lab sessions and real-time projects.

Installation and introduction to SAS, how to get started with SAS, understanding different SAS windows, how to work with data sets, various SAS windows like output, search, editor, log and explorer and understanding the SAS functions, which are various library types and programming files

How to import and export raw data files, how to read and subset the data sets, different statements like SET, MERGE and WHERE

Hands-on Exercise: How to import the Excel file in the workspace and how to read data and export the workspace to save data

Different SAS operators like logical, comparison and arithmetic, deploying different SAS functions like Character, Numeric, Is Null, Contains, Like and Input/Output, along with the conditional statements like If/Else, Do While, Do Until and so on

Hands-on Exercise: Performing operations using the SAS functions and logical and arithmetic operations

Understanding about input buffer, PDV (backend) and learning what is Missover

Defining and using KEEP and DROP statements, apply these statements and formats and labels in SAS

Hands-on Exercise: Use KEEP and DROP statements

Understanding the delimiter, dataline rules, DLM, delimiter DSD, raw data files and execution and list input for standard data

Hands-on Exercise: Use delimiter rules on raw data files

Various SAS standard procedures built-in for popular programs: PROC SORT, PROC FREQ, PROC SUMMARY, PROC RANK, PROC EXPORT, PROC DATASET, PROC TRANSPOSE, PROC CORR, etc.

Hands-on Exercise: Use SORT, FREQ, SUMMARY, EXPORT and other procedures

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, dataline statement and rules, list input method and 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 and write multiple IN and OUT statements

SAS Format statements: standard and user-written, associating a format with a variable, working with SAS Format, deploying it on PROC data sets and comparing ATTRIB and Format statements

Hands-on Exercise: Format a variable, deploy format rule on PROC data set and use ATTRIB statement

Understanding PROC GCHART, various graphs, bar charts: pie, bar and 3D and plotting variables with PROC GPLOT

Hands-on Exercise: Plot graphs using PROC GPLOT and display charts using PROC GCHART

SAS advanced data discovery and visualization, point-and-click analytics capabilities and powerful reporting tools

Character functions, numeric functions and converting variable type

Hands-on Exercise: Use functions in data transformation

Introduction to ODS, data optimization and how to generate files (rtf, pdf, html and doc) using SAS

Hands-on Exercise: Optimize data and generate rtf, pdf, html and doc files

Macro Syntax, macro variables, positional parameters in a macro and macro step

Hands-on Exercise: Write a macro and use positional parameters

SQL statements in SAS, SELECT, CASE, JOIN and UNION and sorting data

Hands-on Exercise: Create SQL query to select and add a condition and use a CASE in select query

Base SAS web-based interface and ready-to-use programs, advanced data manipulation, storage and retrieval and descriptive statistics

Hands-on Exercise: Use web UI to do statistical operations

Report enhancement, global statements, user-defined formats, PROC SORT, ODS destinations, ODS listing, PROC FREQ, PROC Means, PROC UNIVARIATE, PROC REPORT and PROC PRINT

Hands-on Exercise: Use PROC SORT to sort the results, list ODS, find mean using PROC Means and print using PROC PRINT

Project 1: Categorization of Patients Based on the Count of Drugs for Their Therapy

Domain: Healthcare

Objective: This project aims to find out descriptive statistics and subset for specific clinical data problems. It will give them brief insight about Base SAS procedures and data steps.

Problem Statement:

Count the number of patients,

1. Who were ever on at least one of the four drugs
2. Who were ever on each of the four drugs
3. Who had never been on any drug

Output should be four datasets

1. TYPA – Contains the list of patients from problem 1
2. TYPB – Contains the list of patients from problem 2
3. TYPC – Contains the list of patients from problem 3
4. SUMMARY – Contains the summary of counts for each of three problems

Project 2: Build Revenue Projections Reports

Domain: Sales

Objective: This project will give you hands-on experience in working with the SAS data analytics and business intelligence tool. You will be working on the data entered in a business enterprise setup and will aggregate, retrieve and manage that data. You will learn to create insightful reports and graphs and come up with statistical and mathematical analysis to scientifically predict the revenue projection for a particular future time frame. Upon the completion of the project, you will be well-versed in the practical aspects of data analytics, predictive modeling and data mining.

Project 3: Impact of Pre-paid Plans on the Preferences of Investors

Domain: Finance Market

Objective: The project aims to find the most impacting factors in preferences of pre-paid model; it also identifies which all are the variables highly correlated with impacting factors.

Problem Statement:

• The project aims to identify various reasons for pre-paid model preference and non-preference among the investors, to understand the penetration of the pre-paid model in the brokerage firms and, to identify the pre-paid scheme advantages and disadvantages and also to identify brand-wise market share. In addition to this, the project also looks to identify various insights that would help a newly established brand to foray deeper into the market on a large scale.

Project 4:K-Means Cluster Analysis on Iris Dataset

Domain: Analytics

Objective: K-Means cluster analysis on Iris dataset to predict about the class of a flower using its petal’s dimensions

Requirements:

• Using the famous Iris dataset, predict the class of a flower
• Perform K-Means cluster analysis