Hi All, How do I join two tables using PROC SQL if one of my field containing both character and numeric? Sample dataset Table 1 Book_number Identification_nbr Checkout ABC 00005 Y ABC 00004A Y BU 881123-01-1234 Y BU 1/123332 Y C 001 Y Table 2 Book_number Identification_nbr Age ABC 5 1 ABC 00004A 2 BU 881123-01-1234 3 BU 1/123332 4 C 1 6 Desired result: Book_number Identification_nbr Checkout Age ABC 00005 Y 1 ABC 00004A Y 2 BU 881123-01-1234 Y 3 BU 1/123332 Y 4 C 001 Y 6 Table 2 extracted identification_nbr from table 1 initially but after processing, the 0000 in front missing. I was unable to join both tables because Identification_nbr defined as character in table 1 and table 2.
... View more