topic Re: Intnx using Interval (month6) in SAS Programming

Intnx using Interval (month6)

sfffdg — Thu, 02 Jun 2022 23:29:16 GMT

Hi ,

Just wondering if there is a way to achieve below using month6 interval.Basically trying other ways ..

data _null_;
date1=intnx('month','05may2022'd,6);
date2=intnx('month','05may2022'd,0);
days=date1-date2;
format date1 date2 date9.;
put date1 date2 days;
run;

Thanks,

Swathi

Re: Intnx using Interval (month6)

Quentin — Fri, 03 Jun 2022 01:22:34 GMT

Not quite sure what you want, but you may be interested in exploring the optional alignment argument. e.g.:

61   data _null_;
62   date1=intnx('month6','05may2022'd,1,'s');
63   date2=intnx('month6','05may2022'd,0,'s');
64   days=date1-date2;
65   format date1 date2 date9.;
66   put date1 date2 days;
67   run;

05NOV2022 05MAY2022 184