Hello, I am a SAS newbie (3 months). In my project, I have 3 imported data sets that I need to join together on a primary key that is a numeric type. My challenge is that in two of the tables, the leading zeros do not exist, so the join will not match for those records without the leading zeros. Example: Table1 001001 001002 12345 54321 Table2 1001 1002 12345 54321 Table3 1001 1002 12345 54321 What can I do to add the leading zeros to the values that are missing leading zeros? The fixed length of the field is 5, so no leading zeros should be added to the values that have a non-zero number leading (e.g 12345, 10101). Any help would be greatly appreciated!
... View more