intnx function

[Lopes]

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

[Reeza]

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:

B

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:

M

END

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

Alias:

E

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.

[Lopes]

Thank you very much!

Is working now. Thanks!

[Peter_C]

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