SAS Programming BASE certification course for SAS Beginners

Udemy

Beginner

Online

₹ 3499

particular

details

                                    Medium of instructions
                                    English

                                    Mode of learning
                                    Self study

                                    Mode of Delivery
                                    Video and Text Based

Course Overview and downloadable course materials

Course Overview
Downloadable course materials

Free web-based SAS software option for learning: SAS OnDemand for Academics

A Quick Note on Free SAS software for learning SAS programming (SAS studio)
Create a SAS account to access SAS OnDemand for Academics
Upload course data files and SAS programs into SAS OnDemand for academics
change file path/directory in SAS OnDemand for academics
examples: update and run SAS programs in SAS OnDemand for academics

An Introduction to SAS

SAS Introduction
Quiz: SAS introduction

Get Data into SAS: create temporary & permanent SAS data

Read data delimited by blanks (.txt data file) using list input
Read data delimited by commas (.csv data file) using list input
Read data delimited by any delimiters using list input
Read data in fixed columns using column input
Read data using formatted input including using SAS informat to read dates
Read data using formatted input: use SAS format to display SAS date values
Create internal SAS data using DATALINES statement
LIBNAME statement: assign library names and create permanent SAS data sets
Proc Import: Import Excel data file into SAS
Quiz
Coding Exercise 1
Coding Exercise 1: Solution
Coding Exercise 2
Coding Exercise 2: Solution

Work with data

Use ASSIGNMENT statements in DATA step & use SET statement to create a SAS data
SAS functions: overview
Conditionally execute SAS statements: IF-THEN/ELSE, DO and END statements
Conditionally execute SAS statements: IF-THEN/ELSE, DO and END statement (Cont.)
Define the length of a variable using the LENGTH statement
Subset your Data using subsetting IF statement and DELETE statement
Quiz
Coding Exercise
Coding Exercise: Solution

Creating labels and formats

Use LABEL statement to add Labels to vars in DATA step & Proc Print Split option
Use FORMAT statement to assign Formats to Variables: SAS Built-in Formats
Create your User-Defined FORMATS
Storing and Referencing/using your User-Defined FORMATS
Proc format with CNTLIN= option to define custom formats
Quiz
Coding Exercise 1
Coding Exercise 1: Solution
Coding Exercise 2
Coding Exercise 2: Solution

Use SAS Functions to manipulate character and numeric data values

Convert Character & Numeric Value: Auto convert, explicitly PUT & INPUT function
SCAN function: Separate a character value and obtain a specific word/string
SUBSTR function: Extract and replace a portion of a character value
TRIM and CATX functions: Concatenate character values
INDEX function: Search a character value for a specified string
UPCASE, LOWCASE and PROPCASE functions: Change the case of characters
TRANWRD function: Replace/remove characters within a character string
INT and ROUND functions: Modifying Numeric Values
Quiz
Coding Exercise
Coding Exercise: Solution

Use SAS Functions to manipulate SAS date values

Explanation on how SAS stores date and time values; Usage of MDY function
YEAR, QTR, MONTH, DAY, WEEKDAY Functions: Extract year/quarter/month/day values
TODAY, DATE, INTCK functions: get current date value & number of time interval
DATDIF, YRDIF function: Calculate difference in days and years between two dates
Quiz
Coding Exercise
Coding Exercise: Solution

Process data using DO LOOPS

Constructing DO loops: part 1
Constructing DO loops: part 2
Conditionally Executing DO Loops using DO UNTIL and DO WHILE
Using Conditional Clauses with the Iterative DO Statement
Quiz
Coding Exercise
Coding Exercise: Solution

Using ARRAYS to simply coding

Creating One-Dimensional Arrays
Creating Variables in an ARRAY Statement
Assigning Initial Values to Arrays & Creating Temporary Array Elements
Two dimensional array
Quiz
Coding Exercise 1
Coding Exercise 1: Solution
Coding Exercise 2
Coding Exercise 2: Solution

Combine SAS data sets

