Since you didn't explain, let me ask why do you say "cannot merge the sets back onto the main set and room_name"?
Explain!!!
Show us your SASLOG.
Show us a portion of your data, following these instructions: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712
... View more
