You still have not explained why (to follow your initial example) the data from insuranch goes into the 4th observation for run_id 12345, and not into the first, second or third.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.