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 |
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 |
11.Implementation of SAS on Project | |
Domain Concepts and Objectives | 16m |
Programming and Report Documentation | 16m |
ADMISSION OPEN
Admission Open
Top Courses
