Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Personal Transformation Meditation Life Purpose Coaching Emotional Intelligence
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Data Cleaning
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee

This course includes:

  • 12.5 hours on-demand video
  • 35 articles
  • 9 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
IT & Software IT Certification SAS

SAS Programming BASE certification course for SAS Beginners

The Complete Prep Course for SAS Certified Base Programming Professionals SAS 9.4 (Exam ID A00-231, A00-233, A00-215 )
Bestseller
Rating: 4.4 out of 54.4 (2,915 ratings)
13,516 students
Created by sharon cheng
Last updated 10/2020
English
English [Auto], French [Auto], 
30-Day Money-Back Guarantee

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
Curated for the Udemy for Business collection

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

Remco Wijnhoven
Remco Wijnhoven
16 courses
12 reviews
Rating: 4.5 out of 5a year ago
*** Written at 10% of the course *** Pro: Course is comprehensive. Teacher is taken her time to make sure everything is thoroughly explained. Very nice for beginners. Con: The spoken English accent causes sometimes confusion about what word she intended to pronounce, but that may also be caused by the fact that English is not my mother language. Overall very positive...

Course content

17 sections • 117 lectures • 12h 52m total length

  • Preview03:33
  • 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
  • Downloadable course materials: SAS programs and Data used in the course, + PPTs
    06:28
  • File path/directory in SAS studio
    04:25
  • How to use SAS onDemand academics if you can NOT install SAS University Edition
    11:53

  • Preview05:53
  • Quiz: SAS introduction
    2 questions

  • Preview07:40
  • Read data delimited by commas (.csv data file) using list input
    04:22
  • Read data delimited by any delimiters using list input
    08:18
  • Read data in fixed columns using column input
    05:49
  • Read data using formatted input including using SAS informat to read dates
    08:05
  • Read data using formatted input: use SAS format to display SAS date values
    07:55
  • Create internal SAS data using DATALINES statement
    02:52
  • LIBNAME statement: assign library names and create permanent SAS data sets
    10:02
  • Proc Import: Import Excel data file into SAS
    15:29
  • 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

  • Preview06:52
  • SAS functions: overview
    09:46
  • Conditionally execute SAS statements: IF-THEN/ELSE, DO and END statements
    12:26
  • Conditionally execute SAS statements: IF-THEN/ELSE, DO and END statement (Cont.)
    13:52
  • Subset your Data using subsetting IF statement and DELETE statement
    08:02
  • Creating One-Dimensional Arrays
    13:53
  • Quiz
    4 questions
  • Coding Exercise
    00:25
  • Coding Exercise: Solution
    00:16

  • Use LABEL statement to add Labels to vars in DATA step & Proc Print Split option
    08:21
  • Use FORMAT statement to assign Formats to Variables: SAS Built-in Formats
    11:56
  • Create your User-Defined FORMATS
    11:58
  • Storing and Referencing/using your User-Defined FORMATS
    14:32
  • Define the length of a variable using the LENGTH statement
    07:07
  • Proc format with CNTLIN= option to define custom formats
    04:46
  • 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

  • Convert Character & Numeric Value: Auto convert, explicitly PUT & INPUT function
    15:59
  • SCAN function: Separate a character value and obtain a specified word/string
    06:41
  • SUBSTR function: Extract and replace a portion of a character value
    08:57
  • TRIM and CATX functions: Concatenate character values
    09:23
  • INDEX function: Search a character value for a specified string
    08:32
  • UPCASE, LOWCASE and PROPCASE functions: Change the case of characters
    05:39
  • TRANWRD function: Replace/remove characters within a character string
    05:51
  • INT and ROUND functions: Modifying Numeric Values
    06:03
  • Quiz
    9 questions
  • Coding Exercise
    00:24
  • Coding Exercise: Solution
    00:38

  • Explanation on how SAS stores date and time values; Usage of MDY function
    10:23
  • YEAR, QTR, MONTH, DAY, WEEKDAY Functions: Extract year/quarter/month/day values
    10:50
  • TODAY, DATE, INTCK functions: get current date value & number of time interval
    07:26
  • DATDIF, YRDIF function: Calculate difference in days and years between two dates
    10:02
  • Quiz
    5 questions
  • Coding Exercise
    00:09
  • Coding Exercise: Solution
    00:18

  • Constructing DO loops: part 1
    08:56
  • Constructing DO loops: part 2
    08:17
  • Conditionally Executing DO Loops using DO UNTIL and DO WHILE
    06:19
  • Using Conditional Clauses with the Iterative DO Statement
    06:06
  • Quiz
    8 questions
  • Coding Exercise
    00:14
  • Coding Exercise: Solution
    00:24

  • Creating Variables in an ARRAY Statement
    06:49
  • Assigning Initial Values to Arrays & Creating Temporary Array Elements
    11:43
  • Two dimensional array
    07:38
  • 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

  • One-to-One Merging
    07:23
  • Concatenating
    07:57
  • Appending
    09:58
  • Interleaving
    10:28
  • Match merging
    16:04
  • Types of match-merging: merge data sets one-to-one and one-to-many
    12:42
  • Match Merging: Renaming Variables
    10:50
  • Match Merging: Excluding Unmatched Observations
    12:35
  • Match Merging: Selecting Variables
    07:57
  • Quiz
    10 questions
  • Coding Exercise
    00:07
  • Coding Exercise: Solution
    00:21

Instructor

sharon cheng
SC Statistical Programming
sharon cheng
  • 4.4 Instructor Rating
  • 3,635 Reviews
  • 17,318 Students
  • 5 Courses

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

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.