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.
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".
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".
Thank you so much.
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?
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 the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.