ACT/ACT function

[lisahoward]

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.

[RW9]

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 · Accepted solution]

@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]

Thank you All.