BASE AND ADVANCE SAS – (BAS2202)

TAKE THIS COURSE

Lectures40
Video3 Hour
Skill LevelADVANCE SAS
LanguagesEnglish

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 Program16m
Blocks in SAS Program16m
SAS Data Sets and SAS Data Types16m
Rules for SAS Names16m
Colours in SAS16m

2.Getting started with SAS

Types of Raw Data16m
Syntax for DATA Block16m
List Input Method16m
Name Input Method16m
Column Input Method16m
Formatted Input Method16m
Absolute Input Method16m
Mixed Input Method16m
Data Step Process16m
Reading Part of Raw Data16m
Reading Multiple Observations per Record16m
Reading Single Observation from Multiple Records16m
Controlling Default assumptions through Infile (OBS, Missover, Truncover)16m
Controlling Default assumptions through Infile (DLM, DSD)16m
Import Procedure16m
DDE (Dynamic Data Exchnage)16m

3.Working with DATA

Assigning Libraries16m
Knowing Metadata16m
Creating and Redefining Variables16m
Characteristic Functions16m
Numeric Functions16m
Date Time Functions16m
Conditional Statements (IF, ELSE IF, IN, DO)16m
Working with Dates16m
Sorting Data and BY Group Processing16m
KEEP, DROP, RENAME as Statements & Options16m
LABEL statement16m
RETAIN, SUM Statements16m
ARRAY Statement with DO loops16m
Shortcuts for list of Variable names16m

4.Modifying and Combining DATA

SET statement for stacking datasets16m
MERGE statement for concatenating datasets16m
UPDATE statement for updating master dataset16m
OUTPUT statement to restrict observations16m
DATASET options (IN, NOBS, END)16m
IF & WHERE statements16m
TRANSPOSE Procedure16m

5.Summarizing DATA with Procedures

DATASETS16m
FORMATS16m
PRINT16m
FREQ16m
UNIVARIATE16m
MEANS & SUMMARY16m
TABULATE16m
REPORT16m

6.Work with SAS/ACCESS

To import data from different PC files use import procedure16m
To export data from datasets to different PC files use export Procedures16m
Uses of DB Load procedure and how to work16m
Transport datasets by CPORT and CIMPORT procedures16m
How to use Upload Procedure16m
How to use Download Procedure16m

7.Output Delivery System

Selecting Portions of SAS Output16m
Sending Output to a SAS Data Set16m
Sending SAS Output to an HTML File16m
Sending SAS Output to PDF File16m
Sending SAS Output to RTF File16m
Choosing Other ODS Destinations16m

8.Generating High-Quality Graphics

Producing Simple Bar Charts Using PROC GCHART16m
Creating Pie Charts16m
Creating Bar Charts for a Continuous Variable16m
Creating Charts with Values Representing Categories16m
Creating Bar Charts Representing Means16m
Adding another Variable to the Chart16m
Producing Scatter Plots16m
Connecting Points16m

9.SAS Macro Language

How the SAS macros Language Works16m
Applying automatic macro variables16m
Assigning Values to Macro Variables by various methods16m
Resolving Macro variables during DATA STEP EXECUTION16m
Designing and implementing simple macros and reduce customizing SAS application16m
Designing and using macros containing parameters within them16m
Techniques for Storing MACROS16m

10.Structured Query Language

Basics of PROC SQL16m
Cartesian Product and Joining concept16m
Joining Two Tables (Merge)16m
Left, Right, and Full Joins16m
Concatenating Data Sets16m
Set Operator us such as union and intersection joining multiple tables16m
Using functions to summarize and group data16m
Ordering data and formatting out16m
Performing group analysis, remerging and sub queries16m
Creating new tables, indexes , views and reports16m
Using Macros in PROC SQL16m
Using Pass Through Facility to communicate databases16m

11.Implementation of SAS on Project

Domain Concepts and Objectives16m
Programming and Report Documentation16m