SAS Programming BASE certification course for SAS Beginners
What you'll learn
- This course is suitable for the SAS BASE certifications including SAS Certified Specialist and SAS Certified Associate (Exam ID A00-231, A00-233, A00-215)
- All critical and essential SAS BASE Data manipulation and data preparation skills
- Handle Error by identify and solve SAS errors
- Combine, merge and restructure data sets
- SAS Statistical Procedures
- Reports generating
- 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 complete SAS BASE certification programming course for
absolute SAS beginners
anyone interested in passing the SAS BASE certification exams
SAS Certified Specialist: Base Programming Using SAS 9.4 (Exam ID: A00-231, A00-233)
SAS Certified Associate: Programming Fundamentals Using SAS 9.4 (Exam ID A00-215)
--- this course covers far more than this exam required, you may pick and learn the contents required by the exam)
Looking for Data manipulation and data preparation course using SAS? This course is also your choice. It covers all critical and essential Data manipulation and data preparation skills using SAS
Coding exercises and projects are perfect for for the practical coding questions in the exam for SAS Certified Specialist: Base Programming Using SAS 9.4
You may compare the contents covered in this course with the official SAS BASE certification Exam contents (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
the complete SAS BASE course for beginners and the SAS BASE certification exams
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 can be obtained in Lecture 4 (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 in the exam for 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 exams
Featured review
Course content
- Preview03:33
- 14:58Install SAS University Edition (SAS studio): the complete and step-by-step guide
- 11:45Virtual box 6.0: download and set up SAS University Edition & its shared folder
- 06:28Downloadable course materials: SAS programs and Data used in the course, + PPTs
- 04:25File path/directory in SAS studio
- 11:53How to use SAS onDemand academics if you can NOT install SAS University Edition
Instructor
Welcome to SC Statistical Programming!
Before I become an online SAS programming instructor, I have worked as a statistician/SAS programmer for 7 years. I am a SAS certified professional and highly proficient in SAS programming, and I enjoy teaching as well. Now I would like to use my SAS programming skills to help people learning SAS in an easy and affordable way.
I created my business SC Statistical Programming to offer free SAS programming courses and tutorial videos and coding articles, as well as affordable online video-based SAS programming courses at various levels. No matter you are a beginner or experienced professional in SAS programming, all courses are designed to help you learn SAS programming easy and efficiently.
Information about my current published courses:
A SAS BASE certificate course for absolute SAS Beginners
SAS Advanced Certificate: SAS SQL, SAS Macro & Advanced Tech
SAS Programming on Report and Table Generating
All courses offer:
1. Lifetime access 24/7; 30 days money back guarantee!
2. Each lecture/video shows hands-on coding in SAS programming environment as well as detailed step-by-step and code-by-code explanations
3. The course supplements (including SAS codes and data used in lectures) are in their own formats and stored in Zip folders for easy downloading
4. The SAS code and data are compatible across all SAS programming environments
5. Quizzes, Coding Exercises and Projects for practice