Complete SAS Macro tutorial for beginners to Advanced SAS programmers (6 Hours long)
SMARTTECH
0:00 / 0:00
Complete SAS Macro tutorial for beginners to Advanced SAS programmers (6 Hours long)
25 712 просмотров · 4 года назад
SMARTTECH
9,36 тыс. подписчиков
25 712 просмотров · 4 года назад
For any queries please contact us at smarttech089@gmail.com.
Below is timeline for Chapters
0:00 Basic Introduction
1:48 Part 1 Macro Introduction.
28:34 Part 2 Macro variables and %let statements.
56:26 Part 3: Macro and Macro parameters.
01:25:57 Part 4: Conditional and iterative macro statement
02:02:52 Part 5: Creating macro variables with Proc SQL and three ways to use them
02:44:59 Part 6: CALL SYMPUT/CALL SYMPUTX and comparison with PROC SQL into
03:13:52 Part 7a (Macro functions): Macro Quoting functions
03:58:51 Part 7b :Evaluation, %sysfunc and character based Macro functions.
04:32:55 Part 8: Macro Libraries.
04:58:47 Part 9: Macro facility interaction with Call execute
05:28:22 Part 10: Scope of Macro Variables
05:52:44 Conclusion.
For any queries please contact us at smarttech089@gmail.com.
1. Some useful links related to SAS related to Macro design and problem solving.
a) Step by step approach to build a SAS macro - Basic
• Step by step approach to build a SAS macro...
b) Designing a advanced SAS macro - Case Study
• Designing a advanced SAS macro - Case Study
c) Increasing length of all character variables in a dataset without hard coding
• Increasing length of all character variabl...
d) Date as SAS Macro variable – common issues and solutions
• Date as SAS Macro variable – common issues...
e)
• How to sort SAS dataset without using proc...
2. Some important papers discussed in this video
Link to Art Carpenter paper regarding SAS Macro libraries
https://support.sas.com/resources/pap...
. SAS Macro quoting function papers.
https://www.lexjansen.com/nesug/nesug...
https://support.sas.com/resources/pap....