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
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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.