I am apparently not seeing something simple in this code. The below code returns a testdate of 1/1/60, but the log somehow is recognizing the macro variable correctly as 9/30/24. How do i get that macro variable date into my dataset? I think i've done this a million times but today it doesn't seem to be working for me.
%let lastday = %sysfunc(intnx(month,%sysfunc(today()),-1,e),mmddyy10.);
data test; set have; testdate = &lastday; format testdate mmddyy10.; run;
log:
28 %let lastday = %sysfunc(intnx(month,%sysfunc(today()),-1,e),mmddyy10.); 29 30 data test; 31 set have; 32 testdate = &lastday; SYMBOLGEN: Macro variable LASTDAY resolves to 09/30/2024 33 format testdate mmddyy10.; 34 run;
... View more