topic Re: Macros in SAS Programming

Macros

sophia_SAS — Wed, 11 Jun 2014 17:27:06 GMT

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);

Re: Macros

Haikuo — Wed, 11 Jun 2014 18:18:12 GMT

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

Re: Macros

sophia_SAS — Wed, 11 Jun 2014 18:22:19 GMT

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;

Re: Macros

CTorres — Wed, 11 Jun 2014 18:35:01 GMT

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,

Re: Macros

avr — Fri, 13 Jun 2014 05:43:56 GMT

mr.hai.ko is given the correct stmt in macros