I have one query while looping for the 2nd time i becomes 2 so table2 becomes a macro variable and col2 becomes a macro variable. But we are only having table and cold macro variable.then how is it reading this ???
using call symput or proc sql into clause you can create macro variable for each value in a table. using above idea what we have done is we have created a table with the table names in it so that we can create macro variable name for each table and loop through those values easily.
proc sql should have quit. But if you do not mention quit in SAS studio, in background quit is added. What I have done is not recommended, but it works in SAS Studio.
Very useful video. Your channel is my go to guide for some awesome SAS scenario based questions. Thank you for your time and effort
Thank you, sir, for this video, it's very helpful
Excellent video and examples. Thank you!
excellent explanation! its so useful for me. Thanks for posting the video, but needs to reach lot of needy people like me!
Thank you so much for this presentation with a simple example.
please keep uploading this type of examples
It was very easy to understand. Thank you !
Greatly useful. U r awesome in explaining stuffs
Thank you Bro..u r a good teacher..neatly explained
Thanks, this was very helpful
Really useful thanks
Thank you🙏💕
Hi, Small doubt, how you got the 'var' columns in the output as you took the data by creating reference table with only two columns
var columns are from first_status, second_status , third_status or fourth_status datasets
I have one query while looping for the 2nd time i becomes 2 so table2 becomes a macro variable and col2 becomes a macro variable. But we are only having table and cold macro variable.then how is it reading this ???
using call symput or proc sql into clause you can create macro variable for each value in a table.
using above idea what we have done is we have created a table with the table names in it so that we can create
macro variable name for each table and loop through those values easily.
Hello sir..
Inside the macro you are not using quit for proc sql.Is that quit; is not mandatory when we are writing sql inside macro
thank you
proc sql should have quit. But if you do not mention quit in SAS studio, in background quit is added. What I have done is not recommended, but it works in SAS Studio.
MACRO PARAMETERS IN SAS CLICK HERE:sasall4you.blogspot.com/2024/11/29macro-parameters.html