SAS Programming BASE Certification Course for SAS Beginners

This course is the complete SAS BASE programming certification preparation course. It is designed for anyone who desires to develop SAS programming skills and enter into data industries. Many data industries are eagerly hiring SAS professionals with the SAS BASE programming certification. If this is your goal, this course is right for you.

This course is suitable for absolute SAS beginners
the course is designed for anyone interested in passing the SAS BASE certification exams
(1) SAS Certified Specialist: Base Programming Using SAS 9.4 (Exam ID A00-231)
this course covers all the topics in the exam.
(2) SAS Certified Associate: Programming Fundamentals Using SAS 9.4 (Exam ID A00-215)
it is the junior version of A00-231 , this course covers more topics than required in the exam
A00-215 is NOT the prerequisite of A00-231.
Many students enrolled this course directly passed the full SAS 9.4 Base Programming (A00-231).
Course Highlights:

step by step/ code by code detailed explanations for easy and efficient learning experiences
well organized course contents
The downloadable course materials for each lecture are attached for every lecture of the course for students' convenience. (the course materials are ONLY for practice, they are protected by copyright.)
Quizzes, coding exercises and projects for practice. After all, practice makes perfection.

A Note on Course ratings and reviews:

Many students enrolled in this course successfully passed the full They have shared their successful stories with me. I am so encouraged and grateful that this course can serve as a main resource to help them obtaining the SAS BASE certification. Please share your successful stories and joys of this significant career devolvement achievement in course reviews to encourage others and me.

I constantly updating the course according to SAS certification updates as well as students' suggestions. Good and fair course reviews and ratings are truly encouraging me continuously improving the quality of the course. Course ratings above 4.5 are considered good ratings in this field.

Again, Thank you so much for choosing this course and allow me to be part of your success.

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:

The course was created using SAS software license for the SAS University Edition (the downloadable SAS studio version).
The course is also suitable to use with SAS OnDemand for Academics (the web-based SAS studio version).
The software interface/appearance and functionalities in the two SAS studio versions are identical.
Section 2 has all the details for using SAS OnDemand for Academics with this courses.

Enroll now

Or start a personal plan

And upskill your team with Udemy

Here's a deal for you

We found an offer that may be relevant to this course.

Save money when you learn. All coupon codes, vouchers, and discounts are applied automatically unless otherwise noted.

Use code at checkout. Only 29 hours left!

New customers offer

Visit Udemy from OpenCourser as a new customer and claim these savings on your first order.

What's inside

Learning objectives

This course is the complete sas base programming certification preparation course even if you are new to sas.
In this course, students will learn all sas base programming skills to obtain sas base programming certification
This course covers all topics in sas base certifications exams (a00-231 (full version) , a00-215 (junior version))

Students will also learn sas advanced topic: proc sql essentials and sas macros essentials
A00-215 is not the prerequisite of a00-231. many students enrolled this course directly passed a00-231 (full version) to save time and money.
You are welcome to free view more than 10 full lectures before enrollment.

This course is the complete sas base programming certification preparation course even if you are new to sas.
In this course, students will learn all sas base programming skills to obtain sas base programming certification
This course covers all topics in sas base certifications exams (a00-231 (full version) , a00-215 (junior version))
Students will also learn sas advanced topic: proc sql essentials and sas macros essentials
A00-215 is not the prerequisite of a00-231. many students enrolled this course directly passed a00-231 (full version) to save time and money.
You are welcome to free view more than 10 full lectures before enrollment.

Syllabus

Course Overview, downloadable course materials and free SAS software SAS studio

Course Overview

access free SAS software "SAS OnDemand for Academics/cloud-based SAS studio"

This lecture shows everything you need to know about how to use SAS OnDemand for academics/cloud-based SAS studio with this course including three steps:

Step 1. How to download course materials (SAS program, data file and PowerPoint slide for each lecture) from each lecture

Each lecture has its own downloadable lecture materials under resource which contains

(1) SAS code for the lecture (.sas file)

(2) data file used in the lecture (the file can be in different formats). A few lectures don't have external data files

(3) PDF file: Power Point slides in PDF format contain knowledge points for each lecture and is presented at the beginning of the lecture.

Step 2. How to upload the SAS programs and data files into SAS OnDemand for academics/cloud-based SAS studio in order to run SAS programs

