Thank you very much for your response. I think your code seems to be exactly what I need. Curiously, the 'overlap' variable calculated using the long sql code above agrees with your code (i.e. the difference between the two dates identified using min and max) agrees about 99% of the time but not a 100%. I may have to troubleshoot why that's happening but your code seems to be more accurate for calculating 'overlap' 🙂 Thank you again!
... View more
Thank you very much for your help once again. I was wondering if there is a way to modify the sql code so that it outputs 2 additional columns containing the 2 dates that were used to compute that difference/overlapping days. I can do it for two combinations in a simple separate data step, but I found that it gets quite hairy when considering 3-5 combinations. Thank you very much!
... View more
Use CALL SORTC to sort the variables then concatename them:
data want;
set have;
array dx d1-d4;
call sortc(of dx(*));
concat=cat(dx(*)); /* OR concat=compres(d1||d2||d3||d4); OR concat=cat(d1,d2,d3,d4) */
drop d1-d4;
run;
... View more
Hi, Thank you for letting me know. Could you elaborate how so? Thanks! ##- Please type your reply above this line. Simple formatting, no attachments. -##
... View more
