topic Re: intnx in SAS Programming

intnx

Sathiskumar_D — Tue, 02 May 2017 14:08:13 GMT

The question is from the Prep Guide.

targetyear=intnx('Year','05feb94'd,3)

I was anticipating the answer 05feb97.However, the value is 13515 i.e., January1,1997. Why is that so?

However, the same functin used on semiyear yield the value as expected.

Eg.

targetMonth=intnx('semiyear','01jan2001'd,1) and the answer is 01July2001.

art297 — Tue, 02 May 2017 14:15:50 GMT

If you don't include the allignment option, beginning is the default. That is what you got for year (jan 1) and semi-year (july 1)

Art, CEO, AnalystFinder.com

Tom — Tue, 02 May 2017 14:16:05 GMT

It just did what you asked it to do. If you want it to find the same point in the interval you need to tell it that.

targetyear=intnx('Year','05feb94'd,3,'same')

Reeza — Tue, 02 May 2017 14:21:04 GMT

INTNX() has 4 parameters, you've specified 3.

The fourth parameter tells it how to align the dates: beginning, same, end, middle.

The default is the beginning, which is being used.

Sathiskumar_D — Tue, 02 May 2017 16:37:12 GMT

thanks.