topic Re: Macro variable is assigned a value only after second run in SAS Programming

Macro variable is assigned a value only after second run

Hedegaard — Thu, 05 Jul 2012 14:31:33 GMT

Hello,

I have the following piece of code, where I want the macro variable &ultimo to have a date value at the end. However, after running the code once, the value of &ulitmo is still missing, but after a second run, the value appears. My question is, what am I doing wrong with respect to making the code work doing its first run? Kind regards.

%let year = 2012;
%let month = 06;

%macro ultimodato;
     %if %eval(&month) < 9 %then %do;
           %let ultimo = 01/0%eval(&month.+1)/&year.;
     %end;
     %else %if &month = 9 %then %do;
           %let ultimo = 01/10/&year.;
     %end;
     %else %if 9 < &month and &month < 12 %then %do;
           %let ultimo = 01/%eval(&month.+1)/&year.;
     %end;
     %else %if &month = 12 %then %do;
           %let ultimo = 01/01/%eval(&year+1);
     %end;
%mend ultimodato;

%ultimodato;

data _null_;
call symput('ultimo',put(input("&ultimo",DDMMYY10.),date9.));
run;

%put &ultimo;

Re: Macro variable is assigned a value only after second run

Florent — Thu, 05 Jul 2012 14:36:37 GMT

Hi,

This is because your 'ultimo' macro-variable isn't declared as global, and it is created within the macro 'ultimodato'. By declaring it as global (%global ultimo;), you will make it available to your call symput.

Kind regards,

Florent

Re: Macro variable is assigned a value only after second run

Hedegaard — Thu, 05 Jul 2012 14:43:30 GMT

Thank you. It works.

Re: Macro variable is assigned a value only after second run

Astounding — Thu, 05 Jul 2012 14:50:16 GMT

That's the right answer to your original question. But you should also consider whether or not you want to write a macro for this purpose. The DATA step already has functions that will do the work for you. For example:

data _null_;

call symput('ultimo', put( intnx('month', mdy(&month, 1, &year), +1), date9.));

run;

Good luck.

Re: Macro variable is assigned a value only after second run

Hedegaard — Fri, 06 Jul 2012 07:34:29 GMT

Astounding, I didn't know you could do that! Thanks.