Brochure
Enquire
- Course Overview
- Downloadable course materials
SAS Programming BASE certification course for SAS Beginners
Quick Facts
| particular | details | |||
|---|---|---|---|---|
|
Medium of instructions
English
|
Mode of learning
Self study
|
Mode of Delivery
Video and Text Based
|
Course and certificate fees
Fees information
₹ 3,499
certificate availability
Yes
certificate providing authority
Udemy
The syllabus
Course Overview and 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
Articles
Popular Articles
prev
next
Latest Articles
Similar Courses
Courses of your Interest
Professional Certificate Course in Data Science
Newton School
JavaScript Foundations
PW Skills
Technical Analysis Series
PW Skills
C Programming Foundations
PW Skills
Python Foundations
PW Skills
Getting Started with Generative AI APIs
Codio via Coursera
Generating code with ChatGPT API
Codio via Coursera
Prompt Engineering for ChatGPT
Vanderbilt via Coursera
prev
next
More Courses by Udemy
prev
next
