SAS create a paremeter from a user define parameter

[Ronein]

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

[FredrikE · Accepted solution]

%let mon = 1804;

data out;
 format tar yymmdd10.;
 tar = intnx('month',input("&mon",yymmn4.),-12,'end');
run;

🙂

//Fredrik

[RW9]

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.