Step 3. How to modify the file path in SAS programs, and run SAS programs using data files in SAS OnDemand for academics/cloud-based SAS studio

To modify the file path in SAS programs, there are 4 examples, which cover all the scenario you will encounter when modifying the file path in SAS programs

example 1 (infile example): start at beginning of the lecture

example 2 (proc import example): start at about 6:30 of the lecture

example 3 (libname format example): start at about 12:40 of the lecture

example 4 (create sub-folder example): start at about 17:50 of the lecture

Downloadable Power Point Slides in PDF form and SAS programs for all lectures

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

Proc Import: Import external delimited data files into SAS

Quiz

Coding Exercise

Coding Exercise: 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

Coding Exercise 1

Coding Exercise 2

Coding Exercise 2: Solution

Create 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 Variable: more on 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

Coding Exercise 1: Solution

Use SAS Functions to manipulate character and numeric data values

(1) length for gender_ac in the code gender_ac = gender||'/'||(gender_code);

gender_ac occupies 14 because

gender occupies 1, gender_code occupies 8, ||'/'|| occupies 5 (|| occupies 1, '/' - 3, || occupies 1)

(2) After running the same code in SAS ondemand (web-based SAS studio), we found there are spaces in the values of gender_ac, and gender_char is not left-aligned.

(The result shown in the video (without above issues) is the one when I used SAS University (an expired installed SAS studio). I found a couple of incidents that these two type of SAS studio acts differently, this is one of them. )

To resolve this, we can add LEFT function to left align the values of gender_code (we can tell the values of gender_code are right aligned -- this is the reason why we got spaces in gender_ac, and not left-aligned gender_char )

Here is the code:

/*add LEFT function to left aline gender_code*/

data scoredata2;

set scoredata0;

gender_ac = gender||'/'||left(gender_code); /*auto*/

gender_char = put (left(gender_code), 8.); /*put*/

run;

SCAN function: Separate a character value and obtain a specified 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

FIND function: search for substrings of characters in a character string

UPCASE, LOWCASE and PROPCASE functions: Change the case of characters

TRANWRD function: Replace/remove characters within a character string

SAS numeric functions: INT and ROUND functions: Modifying Numeric Values

additional SAS numeric functions: Smallest and Largest functions

additional SAS numeric functions: RAND function

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

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

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

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

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

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Emphasizes SAS skills needed for data industry employment, particularly the SAS Base certification

Covers both SAS Base certification exams and more advanced SAS topics, making it suitable for various skill levels and certification goals

Follows a step-by-step and code-by-code approach, making it accessible to learners of all levels

Provides downloadable course materials, quizzes, coding exercises, and projects for reinforcement and practice

Instructor has a history of teaching successful students who have passed the SAS Base certification exam

Requires learners to have access to SAS software, which may incur additional costs

Save this course

Save SAS Programming BASE Certification Course for SAS Beginners to your list so you can find it easily later:

Save

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in SAS Programming BASE Certification Course for SAS Beginners with these activities:

Refresh SAS knowledge

Show steps

Revisit and practice fundamentals of SAS to strengthen your foundation before beginning the course.

Browse courses on SAS

Show steps

Review the SAS documentation for basic syntax and commands.
Complete interactive tutorials on SAS programming.
Practice writing simple SAS programs that cover basic data manipulation and analysis tasks.

Create a SAS practice dataset

Show steps

Develop a customized dataset tailored to your interests, providing hands-on experience in data creation and management.

Browse courses on Data Manipulation

Show steps

Gather raw data from a reliable source or create your own data points.
Import the data into SAS and explore its structure.
Create a new SAS dataset with a logical and organized structure.
Validate the dataset for accuracy and completeness.

Review SAS certification prep guide

Show steps

Bolster your understanding of the SAS certification exam by studying a comprehensive preparation guide.

View SAS Certified Professional Prep Guide: Advanced... on Amazon

Show steps

Obtain a copy of the SAS certification prep guide.
Read through the chapters, focusing on the topics covered in the certification exam.
Complete practice questions and exercises to test your knowledge.

Show all three activities

Career center

Learners who complete SAS Programming BASE Certification Course for SAS Beginners will develop knowledge and skills that may be useful to these careers: