topic Re: sas function in SAS Programming

sas function

jdk123 — Thu, 24 Mar 2011 14:34:37 GMT

the current_date='01feb2011'd;

how to identify the last month of the last quarter of the current data '01feb2011'd?

thanks,

Re: sas function

SPR — Thu, 24 Mar 2011 14:45:44 GMT

Hello Jdk123,

month=MONTH(current_date);
qtr=INT(month/4)+1;

Is this what are you looking for?

Sincerely,
SPR

Re: sas function

Olivier — Thu, 24 Mar 2011 14:47:16 GMT

Hi.
If I do understand your need, you have to try the INTNX function (to shift 1 quarter back in the past) with the optional "END" fourth argument to move to the end of the period, that is the last day of the preceding quarter.
[pre]last_quarter_month = INTNX("QUARTER", current_date, -1, "END") ;[/pre]
This gives 31dec2010 for CURRENT_DATE to 01feb2011. If you only want the month, include the whole INTNX function into a MONTH function ; that will produce 12 as a result.
Hope it helps.
Olivier

Re: sas function

jdk123 — Thu, 24 Mar 2011 14:52:15 GMT

Thanks Oliver, you have been great help.