Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
This course was updated on 11/2016.
Do you already have some basic SAS programming knowledge? Do you want to enter the highly demanded SAS/data industry and become a SAS programing professional? If you answer yes, then “SAS Programming on Data Manipulation and Preparation: Part 1” is the right course for you!
Almost all the data needs to be manipulated/prepared before data analysis. Every SAS programmer is required to master SAS data manipulation and preparation programming skills, which are critical and highly demanded in the SAS/data industries. This course can also help prepare you for SAS Base Programming Certification Exam.
This course is at the beginner to intermediate level. It is designed to help you master SAS Base Programming Essentials on Data Manipulation and Preparation. This course (Part 1) is focusing at variables’ level. The topics includes Creating labels and formats, Modifying character and numeric data values, Working with SAS dates, Generating data with DO loops, Processing variables with ARRAYS. The next course “SAS Programming on Data Manipulation and Preparation: Part 2” will be focusing at data sets modifications including data merging, combining, transforming, etc.
As the same as my other SAS programming courses, this course utilizes
· Hands-on coding in SAS programming environment as well as detailed step-by-step explanations to make your learning easy and fast.
· The course supplements (including SAS codes and data used in lectures) are easy downloadable for your own practice.
· This course was created using the SAS University Edition (The free SAS programming environment provided by SAS). The SAS code and data are compatible across all SAS programming environments.
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
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Course Overview and Supplements|
course supplements: SAS codes and Data files in zip folder
|Section 2: Creating labels and formats|
Adding Labels to Your Variables
Assigning Formats to Variables and more on SAS Built-in Formats
Creating your user-defined formatsPreview
Storing and Referencing/using your user-defined formats
Specifying Lengths for Variables
|Section 3: Modifying character and numeric data values|
Converting Character and Numeric ValuesPreview
SCAN function: Separate a character value and obtain a specified word
SUBSTR function: Extract and replace a portion of a character value
Concatenate character values using TRIM and CATX functions
INDEX function: Search a character value for a specified string
Change the case of characters using UPCASE, LOWCASE and PROPCASE functions
TRANWRD function: Replace/remove characters within a character string
Modifying Numeric Values: INT and ROUND functions
|Section 4: Working with SAS dates|
MDY function: Create a SAS date value from the month, day, and year valuesPreview
Extract year/quarter/month/day values(YEAR, QTR, MONTH, DAY and WEEKDAY Function
Obtain current date value and the number of time interval (TODAY, DATE, INTCK)
Calculate the difference in days and years between two dates (DATDIF, YRDIF)
|Section 5: Generating data with 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
|Section 6: More on processing variables with ARRAYS|
Creating One-Dimensional Arrays
Creating Variables in an ARRAY StatementPreview
Assigning Initial Values to Arrays & Creating Temporary Array Elements
Two dimensional array
|Section 7: Additional Lectures|
Import Excel file into SAS using Proc Import
Before I become an online SAS 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 have a website offering free SAS tutorial videos (also available on my YouTube channel TreehouseofSASprogramming) and affordable online SAS tutorial courses at various levels.