21. Section Overview - Proc SQL | PharmaTrainingHub.com

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.

21. Section Overview - Proc SQL

Complete and Continue

Discussion

0 comments

Lesson Content Locked

Your session expired. Please sign in again to continue.

Login