This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
SAS Programming on Data Manipulation and Preparation: Part 1
Course Overview and Course Supplements
Course Overview (2:46)
course supplements: SAS code files and Data files (0:35)
Creating labels and formats
Adding Labels to Your Variables (8:21)
Assigning Formats to Variables and more on SAS Built-in Formats (11:56)
Creating your user-defined formats (11:58)
Storing and Referencing/using your user-defined formats (14:32)
Specifying Lengths for Variables (7:06)
Quiz
Coding Exercise 1
Coding Exercise 1: Solution
Coding Exercise 2
Coding Exercise 2: Solution
Modifying character and numeric data values
Convert Character and Numeric Values (15:59)
Separate a character value and obtaining a specified word using SCAN function (6:41)
Extracting and replacing a portion of a character value using SUBSTR function (8:57)
Concatenate character values using TRIM and CATX functions (9:23)
INDEX function: Search a character value for a specified string (8:32)
Change the case of characters using UPCASE, LOWCASE and PROPCASE functions (5:39)
TRANWRD function: Replace/remove characters within a character string (5:51)
Modifying Numeric Values: INT and ROUND functions (6:03)
quiz
Coding Exercise 3
Coding Exercise 3: Solution
Working with SAS dates
Create a SAS date value from the month, day, and year values (MDY function) (10:23)
Extract year/quarter/month/day values (YEAR, QTR, MONTH, DAY and WEEKDAY Functions) (10:50)
Obtain SAS current date value (DATE and TODAY Functions) and the number of time intervals (INTCK function) (7:26)
Calculate the difference in days and years between two dates (DATDIF and YRDIF Functions) (10:02)
Quiz
Coding Exercise 4
Coding Exercise 4: Solution
Generating data with DO loops
Constructing DO loops: part 1 (8:56)
Constructing DO loops: part 2 (8:17)
Conditionally Executing DO Loops using DO UNTIL and DO WHILE (6:19)
Using Conditional Clauses with the Iterative DO Statement (6:06)
Quiz
Coding Exercise 5
Coding Exercise 5: Solution
More on processing variables with ARRAYS
Creating One-Dimensional Arrays (13:53)
Creating Variables in an ARRAY Statement (6:48)
Assigning Initial Values to Arrays & Creating Temporary Array Elements (11:43)
Two dimensional array (7:38)
Quiz
Coding Exercise 6
Coding Exercise 6: Solution
Coding Exercise 7
Coding Exercise 7: Solution
Coding Exercise 2
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock