I'm struggling to figure out how to put these datelines in a data step. The first variable is the first set of numbers, which is the ID, they can be variable. The last variable is the last two letters, representing country. The middle variable is all of the stuff between the ID and Country Code, namely the Business Name 47185 KN Outdoor Trading Inc US 4742 Luna sastreria S.A. ES 479 Norsok A/S DK I would normally try to manually align the code to fix problem, however, my data is quite large. Is there a way to make the last 2 letters of the string in the datalines align to the right to make it easier? Or is there a better solution to this problem?
... View more