BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
sasstats
Fluorite | Level 6

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

1 ACCEPTED SOLUTION

Accepted Solutions
Vish33
Lapis Lazuli | Level 10
try:
future_index=put(intnx('qtr',quarter_index,2),2.);

View solution in original post

2 REPLIES 2
Vish33
Lapis Lazuli | Level 10
try:
future_index=put(intnx('qtr',quarter_index,2),2.);
sasstats
Fluorite | Level 6

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

 

sas-innovate-2024.png

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.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 2829 views
  • 1 like
  • 2 in conversation