topic Re: Why the y value is 02JAN12 in the intnx function? in SAS Data Science

Why the y value is 02JAN12 in the intnx function?

devarayalu — Tue, 10 Jul 2012 08:24:47 GMT

78 data _null_;

79 x=intck('weekday17w', '01jan12'd, '31dec12'd);

80 y=intnx('weekday17w', '01jan12'd, 1);

81 put x= +1 y date.;

82 run;

x=261 02JAN12

NOTE: DATA statement used (Total process time):

real time 0.12 seconds

cpu time 0.00 seconds

shivas — Tue, 10 Jul 2012 09:19:12 GMT

Hi,

What is the output you are expecting...

data _null_;

x=intck('weekday17w', '01jan12'd, '31dec12'd);

y=intnx('weekday17w', '01jan12'd, 1);

put x= +1 y weekdate17.;

run;

Thanks,

Shiva

devarayalu — Tue, 10 Jul 2012 09:25:49 GMT

Thanks for reply,

Generally weekday17w interval should give the 5 day week with saturday and sunday as the weekends.

So the next interval should be next week in intnx function and total number of 5 day weeks in the year in intck function

But this is not happening in my point of view

shivas — Tue, 10 Jul 2012 10:02:02 GMT

Hi,

01Jan2012 is sunday.next day of weekday is monday which 02Jan2012,Your code is working correct right.

06Jan2012 is friday and its giving 09Jan2012 as weekday starts.

data _null_;

x=intck('weekday17w', '01jan12'd, '31dec12'd);

y=intnx('weekday17w', '01jan12'd, 1);

z=intnx('weekday17w', '06jan12'd, 1);

format y z date9.;

put (_all_) (=);

run;

x=261 y=02JAN2012 z=09JAN2012

Thanks,

Shiva