Hi,
How to create a looping for code below if I wish to loop 10 times and output 10 times?Besides using data step, is there any other simple method using proc?
data S1 S2 ... S10;
set set0;
if book = 'A1' then output A1;
else if book 'A2' then output A2;
...
else if book 'A10' then output A10;
run;
Thanks
The Data Step sounds like the ideal tool for this job so why do you want to do it another way?
I wish to learn other way if there is any.
Here are examples of other ways.
I will point out the general advice though: 99% of the time this is a bad idea.
https://blogs.sas.com/content/sasdummy/2015/01/26/how-to-split-one-data-set-into-many/
http://www.sascommunity.org/wiki/Split_Data_into_Subsets
Read to the bottom of the second link to find other options including call execute, macros and such.
@vincentgoh88 wrote:
Hi,
How to create a looping for code below if I wish to loop 10 times and output 10 times?Besides using data step, is there any other simple method using proc?
data S1 S2 ... S10;
set set0;
if book = 'A1' then output A1;
else if book 'A2' then output A2;
...
else if book 'A10' then output A10;
run;
Thanks
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.