Can you please help me the below requirement.
I need to store date values as below.
data t1;
validfrom=<firstdayoflastmonth> e.g 01APR2023;
ValidTill=<lastdayoflastmonth> e.g 30APR2023;
run;
already, I have another dataset , where above two variables (validfrom and validtill) have dates.
I need to concatenate both of them.
I used something, but this is storing as character, and unable to concatenate.
%let firstdayofthelastmonth = %sysfunc(intnx(month,%sysfunc(today()),-1),date9.); %let lastdayofthelastmonth = %sysfunc(intnx(month,%sysfunc(today()),-1,e),date9.); %put &firstdayofthelastmonth.; %put &lastdayofthelastmonth.;
Kindly suggest.
... View more