topic Re: Use macro "Calculation" in datastep? in SAS Programming

Use macro "Calculation" in datastep?

ybz12003 — Tue, 12 Jan 2021 19:14:51 GMT

Hello,

I have a 'Calculation' Macro over 200 lines.

%macro calculated;
if c_ageyears=. and agemonths=. and ageyears ne . then do;
 c_ageyears=floor(ageyears);
 c_ageyears_fix=1;
end;
.
.
.
%mend calculated;

And I would like to use this calculating macro to the data step.

data update_test2016;
set test2106;
if c_ageyears=. and agemonths=. and ageyears ne . then do;
 c_ageyears=floor(ageyears);
 c_ageyears_fix=1;
end;
.
.
.
run;

So when every time I run a new year, for example from 2017 to 2019, I have to copy 200 lines from the first macro into the data steps to do the calculation. Is there a way so that I could just use one or two command lines to run the macro repeatedly, such as %includes or something else? Thanks.

Re: Use macro "Calculation" in datastep?

PaigeMiller — Tue, 12 Jan 2021 19:17:21 GMT

%include isn't needed.

This should work

data update_test2016;
set test2106;
%calculated
.
.
run;

Re: Use macro "Calculation" in datastep?

ybz12003 — Tue, 12 Jan 2021 19:23:26 GMT

But how to direct the SAS run this macro file with specific file location?

\\pathway\Programs\macro_calculation.sas

Re: Use macro "Calculation" in datastep?

Shmuel — Tue, 12 Jan 2021 19:54:08 GMT

It seems that the macro is written to make the calculation for any file that has all variables mentioned in it.

The part of the macro that you posted does not relate to a specific file.

To be able to use the macro in a data step you can either:

%include "\\pathway\Programs\macro_calculation.sas";

data update_test2016;
   set test2106;
...
   %calculated;
...
run;

filename macros "\\pathway\Programs";
options sasautos=(macros, sasautos);

data update_test2016;
set test2106;
...
%calculated;
...
run;

Re: Use macro "Calculation" in datastep?

PaigeMiller — Tue, 12 Jan 2021 19:55:27 GMT

Given that this macro has variables specific to this task, I would just put it in your program above the data step.

Re: Use macro "Calculation" in datastep?

Reeza — Tue, 12 Jan 2021 20:20:38 GMT

You generally put things in a macro if they'll be re-used or need to be generalized somehow. I fail to see how this is generalized, so I'm assuming this is being done because you plan to repeat it a few times in different places?