BASE AND ADVANCE SAS – (BAS2202)

BASE AND ADVANCE SAS – (BAS2202)

BASE AND ADVANCE SAS – (BAS2202)

BASE AND ADVANCE SAS

Introduction:BASE AND ADVANCE SAS!

29 ratings, 5,047 students enrolled

Instructed by Abrar Hussain Development / Programming Languages

Take this Course

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

11.Implementation of SAS on Project

Domain Concepts and Objectives 16m
Programming and Report Documentation 16m

No Comments

Post a Reply