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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.