topic Re: Date Prompts in SAS and Macro variables in SAS Enterprise Guide

Date Prompts in SAS and Macro variables

madara155 — Mon, 04 Jul 2022 01:04:32 GMT

I am trying to get a user input (month and year from user) via "date prompt". This input get assigned to a macro variable called SELECTEDMONTH (this is how it is displayed in the log: %LET SelectedMonth = 01Aug2022;).

Then I am trying to create few other global macro variable based on this SelectedMonth as follows:

%global ColumnHead dummystartValue1;
%global month_ dummystartValue2;
%global year_ dummystartValue3;

data test;
/*extract the three letters corresponding to Month*/
month_ = substr("&SelectedMonth",3,3);
/*extract the last two digits corresponding to year*/
year_ = substr("&SelectedMonth",8,2);
/*Create a new variable holding the month and year*/
ColumnHead = catx("-",month_,year_);
output;
run;

Following is the output I see:

Although I can see the above outputs, when I print all the macro variables at the end Month_, Year_, ColumnHead macros have no values displayed in the log (but SelectedMonth has the original value).

Having defined them as GLOBAL, I thought their values will get updated and retain those values. But it seems I am missing something.

Can someone please explain me what is going on here?

Thanks

Re: Date Prompts in SAS and Macro variables

Tom — Mon, 04 Jul 2022 01:59:16 GMT

Where is the code that you used to assign values to the macro variables?

All I see is the code to generate the dataset named TEST.

Re: Date Prompts in SAS and Macro variables

Tom — Mon, 04 Jul 2022 02:24:03 GMT

If you only need the macro variables then just use macro code to convert the string that is in the SelectedMonth macro variable into the strings you want in the Month_, Year_, ColumnHead macro variables.

%let month_=%substr(&selectedmonth,3,3);
%let year_=%substr(&selectedmonth,8,2);
%let columnhead=&month_.-&year_. ;

If you aren't running the code inside macro there is no need to force MONTH_ and the othe rmacro variables into the GLOBAL symbol table. Any macro variable created in open code is by definition going to be in the GLOBAL macro table as it will be the only one that is active if no macro are currently executing.

Re: Date Prompts in SAS and Macro variables

madara155 — Mon, 04 Jul 2022 07:23:38 GMT

Thanks Tom.

Re: Date Prompts in SAS and Macro variables

PaigeMiller — Mon, 04 Jul 2022 12:18:40 GMT

%global ColumnHead dummystartValue1;
%global month_ dummystartValue2;
%global year_ dummystartValue3;

Is incorrect syntax if you are trying to assign values to macro variables. %GLOBAL does not assign values. Instead, I think you want this:

%LET SelectedMonth = 01Aug2022;
data _null_;
    sasdate=input("&selectedmonth"d,date9.);
    month_ = month(sasdate);
    year_=year(sasdate);
    ColumnHead = catx("-",month_,year_);
    /* Create macro variables and assign values using CALL SYMPUTX */
   call symputx('dummystartvalue1',columnhead);
run;

Now that I have given you some code, let me also add that this is normally a very bad idea to include calendar information in variable names. You will work very hard to do things that are much simpler to do .Is the reason you want a calendar value in a variable name because you want to produce a report where one of the columns is headed by "Aug-22"? If so, forget all this macro use and instead use PROC REPORT, it is much simpler, no macros or macro variables needed, macros and macro variables causing lots of problem for beginners (as you have seen).