- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
The Data Step sounds like the ideal tool for this job so why do you want to do it another way?
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
I wish to learn other way if there is any.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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