Autoplay
Autocomplete
Previous Lesson
Complete and Continue
The Simplest Guide to Advanced SAS Programming - Macros - SQL
Section 1: Introduction
1. Why SAS (1:24)
2. Why is SAS so easy to learn (2:45)
Section 2: Installing SAS
3. SAS studio through SAS On Demand (4:16)
4. Logging-in to SAS after installation (0:42)
5. SAS Interface and windows (6:00)
Section 3: SAS Macros
6. Section Overview - Macros (0:06)
7. Macro Variables - Introduction (10:23)
8. Macro Variables - Introduction - Code (3:43)
9. Application of Macro Variables (1:29)
Resource - Application of Macro Variables
10. Application of Macro Variables-Code (11:05)
11. Nested Macro Vars (10:56)
Resource - Nested Macro Vars
12. More on Ampersand and Resolutions (9:04)
Resource - More on Ampersand and Resolutions
Assignment 1: Ampersand Resoluton
Assignment 1: Ampersand Resolution INSTRUCTOR EXAMPLE
13. Macro Functions (3:30)
Resource - Macro Functions
14. Macro Functions-Code (8:41)
Assignment 2: Using macro variables in data step and proc step
Assignment 2: Using macro variables in data step and proc step INSTRUCTOR EXAMPLE
15. SAS Macros - Introduction (10:11)
Resource - SAS Macros
16. SAS Macros - Examples (7:11)
Resource - Macros Examples
17. Keyword Positional and Mixed Parameters (6:05)
Assignment 3: Paramaters in Macros
Assignment 3: Paramaters in Macros INSTRUCTOR EXAMPLE
18. Conditional Logic in Macros using IF-ELSE (10:49)
Assignment 4: Reusing Macros to do more
Assignment 4: Reusing Macros to do more INSTRUCTOR EXAMPLE
19. Options Statement - MPRINT - MLOGIC - SYMBOLGEN (12:45)
20. Connecting the Two Worlds - Call Symput and Symget (13:56)
Assignment 5: Macro for Charts
Assignment 5: Macro for Charts INSTRUCTOR EXAMPLE
QUIZ 1 - Macros
Practice Test 1 - Macros
Section 4: Proc SQL
21. Section Overview - Proc SQL (0:06)
22. Copying Data (13:15)
Resource - Copying data
23. Filtering Data (6:54)
Resource - Filtering data
24. Sorting Data (8:27)
Resource - Sorting data
25. Removing Duplicates (5:27)
Resource - Removing Duplicates
Assignment 6: Analyzing the cars data
Assignment 6: Analyzing the cars data INSTRUCTOR EXAMPLE
26. Union Set Operator (8:34)
Resource - Union Set Operator
27. Except Set Operator (4:28)
Resource - Except Set Operator
28. Intersect Set Operator (1:39)
Resource - Intersect Set Operator
29. Merging Data Using Joins (7:42)
30. Inner Join (14:18)
Resource - Inner Join
31. Full Join (7:42)
Resource - Full Join
32. Outer Joins - Left and Right Joins (6:52)
Resource - Left and Right Joins
33. Creating Macro Variables from Proc SQL (6:48)
Resource - Creating Macro Variables from Proc SQL
Assignment 7: Macro vars from proc SQL
Assignment 7: Macro vars from proc SQL INSTRUCTOR EXAMPLE
QUIZ 2 - Proc SQL Quiz
Practice Test 2 - Proc SQL
Section 5: Final Assignment
Assignment 8 - Project Airlines
Assignment 8 - Project Airlines INSTRUCTOR EXAMPLE
Did you like this course?
Did you like this course, was it helpful? Tell us about it.
13. Macro Functions
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock