topic intnx function in SAS Enterprise Guide

intnx function

Lopes — Tue, 30 Sep 2014 21:33:50 GMT

Hi!

I need to get the last day of the month using the basedate.

I tried with the intnx('month',basedate,i, 'same'). If the basedate=30Apr2014 then the next month is 30May2014, but I need it to be 31May2014.

I appreciate if you can help me with it.

Thanks and kind regards,

Paula

Re: intnx function

Reeza — Tue, 30 Sep 2014 21:35:47 GMT

RTM

for the aligment use END rather than SAME:

SAS(R) 9.2 Language Reference: Dictionary, Fourth Edition

'alignment'

controls the position of SAS dates within the interval. You must enclose alignment in quotation marks. Alignment can be one of these values:

BEGINNING

specifies that the returned date or datetime value is aligned to the beginning of the interval.

Alias:

MIDDLE

specifies that the returned date or datetime value is aligned to the midpoint of the interval, which is the average of the beginning and ending alignment values.

Alias:

END

specifies that the returned date or datetime value is aligned to the end of the interval.

Alias:

SAME

specifies that the date that is returned has the same alignment as the input date.

Alias:	S
Alias:	SAMEDAY
See:	SAME Alignment for more information.

Re: intnx function

Peter_C — Tue, 30 Sep 2014 21:39:05 GMT

%let nextmonthend =%sysfunc( intnx( month, "&sysdate9"d, 1, e), date9 ) ;

Re: intnx function

Lopes — Tue, 30 Sep 2014 21:43:26 GMT

Thank you very much!

Is working now. Thanks!