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.
114. Application of Macro variables
Complete and Continue
Discussion
0
comments
Load more
Lesson Content Locked
Your session expired. Please sign in again to continue.
Login
0 comments