Hello
Let's say that a user define a parameter
%let mon=1804;
(meaning April 2018)
I want that SAS will create automatically a new parameter called tar that get value '30APR2017'd (end of month after deduct 12 months from mon parameter)
How can I do it?
Thanks
Ronein
%let mon = 1804;
data out;
format tar yymmdd10.;
tar = intnx('month',input("&mon",yymmn4.),-12,'end');
run;
🙂
//Fredrik
%let mon = 1804;
data out;
format tar yymmdd10.;
tar = intnx('month',input("&mon",yymmn4.),-12,'end');
run;
🙂
//Fredrik
The question is why you need two macro variables for this. You have stated you have one macro variable with a timepoint, and you know the logic to get end of month date from that, so why store that second one in a macro variable, just apply the logic where you need it.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.