How to add quarters in SAS?

sasstats — Wed, 09 May 2018 13:13:16 GMT

Hello all together,

I am working with time quarters and I do need to add or substract quarters from an indexquarter.

Is there any way to do this in SAS?

My data contains an ID and an index date. With this index date I can define the year and the quarter of that index date.

Using the function yyq I can define the quarter of the index year as sas date value.

Now I would like to add two quarters to the index quarter. (E.g. two quarters of follow-up of a patient)

My Programm Looks like:

data two;

set one;

year_index=year(indexdate);

quarter_index_help=qtr(indexdate);

quarter_index=yyq(year_index,quarter_index_help); /* SAS date value with quarter and year */

future_index=quarter_index+2; /* That's what I want to do, add two quarters */

run;

Thanks for help

sasstats

Re: How to add quarters in SAS?

Vish33 — Wed, 09 May 2018 13:37:07 GMT

try:
future_index=put(intnx('qtr',quarter_index,2),2.);

sasstats — Wed, 09 May 2018 13:54:40 GMT

Hello,

thanks a lot!

In my datastep your syntax worked in the following way:

future_index=intnx('qtr',quarter_index,2);

format future_index yyq.;

But then it did what I wanted.

sasstats