topic sas DI studio macro date in SAS Data Management

sas DI studio macro date

sabooalex — Fri, 07 Feb 2014 00:57:47 GMT

Hi ,

I have a requirement in SAS DI where I need to create dates like

2 months before the current date

3 months before the current date

4 months before the current date

Can some one provide me the way to derive these dates based on the system date.

Thanks,Ashish

SASKiwi — Fri, 07 Feb 2014 01:57:06 GMT

How about something like this:

%let month_back2 = %sysfunc(intnx(MONTH, "&sysdate9."d, - 2, SAME), date9.);

%let month_back3 = %sysfunc(intnx(MONTH, "&sysdate9."d, - 3, SAME), date9.);

%let month_back4 = %sysfunc(intnx(MONTH, "&sysdate9."d, - 4, SAME), date9.);

%put month_back2 = &month_back2;

%put month_back3 = &month_back3;

%put month_back4 = &month_back4;

sabooalex — Fri, 07 Feb 2014 08:45:42 GMT

Hi,

Thanks for getting back to me,much appreciated!

So I will copy this in the precode of the job, and it should work.

One last thing on this question,can the same not be done by using the parameters tab of the job or one has to write this code manually?

Thanks,Ashish

LinusH — Fri, 07 Feb 2014 10:28:22 GMT

in my mind, parameters are usfell when connection to job using a data set as a control table, and the loop transform.

You could use parameters, but I can't see the benefit in your case.