https://communities.sas.com/t5/SAS-Programming/intnx-to-decrement-quarter-year/m-p/18871#M2883 Thankyou.<BR /> <BR /> Actually i need a function which is capable of reducing the qtr and year back say by a factor of n. Tue, 19 Oct 2010 12:14:47 GMT tommy81 2010-10-19T12:14:47Z https://communities.sas.com/t5/SAS-Programming/intnx-to-decrement-quarter-year/m-p/18869#M2881 Hi,<BR /> <BR /> Does anyone know any function like intnx to increment or decrement quarteryear<BR /> <BR /> if sysdate is 19oct2010 -- quarter year would be Q4 2010<BR /> <BR /> I need <BR /> <BR /> Q4 2010<BR /> Q3 2010<BR /> Q2 2010<BR /> Q1 2010<BR /> Q4 2009<BR /> <BR /> Thankx Tue, 19 Oct 2010 10:06:34 GMT https://communities.sas.com/t5/SAS-Programming/intnx-to-decrement-quarter-year/m-p/18869#M2881 tommy81 2010-10-19T10:06:34Z https://communities.sas.com/t5/SAS-Programming/intnx-to-decrement-quarter-year/m-p/18870#M2882 I think you just need to FORMAT the date.<BR /> <BR /> [pre]<BR /> proc format;<BR /> picture QYYYY(default=9) other='Q%q %Y' (datatype=date);<BR /> run;<BR /> <BR /> data _null_;<BR /> d = '19oct2010'd;<BR /> put d=yyq. d=Qyyyy.;<BR /> run;<BR /> [/pre] Tue, 19 Oct 2010 11:44:23 GMT https://communities.sas.com/t5/SAS-Programming/intnx-to-decrement-quarter-year/m-p/18870#M2882 data_null__ 2010-10-19T11:44:23Z https://communities.sas.com/t5/SAS-Programming/intnx-to-decrement-quarter-year/m-p/18871#M2883 Thankyou.<BR /> <BR /> Actually i need a function which is capable of reducing the qtr and year back say by a factor of n. Tue, 19 Oct 2010 12:14:47 GMT https://communities.sas.com/t5/SAS-Programming/intnx-to-decrement-quarter-year/m-p/18871#M2883 tommy81 2010-10-19T12:14:47Z https://communities.sas.com/t5/SAS-Programming/intnx-to-decrement-quarter-year/m-p/18872#M2884 The OP original post asked for a way to display a date as a quarter-year.<BR /> <BR /> Otherwise, consider the INTNX function and QTR (argument #1). Check the SAS Language Dictionary DOC discussion on INTNX for details.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc. Tue, 19 Oct 2010 12:57:37 GMT https://communities.sas.com/t5/SAS-Programming/intnx-to-decrement-quarter-year/m-p/18872#M2884 sbb 2010-10-19T12:57:37Z https://communities.sas.com/t5/SAS-Programming/intnx-to-decrement-quarter-year/m-p/18873#M2885 INTNX?<BR /> <BR /> [pre]<BR /> 870 data _null_;<BR /> 871 d = '19oct2010'd;<BR /> 872 do o = -4 to 4;<BR /> 873 q = intnx('QTR',d,o);<BR /> 874 put q=date9. q=yyq.;<BR /> 875 end;<BR /> 876 run;<BR /> <BR /> q=01OCT2009 q=2009Q4<BR /> q=01JAN2010 q=2010Q1<BR /> q=01APR2010 q=2010Q2<BR /> q=01JUL2010 q=2010Q3<BR /> q=01OCT2010 q=2010Q4<BR /> q=01JAN2011 q=2011Q1<BR /> q=01APR2011 q=2011Q2<BR /> q=01JUL2011 q=2011Q3<BR /> q=01OCT2011 q=2011Q4<BR /> [/pre] Tue, 19 Oct 2010 13:13:50 GMT https://communities.sas.com/t5/SAS-Programming/intnx-to-decrement-quarter-year/m-p/18873#M2885 data_null__ 2010-10-19T13:13:50Z