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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.