BASE AND ADVANCE SAS – (BAS2202)

TAKE THIS COURSE

Lectures	40
Video	3 Hour
Skill Level	ADVANCE SAS
Languages	English

WHAT ARE THE PRE-REQUISITES?

There are no pre-requisites. Anybody can enrol for this course.A young go-getter or an old has-been? A small business owner or a multi-million dollar corporate hi-flier? The point is that none of it matters – because whoever you are and whatever you do, analytics can help you do it better! – See more at: https://umeacademy.com/courses/base-and-advance-sas/

COURSE DESCRIPTION

1.Introduction to SAS
What is SAS?	16m
Why SAS?	16m
A Sample SAS Program	16m
Blocks in SAS Program	16m
SAS Data Sets and SAS Data Types	16m
Rules for SAS Names	16m
Colours in SAS	16m

2.Getting started with SAS
Types of Raw Data	16m
Syntax for DATA Block	16m
List Input Method	16m
Name Input Method	16m
Column Input Method	16m
Formatted Input Method	16m
Absolute Input Method	16m
Mixed Input Method	16m
Data Step Process	16m
Reading Part of Raw Data	16m
Reading Multiple Observations per Record	16m
Reading Single Observation from Multiple Records	16m
Controlling Default assumptions through Infile (OBS, Missover, Truncover)	16m
Controlling Default assumptions through Infile (DLM, DSD)	16m
Import Procedure	16m
DDE (Dynamic Data Exchnage)	16m

3.Working with DATA
Assigning Libraries	16m
Knowing Metadata	16m
Creating and Redefining Variables	16m
Characteristic Functions	16m
Numeric Functions	16m
Date Time Functions	16m
Conditional Statements (IF, ELSE IF, IN, DO)	16m
Working with Dates	16m
Sorting Data and BY Group Processing	16m
KEEP, DROP, RENAME as Statements & Options	16m
LABEL statement	16m
RETAIN, SUM Statements	16m
ARRAY Statement with DO loops	16m
Shortcuts for list of Variable names	16m

4.Modifying and Combining DATA
SET statement for stacking datasets	16m
MERGE statement for concatenating datasets	16m
UPDATE statement for updating master dataset	16m
OUTPUT statement to restrict observations	16m
DATASET options (IN, NOBS, END)	16m
IF & WHERE statements	16m
TRANSPOSE Procedure	16m

5.Summarizing DATA with Procedures
DATASETS	16m
FORMATS	16m
PRINT	16m
FREQ	16m
UNIVARIATE	16m
MEANS & SUMMARY	16m
TABULATE	16m
REPORT	16m

6.Work with SAS/ACCESS
To import data from different PC files use import procedure	16m
To export data from datasets to different PC files use export Procedures	16m
Uses of DB Load procedure and how to work	16m
Transport datasets by CPORT and CIMPORT procedures	16m
How to use Upload Procedure	16m
How to use Download Procedure	16m

7.Output Delivery System
Selecting Portions of SAS Output	16m
Sending Output to a SAS Data Set	16m
Sending SAS Output to an HTML File	16m
Sending SAS Output to PDF File	16m
Sending SAS Output to RTF File	16m
Choosing Other ODS Destinations	16m
8.Generating High-Quality Graphics
Producing Simple Bar Charts Using PROC GCHART	16m
Creating Pie Charts	16m
Creating Bar Charts for a Continuous Variable	16m
Creating Charts with Values Representing Categories	16m
Creating Bar Charts Representing Means	16m
Adding another Variable to the Chart	16m
Producing Scatter Plots	16m
Connecting Points	16m

9.SAS Macro Language
How the SAS macros Language Works	16m
Applying automatic macro variables	16m
Assigning Values to Macro Variables by various methods	16m
Resolving Macro variables during DATA STEP EXECUTION	16m
Designing and implementing simple macros and reduce customizing SAS application	16m
Designing and using macros containing parameters within them	16m
Techniques for Storing MACROS	16m

10.Structured Query Language
Basics of PROC SQL	16m
Cartesian Product and Joining concept	16m
Joining Two Tables (Merge)	16m
Left, Right, and Full Joins	16m
Concatenating Data Sets	16m
Set Operator us such as union and intersection joining multiple tables	16m
Using functions to summarize and group data	16m
Ordering data and formatting out	16m
Performing group analysis, remerging and sub queries	16m
Creating new tables, indexes , views and reports	16m
Using Macros in PROC SQL	16m
Using Pass Through Facility to communicate databases	16m