topic Re: use of INTNX in SAS Programming

use of INTNX

s_m — Sun, 09 Apr 2017 18:23:45 GMT

data wt;
datenew=intnx('qtr','01jan94'd,1,'middle');
format datenew mmddyy10.;
run;

its output is coming as 05/16/1994 but qarter consists of 3 months so it should be 04/16/1994.

Please help me with this.

Re: use of INTNX

Kurt_Bremser — Sun, 09 Apr 2017 18:40:43 GMT

@s_m wrote:

data wt;
datenew=intnx('qtr','01jan94'd,1,'middle');
format datenew mmddyy10.;
run;

its output is coming as 05/16/1994 but qarter consists of 3 months so it should be 04/16/1994.

Please help me with this.

Why? The middle of the second quarter (months 4, 5 and 6) is the middle of month 5.

Re: use of INTNX

Reeza — Sun, 09 Apr 2017 19:08:50 GMT

If you want 3 months from the date use MONTH and 3 instead of QTR. Also note that April has 30 days so it would be the 15th NOT the 16th. See the code and output below.

60 data wt;

61 date1=intnx('qtr','01jan94'd,1,'m');

62 date2=intnx('MONTH','01jan94'd,3,'m');

63 format date: mmddyy10.;

65 put "QTR = " date1;

66 put "Month = " date2;

67 run;

QTR = 05/16/1994

Month = 04/15/1994

NOTE: The data set WORK.WT has 1 observations and 2 variables.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.01 seconds

Re: use of INTNX

Tom — Mon, 10 Apr 2017 01:17:31 GMT

You need to tell it that is what you want.

data test1;
  date = '01JAN1994'd ;
  next_qtr = intnx('qtr','01jan94'd,1,'middle');
  first_month_of_next_qtr = intnx('month',intnx('qtr','01jan94'd,1,'s'),0,'middle');
  format _all_ yymmdd10.;
  put (_all_) (=/);
run;

date=1994-01-01
next_qtr=1994-05-16
first_month_of_next_qtr=1994-04-15