For what it's worth, I'm a "New User" to posting in this forum, but I'm not a new user of SAS. I certainly wouldn't say my skills are advanced, but I'm definitely not a beginner, if that makes sense. I've used this forum for years to help me solve "problems" in SAS, and this is the first time I couldn't find a solution for my need, hence the post. I hope I didn't cause any problems. The PROC SQL solutions both did what I needed (had to tweak the first one a bit). I'm not familiar with HASH so I didn't try that. I'd also be open to non-SQL methods (DATA step) if someone has any to suggest. I'm happy to have found a solution that works, but open to learning more than one method to achieve the results I desire. Thanks to everyone for your help!
... View more