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
18. Bringing data into SAS using DELIMITER option (3:19)
Resource - Delimiter
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
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
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
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
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
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
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
Practice test 1: Preparing data
60. Guided Exercise - "Project Cars" - Introduction (1:29)
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)
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
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
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
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
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
QUIZ 15: Structuring Data
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
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)
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
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
QUIZ 16: Visualizing Data
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
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
Practice Test 2: Test on Structuring data, visualizing data and macros
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)
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.
26. Bringing data into SAS using Proc Import XLS (MS Excel)
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock