Dear SAS Users,
I have a macro program that follows the basic anatomy of a macro. See sample below, The problem with this one is I can only read in one observation at a time. What is a call routine I can use to automatically bring in a dataset with 10 observations per Var1-Var3
%macro test (var1, var2, var3) ;
data sample;
var1_new=&var1+&var2;
var2_new=&var2+&var3;
run;
%mend test;
%test (1,2,3);
.
Not sure if I understand what you want, but adding a data step loop x10 will give your 10 obs:
%macro test (var1, var2, var3);
data sample;
do _n_=1 to 10;
var1_new=&var1+&var2;
var2_new=&var2+&var3;
outupt;
end;
run;
%mend test;
%test (1,2,3)
Haikuo
I should have noted that there are different values for Var1-Var3 and the larger dataset has more than 10 obs.
Data have;
var1 var2 var3
1 2 3
4 5 6
2 8 2
4 6 3
2 3 5
and so on;
run;
I think you do not need a macro and what you need is the following program:
Data have;
input var1 var2 var3;
cards;
1 2 3
4 5 6
2 8 2
4 6 3
2 3 5
;
run;
data want;
set have;
var1_new=var1+var2;
var2_new=var2+var3;
run;
Regards,
mr.hai.ko is given the correct stmt in macros
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 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.