topic Re: INTNX Function Not Working in SAS Programming

INTNX Function Not Working

bhong — Wed, 15 Aug 2018 18:01:27 GMT

Hi,

For some reason, my INTNX function is not working and is returning a missing value. I just want to move forward one month. Here's some code:

DATA test;
	SET membership1;
	IF _N_ in (16) THEN OUTPUT;
	format DT_CHECK mmddyy10.;
	DT_CHECK = intnx("month", EVENT_DT, 1);
RUN;

EVENT_DT is a SAS date (e.g., 01/25/2013) and is formatted as mmddyy10. My dataset has over 12,000 observations, so I wanted to just read in the 16th observation as a test. Can anyone help me fix my code? Thanks!

Re: INTNX Function Not Working

Astounding — Wed, 15 Aug 2018 18:02:44 GMT

The DATA step statements execute in order, from top to bottom.

You are outputting before computing DT_CHECK.

Move the OUTPUT statement to the bottom of the DATA step.

Re: INTNX Function Not Working

bhong — Wed, 15 Aug 2018 18:08:55 GMT

Thank you! What a horrible mistake!

Re: INTNX Function Not Working

Astounding — Wed, 15 Aug 2018 18:10:10 GMT

Easily fixed, with a cup of coffee.

Re: INTNX Function Not Working

Haikuo — Wed, 15 Aug 2018 18:39:08 GMT

Following @Astounding's suggestion, you will get what you need. However, theoretically speaking, you don't just READ-IN the 16th record, you OUTPUT the 16th record while reading in every single record in your incoming dataset.

To actually only READ-IN the 16th, you need either resort to point= option, or bring in the data only with the 16th record, such as:

DATA test;
SET membership1(firstobs=16 obs=16);

blah...

I know 12,000 probably only takes blink of eye to run, but if you are doing multi-M or B rows of data, this little test will still cost you some time :).