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

I would like to change the following to statement to check for months rather than days:

datdif(index_date,treated_date,'act/act')

What would I need to change so that  datdiff can back in months between the diagnosis and Index date rather than days.

Many thanks.

1 ACCEPTED SOLUTION

Accepted Solutions
RichardinOz
Quartz | Level 8

@RW9

Not sure why "you would need to check if yearpart different from yearpart other date first".  INTCK() handles full SAS dates.

@lisahoward

INTCK('MONTH', index_date,treated_date, 'SAME')

The SAME alignment counts each month from the same day as the day of the start month

Richard

View solution in original post

3 REPLIES 3
RW9
Diamond | Level 26 RW9
Diamond | Level 26

Hi,

Have a look at the INTCK function as this does all the different intervals - QTR, YEAR, MONTHS etc.

Just to note, you would need to check if yearpart different from yearpart other date first.

RichardinOz
Quartz | Level 8

@RW9

Not sure why "you would need to check if yearpart different from yearpart other date first".  INTCK() handles full SAS dates.

@lisahoward

INTCK('MONTH', index_date,treated_date, 'SAME')

The SAME alignment counts each month from the same day as the day of the start month

Richard

lisahoward
Calcite | Level 5

Thank you All.

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
  • 3 replies
  • 1675 views
  • 0 likes
  • 3 in conversation