topic Re: SAS create a paremeter from a user define parameter in SAS Programming

SAS create a paremeter from a user define parameter

Ronein — Tue, 12 Jun 2018 05:16:48 GMT

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

Re: SAS create a paremeter from a user define parameter

FredrikE — Tue, 12 Jun 2018 06:12:16 GMT

%let mon = 1804;

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

🙂

//Fredrik

Re: SAS create a paremeter from a user define parameter

RW9 — Tue, 12 Jun 2018 08:00:06 GMT

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.