topic Re: how do i use 'two different %do to %num Macro procedure ? in SAS Procedures

how do i use 'two different %do to %num Macro procedure ?

COLDORANGE — Tue, 28 Oct 2014 14:15:10 GMT

I want to SET temp&k and 'DATA Complete&i'

%do k = 1 %to 100
%do i = 1 %to 60

data complete&i

set temp&k

K order(1 to 100) have to proceed the end of I(1 to 60) procedure

thank you.

ballardw — Tue, 28 Oct 2014 14:32:45 GMT

To use the %do constructs it will need to be within an actual macro defined using %macro/%mend.

%macro example;

%do k = 1 %to 100;

%do j= 1 %to 60;

data complete&j;

set temp&k;

run;

%end; /* ends the j loop*/

%end; /* ends the k loop*/

%mend;

And then call the defined macro:

%example;

I used k as I am tired of fighting with the editor about lower case "i".

RW9 — Tue, 28 Oct 2014 14:33:05 GMT

Hi,

data complete&i.;

set complet&i. temp&k.;

run;

Or you could use append.

I would ask though, why you have 100 complete tables and 60 temp tables, surely there are better methods to get the end result?

COLDORANGE — Wed, 29 Oct 2014 00:57:49 GMT

Thank you so much.