Desktop productivity for business analysts and programmers

intnx function

Reply
Contributor
Posts: 30

intnx function

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

Super User
Posts: 19,145

Re: intnx function

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.
Contributor
Posts: 30

Re: intnx function

Thank you very much!

Is working now. Thanks!

Valued Guide
Posts: 2,177

Re: intnx function

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

Ask a Question
Discussion stats
  • 3 replies
  • 377 views
  • 0 likes
  • 3 in conversation