One-to-One Merging
Concatenating
Appending
Interleaving
Match merging
Types of match-merging: merge data sets one-to-one and one-to-many
Match Merging: Renaming Variables
Match Merging: Excluding Unmatched Observations
Match Merging: Selecting Variables
Quiz
Coding Exercise
Coding Exercise: Solution

Reconstruct/Reshape SAS Data sets in DATA step and using Proc TRANSPOSE

Convert One Obs / Subject to Several Obs / Subject Using a Data step
Convert Several Obs / Subject to One Obs / Subject Using a DATA Step
Convert One Obs / Subject to Several Obs / Subject Using PROC TRANSPOSE
Convert Several Obs / Subject to One Obs / Subject Using PROC TRANSPOSE
Quiz
Coding Exercise
Coding Exercise: Solution

SAS Stat Procedures: Proc SORT, PRINT, MEANS, FREQ, UNIVARIATE, Contents, Export

Sorting SAS Data with PROC SORT
Generate list reports with Proc PRINT: VAR, SUM, WHERE, ID and BY statements
Generate reports with Proc PRINT: VAR, SUM, WHERE, ID and BY statements (Cont.)
Calculate summary statistics and multilevel summaries using Proc MEANS procedure
Produce one-way and two-way frequency tables with the Proc FREQ procedure
Proc Univariate: More powerful way to Describing and Summarizing data
Proc Content: investigate/view the Contents of a SAS Libraries or a SAS data set
Proc Export: Export data to create standard, comma-delimited, Excel data files
Quiz
Coding Exercise
Coding Exercise: Solution

Generate reports using ODS statements

ODS overview with examples creating PDF, RTF, PowerPoint outputs
ODS: Creating HTML Output with Options
ODS: Creating Excel Output with multiple work sheets
Quiz
Coding Exercise
Coding Exercise: Solution

Error Handling: identify and resolve SAS errors

Syntax errors: misspelled keywords, unmatched ' ', missing ; , invalid option
Logic Error: PUTLOG statement, ERROR statement, temporary variables N and ERROR
Quiz
Coding Exercise
Coding Exercise: Solution

SAS Macro: Essentials

SAS Macro Overview
Replacing Text Strings Using Macro Variables
Generating SAS Code Using Macros
Passing Information into a Macro Using Parameters
Quiz
Coding Exercise
Coding Exercise: solution

Proc SQL: Essentials

Retrieve Data from a Single Table using the Select Statement
Retrieve Data from Multiple Tables using Inner Join
Retrieve Data from Multiple Tables using Outer Joins
Quiz
Coding Exercise
Coding Exercise: Solution

Hands-on Project: Case study on Weight Loss data

Project step-by-step instruction & Excel data file
Project Solution: Video
Project SAS Code: Downloadable

Popular Courses

Popular Platforms

Popular Searches

SAS Programming BASE certification course for SAS Beginners

Beginner

Online

₹ 3499

Quick Facts

Course and certificate fees

Fees information

certificate availability

certificate providing authority

The syllabus

Course Overview and downloadable course materials

Free web-based SAS software option for learning: SAS OnDemand for Academics

An Introduction to SAS

Get Data into SAS: create temporary & permanent SAS data

Work with data

Creating labels and formats

Use SAS Functions to manipulate character and numeric data values

Use SAS Functions to manipulate SAS date values

Process data using DO LOOPS

Using ARRAYS to simply coding

Combine SAS data sets

Reconstruct/Reshape SAS Data sets in DATA step and using Proc TRANSPOSE

SAS Stat Procedures: Proc SORT, PRINT, MEANS, FREQ, UNIVARIATE, Contents, Export

Generate reports using ODS statements

Error Handling: identify and resolve SAS errors

SAS Macro: Essentials

Proc SQL: Essentials

Hands-on Project: Case study on Weight Loss data

Articles

Popular Articles

Latest Articles

Similar Courses

Courses of your Interest

More Courses by Udemy

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Thank You!

Download the Careers360 App on your Android phone