SAS Programming BASE certification course for SAS Beginners
4.4 (2,401 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
10,815 students enrolled

SAS Programming BASE certification course for SAS Beginners

suitable for the new practical SAS programming certificate: SAS Certified Specialist: Base Programming Using SAS 9.4
Bestseller
4.4 (2,401 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
10,815 students enrolled
Created by sharon cheng
Last updated 4/2020
English
English [Auto], French [Auto], 1 more
  • Italian [Auto]
Current price: $69.99 Original price: $99.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 13.5 hours on-demand video
  • 35 articles
  • 9 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • This course is suitable for the new practical BASE programming credential: SAS Certified Specialist: Base Programming Using SAS 9.4
  • Software installation (SAS University Edition /SAS studio): the complete & step-by-step guide; detailed explanation on File path/directory in SAS studio
  • Get Data in various format into SAS: (read .txt file, .csv file, Excel file, format input (using SAS informat to read dates; use SAS format to display SAS date values). Proc Import, Proc Export, Proc Content)
  • Create temporary and permanent SAS data sets (SET statement, LIBNAME statement, SAS libraries )
  • Combine data sets (Concatenate, Append, interleave, Match Merge (one -to-one merge, one-to-many merge))
  • Use SAS Functions to manipulate SAS date values (Explanation on how SAS stores date and time values, SAS functions include MDY, YEAR, QTR, MONTH, DAY, WEEKDAY, TODAY, DATE, INTCK, DATDIF, YRDIF)
  • Use SAS Functions to manipulate character and numeric data values (use SAS functions to Convert Character & Numeric Value (auto-convert; PUT & INPUT functions), Other SAS functions include: SCAN, SUBSTR, TRIM, UPCASE, LOWCASE, PROPCASE, CATX, INDEX, TRANWRD, INT, ROUND)
  • Conditionally execute SAS statements: IF-THEN/ELSE, DO and END statements
  • Simplify your data with Array (One dimensional array; two dimensional array; Creating Variables in an ARRAY Statement; Assigning Initial Values to Arrays & Creating Temporary Array Elements)
  • Process data with DO LOOPS (the basic of DO LOOPS; constructing DO LOOPS; Conditionally Executing DO Loops using DO UNTIL and DO WHILE; Using Conditional Clauses with the Iterative DO Statement)
  • Work with data & Creating labels and formats (Use assignment statements in the DATA step; Use LABEL and FORMAT statements to modify attributes in a DATA step; Define the length of a variable using the LENGTH statement; Control which observations and variables using DROP, KEEP statements and DROP=, KEEP= options, and IF statement)
  • SAS Statistical Procedures: Proc SORT; Proc PRINT; Proc MEANS; Proc FREQ; Proc UNIVARIATE
  • Generate list reports using the PRINT procedure (using VAR, SUM, WHERE, ID and BY statements)
  • Generate reports using ODS statements (Identify ODS destinations, create HTML, PDF, RTF, and Excel files with ODS statements)
  • Reconstruct/Reshape SAS Data sets in DATA step and using Proc TRANSPOSE
  • SAS advanced topic: Proc SQL Essentials
  • SAS advanced topic: SAS Macros Essentials
Requirements
  • Basic computer skills
Description

Do you want to start learning SAS programming easily and quickly? This course is the most complete SAS BASE certification programming course for

  • absolute SAS beginners

  • anyone interested in passing the SAS BASE certification exam

  • suitable for the new practical SAS programming certificate: SAS Certified Specialist: Base Programming Using SAS 9.4

  • Coding exercises and projects are perfect for for the practical coding questions for the new SAS BASE certificate exam

You may compare the contents covered in this course with the official SAS BASE certification Exam contents (the new practical exam is SAS Certified Specialist: Base Programming Using SAS 9.4) and SAS BASE certification prep guide (due to Udemy policy, I am not allowed to include the SAS link here).

Course Highlights:

  • step by step/ code by code explanations for easy and efficient learning experiences

  • most complete SAS BASE course for beginners and the SAS BASE certification exam(suitable for the new practical SAS programming certificate: SAS Certified Specialist: Base Programming Using SAS 9.4)

    This course is a combined course to offer the maxim benefit for my students, it includes contents from the following individual courses

    1. SAS programming for beginners

    2. SAS programming on data manipulation and preparation part 1: modify variables

    3. SAS programming on data manipulation and preparation part 2: combine/merge data sets

    4. Overview / Essentials for SAS advanced topics: SAS SQL (Proc SQL) and SAS Macro Language

    5. Additional topics: Error handling, Generate reports using ODS statements

  • downloadable data and SAS programs used in the course (the course materials are ONLY for practice,  they are protected by copyright)

  • Quizzes, coding exercises and projects for practice. After all, practice makes perfection!

    Coding exercises and projects are perfect for for the practical coding questions for the new certificate exam on SAS Certified Specialist: Base Programming Using SAS 9.4

  • A Note on Course ratings and reviews:

    Please be considerate and sincere when you provide ratings and reviews. This will encourage me providing more contents to the course and better service to you!

    Many students who take this course as a main course have passed the SAS BASE certification. This course is a truly cost-value effective one for both individual users and Udemy for business users.

    So Please provide fair ratings to this course with the consideration of the comparison among other available SAS courses. Thank you!

Current course contents: (Please see course curriculum for more detailed information on sections and lectures included in this course)

  • Software installation (SAS University Edition /SAS studio): the complete & step-by-step guide; detailed explanation on File path/directory in SAS studio

  • Navigate/work in SAS environment

  • Get Data in various format into SAS: (read .txt file, .csv file, Excel file, format input (using SAS informat to read dates; use SAS format to display SAS date values). Proc Import)

  • Create temporary and permanent SAS data sets (SET statement, LIBNAME statement, SAS libraries )

  • Combine data sets (Concatenate, Append, interleave, Match Merge (one -to-one merge, one-to-many merge))

  • Use SAS Functions to manipulate SAS date values (Explanation on how SAS stores date and time values, SAS functions include MDY, YEAR, QTR, MONTH, DAY, WEEKDAY, TODAY, DATE, INTCK, DATDIF, YRDIF)

  • Use SAS Functions to manipulate character and numeric data values (use SAS functions to Convert Character & Numeric Value (auto-convert; PUT & INPUT functions), Other SAS functions include: SCAN, SUBSTR, TRIM, UPCASE, LOWCASE, PROPCASE, CATX, INDEX, TRANWRD, INT, ROUND)

  • Conditionally execute SAS statements: IF-THEN/ELSE, DO and END statements

  • Simplify your data with Array (One dimensional array; two dimensional array; Creating Variables in an ARRAY Statement; Assigning Initial Values to Arrays & Creating Temporary Array Elements)

  • Process data with DO LOOPS (the basic of DO LOOPS; constructing DO LOOPS; Conditionally Executing DO Loops using DO UNTIL and DO WHILE; Using Conditional Clauses with the Iterative DO Statement)

  • Work with data & Creating labels and formats (Use assignment statements in the DATA step; Use LABEL and FORMAT statements to modify attributes in a DATA step; Define the length of a variable using the LENGTH statement; Control which observations and variables using DROP, KEEP statements and DROP=, KEEP= options, and IF statement)

  • SAS Statistical Procedures: Proc SORT; Proc PRINT; Proc MEANS; Proc FREQ; Proc UNIVARIATE, Proc Export, Proc Content

  • Generate list reports using the PRINT procedure (using VAR, SUM, WHERE, ID and BY statements)

  • Generate reports using ODS statements (Identify ODS destinations, create HTML, PDF, RTF, and Excel files with ODS statements)

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

  • SAS advanced topic: Proc SQL Essentials

  • SAS advanced topic: SAS Macros Essentials

References:

SAS certification prep guide: base programming by SAS Institute

The little SAS book: a primer / Lora D. Delwiche and Susan J. Slaughter

Learning SAS by example: a programmer's guide / Ron Cody 


Note: A SAS software licence allows SC statistical programming to create and sell video-based SAS programming online courses.

Who this course is for:
  • absolute SAS beginners
  • Anyone interested in taking SAS BASE certification exam
Course content
Expand all 116 lectures 13:55:50
+ Course Overview, Software (SAS University Edition) set up & Course materials
6 lectures 53:02

The links to download SAS University Edition/ SAS studio provides by SAS.com:

https://www.sas.com/en_us/software/university-edition.html


This is a complete and step-by-step  guide to Install SAS studio



Install SAS University Edition (SAS studio): the complete and step-by-step guide
14:58
Virtual box 6.0: download and set up SAS University Edition & its shared folder
11:45

Hello Everyone,

This lecture is to contain ALL the course materials for this course: SAS codes/programs and Data files used in this course

SAS codes/programs and Data files, + PPTs (Power Point slides)

  • Please download the .zip folders (one for SAS programs; one for data sets)

  • all files the .zip folders are in their original SAS format, or data format

  • Multiple lectures may share/use one SAS program

  • Please copy and paste all the single files included in the .zip folders (NOT folder) into the folder  \SASUniversityEdition\myfolders , which you created when downloading and set up SAS University Edition

  • All course materials are ONLY for practice. They are copy right protected.

  • The file names inside each zip files may not be exactly the same as the ones shown in the lectures since I added a lot of extra videos at later stage and I added prefixes to the original file names. BUT by not paying much to the prefixes of the file names, it is relatively easy to match the file names in the zip files with the ones appeared in the lectures.

    Example:

    array.sas (in zip file)

    beginner_array.sas (in lecture)


Thank you for choosing my courses!

As always, good reviews are highly appreciated!

Downloadable course materials: SAS programs and Data used in the course, + PPTs
06:28
File path/directory in SAS studio
04:25

This video is for some of you who can not use the installed/downloaded SAS University Edition to access FREE SAS software SAS studio for learning. You can use SAS onDemand for academics (which is a free access Web-based SAS studio offered by SAS official site) and still be able to use all my SAS programs and data files. Hope this helps!

How to use SAS onDemand academics if you can NOT install SAS University Edition
11:53
+ Get Data into SAS: create temporary & permanent SAS data
13 lectures 01:17:38
Read data delimited by commas (.csv data file) using list input
04:39
Read data delimited by any delimiters using list input
08:51
Read data in fixed columns using column input
06:00
Read data using formatted input including using SAS informat to read dates
08:29
Read data using formatted input: use SAS format to display SAS date values
08:38
Create internal SAS data using DATALINES statement
03:00
LIBNAME statement: assign library names and create permanent SAS data sets
10:47
Proc Import: Import Excel data file into SAS
17:38
Quiz
9 questions
Coding Exercise 1
00:10
Coding Exercise 1: Solution
00:20
Coding Exercise 2
00:27
Coding Exercise 2: Solution
00:24
+ Work with data
8 lectures 01:10:13
SAS functions: overview
10:26
Conditionally execute SAS statements: IF-THEN/ELSE, DO and END statements
13:37
Conditionally execute SAS statements: IF-THEN/ELSE, DO and END statement (Cont.)
14:55
Subset your Data using subsetting IF statement and DELETE statement
08:35
Creating One-Dimensional Arrays
14:45
Quiz
4 questions
Coding Exercise
00:25

 

Coding Exercise: Solution
00:16
+ Creating labels and formats
9 lectures 59:10
Use LABEL statement to add Labels to Variables in a DATA step
07:39
Use FORMAT statement to assign Formats to Variables: SAS Built-in Formats
13:13
Create your User-Defined FORMATS
12:52
Storing and Referencing/using your User-Defined FORMATS
15:52
Define the length of a variable using the LENGTH statement
07:47
Quiz
6 questions
Coding Exercise 1
00:18
Coding Exercise 1: Solution
00:34
Coding Exercise 2
00:14
Coding Exercise 2: Solution
00:41
+ Use SAS Functions to manipulate character and numeric data values
10 lectures 01:13:55
Convert Character & Numeric Value: Auto convert, explicitly PUT & INPUT function
17:38
SCAN function: Separate a character value and obtain a specified word/string
07:11
SUBSTR function: Extract and replace a portion of a character value
10:00
TRIM and CATX functions: Concatenate character values
09:57
INDEX function: Search a character value for a specified string
09:25
UPCASE, LOWCASE and PROPCASE functions: Change the case of characters
05:53
TRANWRD function: Replace/remove characters within a character string
06:22
INT and ROUND functions: Modifying Numeric Values
06:27
Quiz
9 questions
Coding Exercise
00:24
Coding Exercise: Solution
00:38
+ Use SAS Functions to manipulate SAS date values
6 lectures 42:56
Explanation on how SAS stores date and time values; Usage of MDY function
11:16
YEAR, QTR, MONTH, DAY, WEEKDAY Functions: Extract year/quarter/month/day values
11:52
TODAY, DATE, INTCK functions: get current date value & number of time interval
07:53
DATDIF, YRDIF function: Calculate difference in days and years between two dates
11:28
Quiz
5 questions
Coding Exercise
00:09
Coding Exercise: Solution
00:18
+ Process data using DO LOOPS
6 lectures 33:26
Constructing DO loops: part 1
09:54
Constructing DO loops: part 2
09:33
Conditionally Executing DO Loops using DO UNTIL and DO WHILE
06:49
Using Conditional Clauses with the Iterative DO Statement
06:32
Quiz
8 questions
Coding Exercise
00:14
Coding Exercise: Solution
00:24
+ More on ARRAYS
7 lectures 30:35
Creating Variables in an ARRAY Statement
07:32
Assigning Initial Values to Arrays & Creating Temporary Array Elements
13:22
Two dimensional array
08:40
Quiz
6 questions
Coding Exercise 1
00:06
Coding Exercise 1: Solution
00:19
Coding Exercise 2
00:10
Coding Exercise 2: Solution
00:25
+ Combine SAS data sets
11 lectures 01:48:25
One-to-One Merging
08:27
Concatenating
09:00
Appending
10:45
Interleaving
11:49
Match merging
17:57
Types of match-merging: merge data sets one-to-one and one-to-many
14:04
Match Merging: Renaming Variables
13:05
Match Merging: Excluding Unmatched Observations
14:03
Match Merging: Selecting Variables
08:47
Quiz
10 questions
Coding Exercise
00:07
Coding Exercise: Solution
00:21