TedCarol:   Have you tested the programs?   Which one of the two outputs is your choice?   Does it scale up to your data set?   You are asking for help. When help comes and if it is right, share your joy with SAS Community. If the help is not right for you, come to SAS Cmmunity and give your expected output data set and ask for a suitable and acceptable answer.      ... View more

@TedCarol Please don't post the same question twice.   Cross reference to your other post  https://communities.sas.com/t5/General-SAS-Programming/error-with-date9-field-set-equal-to-macro-variable-in-where/m-p/314360#U314360 ... View more