topic Re: How to examine a date between two variables that are dates in SAS Programming

How to examine a date between two variables that are dates

chancc — Tue, 15 Nov 2016 06:11:35 GMT

Hi,

I am trying to analyze data involving if there was a hospitalization (Y/N) in the first 6 months from a transplant date. TRR transplant date is the date of transplant, SAS180 is 180 days after date of transplant, and then TRF status date is the date of follow up.

I want to tell SAS to look at Y/N for hospitalization if the TRF status date is between the time interval "date of transplant" and "SAS180". And remove any record if TRF status date is beyond the SAS180 date. Does anyone know what I can do to achieve this?

Thanks!

Re: How to examine a date between two variables that are dates

Reeza — Tue, 15 Nov 2016 07:05:42 GMT

Can you assume you'll always have dates or do you need to account for missing data?

Anyways, you can compound your conditions using an AND

Length check $3.;

if status>=transplant AND STATUS<=sas180 then check='ok';

else check='bad';

Then you can filter on your check variable. I create this variable so I can confirm my code before removing records - makes it easier to debug.

Re: How to examine a date between two variables that are dates

chancc — Tue, 15 Nov 2016 14:48:02 GMT

Thanks I will give this a try!

Ideally, I would want to capture if TRR Status Date was even within the same month and year of SAS 180 (if exceeds the interval by a few days, no big deal). But I feel that is too complicated in SAS? I was going to manually read it over.

Re: How to examine a date between two variables that are dates

chancc — Tue, 15 Nov 2016 22:26:03 GMT

What you suggested worked!

Do you know if there is a way I can expand this a bit more so it is not just the 6 month SAS 180 exact date but includes the entire month of SAS180 date?

So if the follow up date was 5/10/16 and the SAS 180 date was 5/05/16, I still want that to be included...

Re: How to examine a date between two variables that are dates

Reeza — Tue, 15 Nov 2016 22:28:31 GMT

Use INTNX to set the date to the end of the month. You can do this within your comparison rather than create a new variable.

Re: How to examine a date between two variables that are dates

Reeza — Wed, 23 Nov 2016 05:17:58 GMT

Set it to the end of the month instead of beginning