Complete SAS Macro tutorial for beginners to Advanced SAS programmers (6 Hours long)

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.

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
b) Designing a advanced SAS macro - Case Study
c) Increasing length of all character variables in a dataset without hard coding
d) Date as SAS Macro variable – common issues and solutions
e)

2. Some important papers discussed in this video
Link to Art Carpenter paper regarding SAS Macro libraries

. SAS Macro quoting function papers.

[sudheerupputuri]

Very good explanation of hidden features of macro concepts and presentation was very cool and outstanding.
Thank you so much for such wonderful presentation.

[beedee]

Superb, keep it up. So nicely and methodically explained and clear diction.

[agupta]

Thanks for making this video, it has been very helpful in understanding macro concepts

[readistreet]

Thanks a lot, you have helped me a lot, please keep making this videos, they are excellent!

[manohargoud]

Excellent Explanation Of SAS Concepts, , Fantastic Teaching Bro Simply Superb.. Please Do Many More Related To SAS...We Will Encourage You Keep Rocking...

[jinqiuhuang]

Very clear explanation! It would be wonderful if I could download your slides. Thanks so much!

[vikramtri]

Thank you so much bro .... your videos more useful for us.

[shwetajaiswal]

Thank you sir for such a helpful video.

Thaks sir, please make a complete video tutorial on sas etl and other data analyst technique

[utkarshsrivastava]

Thanks @kiran for this video it helped me a lot for cracking the interviews!!
👍👍👍

[virendradhumal]

very nice video espelly for beginners like me..ty....where can we find raw dataset along with ans code for a practice for sdtm and adam?

[abhishekdixit]

Can you please tell if you have explained how we can pass multiple values in a macro variable in this tutorial? If not could you please make a video on it?
Scenario is like, suppose we have a procedure as:-

Proc print data= &dsn;
run;

So in this I want to pass 5 datasets like sashelp.class, sashelp.cars and some other datasets also...so how this can be achieved?
Also if we use loop like i= 1 to 5 to pass the datasets how this count can be done dynamically rather than hardcoding it to i= 1 to 5.

Please make a video on it.🙏🙏🙏

[srikanthreddy]

Could you explain control flow(compile and execution)of proc step and also macros

[AnilKumarnn]

TIL: The forward rescan rule for macros.

[gerardtetegan]

why "catt" in symputx and not "cats", especially since before now, concern was about leading blanks?

[okayMrN]

Is it possible to get this presentation deck sir? Thanks a lot..

[kanthreddy]

Write a macro to split data into N number of datasets

Suppose you are asked to write a macro to split large data into 2 parts (not static 2). In the macro, user should have flexibility to change the number of datasets to be created.
How to do this problem sir

[farzeenshaikh-jo]

I tried %let dsn=sashelp.class;
and then trying to apply proc sort (PROC SORT DATA=&dsn ; BY SEX; RUN;)step its not working why?
do u have any idea ?