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)
13. Macro Functions (3:30)
14. Macro Functions-Code (8:41)
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)
18. Conditional Logic in Macros using IF-ELSE (10:49)
19. Options Statement - MPRINT - MLOGIC - SYMBOLGEN (12:45)
20. Connecting the Two Worlds - Call Symput and Symget (13:56)
QUIZ 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
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. 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
QUIZ 2 - Proc SQL Quiz
14. Macro Functions-Code
Complete and Continue