We may earn an affiliate commission when you visit our partners.
Course image
Sharon Cheng

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.

Read more

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:

  1. step by step/ code by code detailed explanations for easy and efficient learning experiences

  2. well organized course contents

  3. 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.)

  4. 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

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.

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"
Read more

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
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
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
Bolster your understanding of the SAS certification exam by studying a comprehensive preparation guide.
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:

Reading list

We haven't picked any books for this reading list yet.

Share

Help others find this course page by sharing it with your friends and followers:

Similar courses

Here are nine courses similar to SAS Programming BASE Certification Course for SAS Beginners.
Practical SAS Programming and Certification Review
Most relevant
Practicing for the SAS Programming Certification Exam
Most relevant
Preparing for the SAS Programming Certification Exam
Most relevant
Preparing for the SAS® Viya® Programming Certification...
Most relevant
SAS Programming Complete: Learn SAS and Become a Data...
Most relevant
SAS® Programming for Distributed Computing in SAS® Viya®
Most relevant
Doing More with SAS Programming
Most relevant
Getting Started with SAS Programming
Most relevant
CASL Programming for Distributed Computing in SAS® Viya®
Most relevant
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2024 OpenCourser