topic Re: Multiple Output in SAS Programming

Multiple Output

vincentgoh88 — Thu, 18 Jul 2019 21:12:26 GMT

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

Re: Multiple Output

PeterClemmensen — Thu, 18 Jul 2019 21:13:35 GMT

The Data Step sounds like the ideal tool for this job so why do you want to do it another way?

Re: Multiple Output

vincentgoh88 — Thu, 18 Jul 2019 21:14:47 GMT

I wish to learn other way if there is any.

Re: Multiple Output

Reeza — Thu, 18 Jul 2019 21:27:28 GMT

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