Autoplay
Autocomplete
Previous Lesson
Complete and Continue
The Simplest Guide to SAS Programming - SAS Base - SAS Advanced
Section 1: Course Introduction and Overview on SAS
Why SAS (1:24)
1. Course Overview (2:26)
Section 2: Getting started with SAS Programming
2. Why is SAS so easy to learn (2:45)
3. SAS Studio through SAS OnDemand-Registration (3:31)
4. Logging-in to SAS after registration (0:54)
5. SAS Interface and windows (6:00)
QUIZ 1: SAS user interface/windowing environment
Resource - SAS OnDemand Registration and Log in
Section 3: Preparing Data
6. Preparing Data - Section Overview (0:57)
7. SAS Datasets Variables and Observations (8:44)
Resource - Myclass
8. SAS Libraries (4:50)
9. Library Naming Conventions (4:48)
10. SAS Dataset naming conventions (4:05)
11. SAS Program Syntax (6:57)
Resource - Cars
12. SAS Data Step and Proc Step (2:35)
Resource - Cars
13. Referencing data in SAS (4:18)
Resource - Cars
QUIZ 2: Elements
14. Bringing data into SAS (11:48)
15. Bringing data into SAS using Import Wizard (3:45)
Resource - Bringing data into SAS mycars
16. Bringing data into SAS using LIBNAME statement (5:14)
Resource - SAS using LIBNAME (1:53)
17. Bringing data into SAS using FILENAME (5:07)
Resource - SAS using FILENAME
QUIZ 3: Bringing data into SAS
Assignment 1: Bringing data into SAS
Assignment 1: Bringing data into SAS - Instructor Example
18. Bringing data into SAS using DELIMITER option (3:19)
Resource - Delimiter
Assignment 2: Bringing data into SAS using Delimiter option
Assignment 2: Bringing data into SAS using Delimiter option - Instructor Example
19. Bringing data into SAS using DSD option (7:36)
Resource - Dsd delimiter
20. Bringing data into SAS using column input (4:02)
Resource - Column input
21. Bringing data into SAS using the column pointer @ symbol (1:53)
Resource - Column pointer
22. Bringing data into SAS using the line pointer # symbol (7:10)
Resource - Line pointer
23. Bringing data into SAS using the line slash symbol (2:25)
Resource - Slash symbol
24. Bringing data into SAS using the trailing @ symbol (3:09)
Resource - Single trailing at symbol
25. Bringing data into SAS using the trailing @@ symbol (2:26)
Resource - Double trailing at symbol
QUIZ 4: Bringing Data into SAS Advanced Methods
Assignment 3: Bringing data into SAS using advanced options
Assignment 3: Bringing data into SAS using advanced options - Instructor Example
26. Bringing data into SAS using Proc Import XLS (MS Excel) (6:48)
Resource - Proc Import - Class
27. Bringing data into SAS using Proc Import TXT Files (4:48)
Resource - Proc+Import+ - Class - Classtab
QUIZ 5: Bringing data into SAS using Import procedure
Assignment 4: Get "berries" data into your SAS session
Assignment 4: Get "berries" data into your SAS session - Instructor Example
28. Creating new variables (4:08)
29. Creating new variables - coding exercise (8:23)
Resource - New Variables
30. Keeping, Dropping and Renaming Variables in a Dataset (2:59)
Resource - Keep, Drop, Rename
Assignment 5: Conditional logic and filtering data
Assignment 5: Conditional logic and filtering data - Instructor Example
31. If-else conditional statements - deriving BMI variable (4:11)
32. If-else conditional statements - deriving STATUS variable (11:26)
Resource - If else
33. Filtering data (11:17)
Resource - Filtering
QUIZ 6: New variables, conditional logic
Assignment 6: Finding the most expensive cars
Assignment 6: Finding the most expensive cars - Instructor Example
34. SAS dates (6:48)
Resource - Sas dataset
35. SAS Character functions - Upcase function (9:39)
Resource - Char Function
36. SAS Character functions - Lowcase, Propcase, Len, Cat functions (7:54)
37. SAS Character functions - Substr function (4:27)
Resource - Char Function Substr
38. SAS Character functions - Trim, Left, Strip, Compress, Compbl functions (12:42)
39. SAS Character functions - Scan function (1:50)
40. SAS Character functions - Index functions (6:34)
41. SAS Numeric functions - Sum function (7:12)
42. Null Dataset (3:36)
43. SAS Numeric functions - Abs function (1:36)
44. SAS Numeric functions - Ceiling, Floor and Integer functions (3:42)
45. SAS Numeric Functions - Minimum and Maximum functions (1:40)
QUIZ 7: SAS Dates and SAS Functions
Assignment 7: Applying SAS Functions
Assignment 7: Applying SAS Functions - Instructor Example
46. SAS Formats - Introduction (2:50)
47. SAS Format Statement (5:20)
48. Format Naming Convention (9:13)
49. Format using PUT function (8:50)
Resource - Formats
50. SAS Informats (6:21)
51. SAS Informats - code (7:32)
Resource - Informats
52. Custom formats using Proc Format (5:28)
53. Custom formats using Proc Format - code (11:07)
Resource - Proc+format
QUIZ 8: Formats in SAS
Assignment 8: Applying SAS formats
Assignment 8: Applying SAS formats - Instructor Example
54. Program Data Vector (PDV) (5:43)
55. PDV Implicit Output - Descriptor portion (4:52)
56. PDV Implicit Output - var data portion (9:36)
57. PDV Explicit Output (6:00)
58. PDV Explicit Output - code (11:01)
Resource - PDV
59. Do Loops (4:08)
Resource - Do Loops
QUIZ 9: Behind the scenes
Assignment 9: Using explicit output statement
Assignment 9: Using explicit output statement - Instructor Example
Practice test 1: Preparing data
60. Guided Exercise - "Project Cars" - Introduction (1:29)
Assignment 10: "Project Cars" - Exercise 1 (1:25)
Assignment 10: "Project Cars" - Exercise 1 - Instructor Example
Assignment 11: Secret SAS Proc revealed!
Assignment 11: Secret SAS Proc revealed! - Instructor Example
61. Preparing data - Section Conclusion (1:08)
Section 4: Structuring Data
62. Structuring Data - Section Overview (1:08)
63. Stacking data using a Data Step (5:35)
Resource - Data Step
64. Stacking data using PROC APPEND (7:48)
65. Stacking data using PROC APPEND - code (6:43)
Resource - Stacking Data Proc Append
66. Interleaving data (9:02)
Resource - Interleaving
QUIZ 10: Stacking of data
67. Sorting data using PROC SORT (7:04)
68. Sorting data using PROC SORT- multi-level sorting (6:02)
Assignment 12: Interleaving Data
Assignment 12: Interleaving Data - Instructor Example
69. Removing duplicates-NODUP option (11:09)
Resource - Proc Sort Nodup
70. Removing duplicates-NODUPKEY option (10:35)
Resource - Proc Sort Nodupkey
QUIZ 11: Sorting Data
Assignment 13: Removing Duplicates
Assignment 13: Removing Duplicates - Instructor Example
71. Simple merging of data (8:42)
Resource - Merging
72. Merging data using Joins-Introduction (7:42)
73. Merging data using Joins-Inner Join (8:18)
74. Merging data using Inner Join - code (7:52)
Resource - Inner Join
75. Merging data using Full Join (7:13)
Resource - Full Join
76. Merging data using Left Join (6:15)
Resource - Left Join
77. Merging data using Right Join (3:41)
Resource - Right Join
78. Merging data using "Far" Joins (6:26)
Resource - "Far" Join
QUIZ 12: Merging data
Assignment 14: Merging data
Assignment 14: Merging data - Instructor Example
79. Proc SQL - copying data (8:55)
80. Proc SQL - copying data - code (4:19)
Resource - Copying Data
81. Proc SQL - filtering data (6:54)
Resource - Filtering Data
82. Proc SQL - sorting data (8:27)
Resource - Sorting Data
83. Proc SQL - removing duplicates (5:27)
Resource - Removing duplicates
QUIZ 13: Proc SQL
Assignment 15: Proc SQL
Assignment 15: Proc SQL - Instructor Example
84. Transposing data - ID statement (3:55)
85. Transposing data - ID statement - code (8:06)
Resource - Transposing
86. Transposing data - BY statement (9:40)
87. Transposing data - BY statement - code (4:28)
Resource - Transposing by statement
QUIZ 14: Transposing Data
Assignment 16: Transposing Data
Assignment 16: Transposing Data - Instructor Example
Resource - Transposing Data
88. Retain statement - Introduction (7:23)
89. Retain statement - How it is used (6:18)
Resource - Retain
90. Retain statement - Example (8:00)
Resource - Retain
Assignment 17: Retain statement
Assignment 17: Retain statement - Instructor Example
QUIZ 15: Structuring Data
Assignment 18 "Project Cars" - Exercise 2 (1:27)
Assignment 18 "Project Cars" - Exercise 2 - Instructor example (5:55)
91. Structuring data - Section Conclusion (0:47)
Section 5: Visualizing Data
92. Visualizing Data - Section Overview (0:38)
93. Charts - Introduction - Vertical Bar Chart (4:46)
94. Charts - Horizontal Bar and Pie Charts (4:46)
95. Vertical Bar Chart - DISCRETE option (9:36)
Resource - Chart discrete option vbar
96. Horizontal Bar Chart - DISCRETE option (1:27)
Resource - Chart discrete option hbar
97. Vertical Bar Chart - groups and subgroups (11:28)
Resource - Chart group and subgroup vbar
98. Horizontal Bar Chart - groups and subgroups (3:13)
Resource - Chart group and subgroup hbar
99. Plots (4:36)
Resource - Plot
Assignment 19: Charts - advanced options
Assignment 19: Charts - advanced options - Instructor example
100. Report Output using PROC PRINT (6:06)
Resource - Report output
101. Report Output using PROC REPORT- DISPLAY option (7:48)
Resource - Proc report
102. Report Output using PROC REPORT- ORDER & GROUP option (4:58)
Assignment 20: Report output
Assignment 20: Report output - Instructor example
103. Summary stats - PROC FREQ (8:03)
Resource - Proc freq
104. Summary stats - PROC MEANS (3:04)
Resource - Proc means
105. Summary stats - PROC UNIVARIATE (2:19)
Resource - Proc univariate
Assignment 21: Statistical Reported Output
Assignment 21: Statistical Reported Output - Instructor example
106. Output Delivery System (ODS) - Report formats (2:29)
Resource - ODS Report formats
107. ODS with PROC FREQ (4:17)
Resource - ODS freq
108. ODS with PROC MEANS (1:48)
Resource - ODS means
109. ODS with PROC UNIVARIATE (4:04)
Resource - ODS univariate
Assignment 22: Output Delivery System
Assignment 22: Output Delivery System - Instructor example
QUIZ 16: Visualizing Data
Assignment 23: "Project Cars" Exercise 3 - Statement (0:31)
Assignment 23: "Project Cars" Exercise 3 - Instructor Example
110. Section Conclusion - Visualizing data (0:52)
Section 6: Optimizing Code
111. Optimizing Code - Section Overview (0:25)
112. Macro Variables - introduction (10:23)
113. Macro Variables - code (3:43)
114. Application of Macro variables (1:29)
115. Application of Macro variables - code (11:05)
Resource - Macro Vars
116. Nested macro variables and Ampersand resolutions (10:56)
Resource - Nested Macro Vars
117. More on Ampersand resolutions using a cool example (9:04)
Resource - Ampersand resolutions
Assignment 24: Macro Variables
Assignment 24: Macro Variables - Instructor example
118. SAS Macros - introduction (10:11)
Resource - Macros
119. SAS Macros - Examples (7:11)
Resource - Macros examples
120. Macro Functions (3:30)
121. Macro Functions - code (8:41)
Resource - Functions
Assignment 25: SAS Macros
Assignment 25: SAS Macros - Instructor example
Practice Test 2: Test on Structuring data, visualizing data and macros
Assignment 26: Guided Exercise - "Project Cars" - Exercise 4 (0:55)
Assignment 26: Guided Exercise - "Project Cars" - Exercise 4 - Instructor example
122. Section Conclusion - Optimizing code (0:30)
Section 7: Practice Exercise | Case Study
123. Guided Exercise - "Project Heavy-weight" - Introduction to the project and data (2:15)
Assignment 27: Guided Exercise - "Project Heavy-weight" - Project 1 (0:23)
Assignment 27: Guided Exercise - "Project Heavy-weight" - Project 1 - Instructor example (13:28)
Assignment 28: Guided Exercise - "Project Heavy-weight" - Project 2 (0:21)
Assignment 28: Guided Exercise - "Project Heavy-weight" - Project 2 - Instructor example (8:02)
Assignment 29: Guided Exercise - "Project Heavy-weight" - Project 3 (0:31)
Assignment 29: Guided Exercise - "Project Heavy-weight" - Project 3 - Instructor example (4:13)
Assignment 30: Project Airlines
Assignment 30: Project Airlines - Instructor example
124. And one last thing... Bonus lecture! (1:43)
Did you like this course?
Did you like this course, was it helpful? Tell us about it.
23. Bringing data into SAS using the line slash symbol
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock