The overlap seems to be (if I am understanding you properly) when d2start_dt < d1End_dt (although it would be nice if you had stated that directly to eliminate my possible misunderstanding). If that's the case, then the relatively simple test of d1End_dt - d2start_dt >=28 results in a flag.   if d1End_dt - d2start_dt >= 28 then flag=1; else flag=0; This assumes that all of your dates are valid SAS dates, and not character strings.  ... View more

It’s possible but the odds of getting someone to write the code for you is less likely. If you start you’ll probably get help but actually doing it all isn’t likely to happen. There’s a few consultants out there who would do it for a fee. ... View more

I submit that having a column heading of N and a value in a cell of "73.7 (8.8)" or "(63-87)" as shown above is misleading at best. To fit into a single "cell" the result would have to be character to appear as shown. So you would be mixing a column with numeric and character values.   The SAS report procedures will require a column to be all of a single type. Therefore the "easy" approaches such as Proc Tabulate or Report are not going to be available ... View more

Your code is written as you are working with data in SASWORK, but perhaps that's a simplification...? Also, forgive me my ignorance in hash table syntax, but are you keeping records that doesn't have match? If so, and 'have is already in Impala: make sure that your lookup table is there as well. Then use the SQL syntax WHERE id NOT IN (select id from keyvariable) ... View more