Creating datasets from each variable in a SAS dataset

In real world, no one will create something like this. This video is all about understanding a problem and solving step by step. This video also discuss how to avoid hard coding and issues with hard coding. SAS Macro Programming is all about generating text and can make things supremely automated and can make many things super easy and can help avoid hard coding.
Code in this video is available at github.com/kir....
creating macro variables in SQL.
• SAS Macro Series Part ...
Explanation of double ampersand logic (in below link between 3:34 to 6:32 minutes)
• Designing a advanced S...

[@rogerward8047]

I love this one! I've tended to avoid using into with proc SQL, but I'll give it a whirl now. Thanks a million!

[@7979sunny]

Hi Sir..Thanks for posting videos.
I am learning macros and I have a doubt regarding %global statement. Could you plz clarify.
%macro win;
%global name country;
%let name=Sunny;
%let country=India;
%MEND Win;
But I am unable to resolve the macro variables.
Pls help me on this and Thanks in Advance!

[@kiranvenna]

to resolve macro variable you need to use %put &name &country; %global makes macro variables accessible to the whole sas session other wise they are avaiable only for that particular macro. Please checkout my video on scope of SAS macro variables to understand more about %global. ua-cam.com/video/qVfu_hvhXaA/v-deo.html&pp=ygUPc2FzIG1hY3JvIHNjb3Bl