topic Re: Finding a Date within a range in SAS Programming

Finding a Date within a range

einstein — Thu, 15 Sep 2016 19:25:18 GMT

I'm trying to figure out a way of determing if a particular date is within a date range. For example in the dataset below. I want to see if Person ID 1 was covered on Oct 1, 2014. Is there an easy way to figure this out?

Person ID Date Begin Date End Program

1 01/01/2014 09/30/2014 AD

1 11/01/2014 12/31/2014 BB

Re: Finding a Date within a range

Reeza — Thu, 15 Sep 2016 19:34:05 GMT

Sure. How do you want to deal with multiple records per ID? Also, is it possible to have missing values? If so, the logic would need to be adjusted.

if date_start <= "01Oct2014"d <= date_end then coverage=1;
else coverage=0;

Re: Finding a Date within a range

einstein — Thu, 15 Sep 2016 19:49:09 GMT

Thank you! This worked out perfectly!