topic Re: Updating Macro Variable with Macro? in SAS Programming

Updating Macro Variable with Macro?

laura6728 — Tue, 21 Mar 2017 21:37:57 GMT

I have several programs that I run for several different years to generation reports. Currently, I have to manually change the %let CYEAR each time I run the program, and I run it for 2010 - 2016. Is there a way for it to run 1 time for all the years I want to run?

%let CYEAR = 2010;  /* YEAR OF COHORT */
%let CYEAR2 = %eval(&CYEAR. + 1);
%let TERM = &CYEAR.FA; /* TERM OF COHORT */
%let NTERM = &CYEAR2.SP; /* +1 TERM TO CHECK 1 TERM RETENTION STATUS */
%let NYTERM = &CYEAR2.FA; /* +1 YEAR TO CHECK 1 YEAR RETENTION STATUS */

Re: Updating Macro Variable with Macro?

Kurt_Bremser — Tue, 21 Mar 2017 21:42:27 GMT

Within a macro, you can do

%do cyear = 2010 %to 2016;
/* your code */
%end;

Re: Updating Macro Variable with Macro?

art297 — Tue, 21 Mar 2017 21:45:27 GMT

Don't know without seeing the rest of the code you run, but one possibility would be to wrap everything in a macro. e.g.:

%macro doit (first,last)
  %do cyear=&first %to &last;  /* YEAR OF COHORT */
    %let CYEAR2 = %eval(&CYEAR. + 1);
    %let TERM = &CYEAR.FA; /* TERM OF COHORT */
    %let NTERM = &CYEAR2.SP; /* +1 TERM TO CHECK 1 TERM RETENTION STATUS */
    %let NYTERM = &CYEAR2.FA; /* +1 YEAR TO CHECK 1 YEAR RETENTION STATUS */

%include your_actual_program.sas;
%mend doit;

%doit (2010,2016)

Art, CEO, AnalystFinder.com

Re: Updating Macro Variable with Macro?

Reeza — Tue, 21 Mar 2017 22:14:37 GMT

Or use CALL EXECUTE to loop and call the macro 6 times, there are lots of ways to automate a macro loop.

Re: Updating Macro Variable with Macro?

laura6728 — Wed, 22 Mar 2017 13:24:17 GMT

I am sorry everyone, I posted this in the BASE forum and I am using EG. I am going to move this over to the EG board. Sorry, and thanks for the help!

Re: Updating Macro Variable with Macro?

Kurt_Bremser — Wed, 22 Mar 2017 13:41:38 GMT

@laura6728 wrote:

I am sorry everyone, I posted this in the BASE forum and I am using EG. I am going to move this over to the EG board. Sorry, and thanks for the help!

Not necessary. It's got more to do with Base SAS code than with EG functionality.