Very good explanation of hidden features of macro concepts and presentation was very cool and outstanding. Thank you so much for such wonderful presentation.
Excellent Explanation Of SAS Concepts,, Fantastic Teaching Bro Simply Superb.. Please Do Many More Related To SAS...We Will Encourage You Keep Rocking...
information related to procs is proprietary, so we really do not know what happens with relation to proc. With Macro, i think I explain compilation and execution of the macro.
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.🙏🙏🙏
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
What is the error message. Check the error message. This helps us to understand things better. Always run code without macro variables first and see what happens. If you do proc sort data=sashelp.class; run:. Clue that will not work either and why it will not work and why it does not work. It will be in your log
Use Correction: You do not have permission to modify sashelp.class data. First create your own data from sashelp.class. There after, you can apply the changes I mentioned before into your code.
Very good explanation of hidden features of macro concepts and presentation was very cool and outstanding.
Thank you so much for such wonderful presentation.
Superb, keep it up. So nicely and methodically explained and clear diction.
Thanks for making this video, it has been very helpful in understanding macro concepts
Thanks a lot, you have helped me a lot, please keep making this videos, they are excellent!
Thank you so much bro .... your videos more useful for us.
Thank you sir for such a helpful video.
Excellent Explanation Of SAS Concepts,, Fantastic Teaching Bro Simply Superb.. Please Do Many More Related To SAS...We Will Encourage You Keep Rocking...
Thanks, and I appreciate your support
Very clear explanation! It would be wonderful if I could download your slides. Thanks so much!
Sure. please send email to smarttech089@gmail.com. I will email you the slides
@@kiranvenna Did it. Thanks so much!
Thaks sir, please make a complete video tutorial on sas etl and other data analyst technique
May be sometime in future
Thanks @kiran for this video it helped me a lot for cracking the interviews!!
👍👍👍
Thanks Utkarsh, appreciate your kind comments
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?
Thank you and sorry I am not from clinical SAS.
Nice
Could you explain control flow(compile and execution)of proc step and also macros
information related to procs is proprietary, so we really do not know what happens with relation to proc. With Macro, i think I explain compilation and execution of the macro.
@@kiranvenna please send me the macro link
TIL: The forward rescan rule for macros.
Thank you so much bro
why "catt" in symputx and not "cats", especially since before now, concern was about leading blanks?
I just did out of common preference, it does not matter.
@SMARTTECH oh ok! I assumed that catt only handled the trailing blanks. Thanks for your response.
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.🙏🙏🙏
All this are there and in more depth in there. check out proc sql into part and call execute
@@kiranvenna thankyou so much...your videos are really helpful 👍
Is it possible to get this presentation deck sir? Thanks a lot..
Please share your email, I will email it to you
@@kiranvenna thank you so much sir for creating a wonderful video on such a complex topic
I will be patiently waiting for the deck, if you kindly share please sir
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
check this solution on this topic
blogs.sas.com/content/sgf/2020/07/23/splitting-a-data-set-into-smaller-data-sets/
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 ?
What is the error message. Check the error message. This helps us to understand things better. Always run code without macro variables first and see what happens. If you do proc sort data=sashelp.class; run:. Clue that will not work either and why it will not work and why it does not work. It will be in your log
@farzeenshaikh. You forgot double quotes. You xhould be good if you do this: DATA = "&dsn";
Use Correction: You do not have permission to modify sashelp.class data. First create your own data from sashelp.class. There after, you can apply the changes I mentioned before into your code.