topic Re: ACT/ACT function in SAS Programming

ACT/ACT function

lisahoward — Fri, 16 May 2014 07:38:15 GMT

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 — Fri, 16 May 2014 08:55:03 GMT

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 — Fri, 16 May 2014 09:59:49 GMT

@RW9

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

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 — Fri, 16 May 2014 11:17:52 GMT

Thank you All.