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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.