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
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.