Hello, I have what is probably a very basic question, but I am new to SAS and would love some help figuring it out. I have a file with a list of zip codes, but there could be multiple zip codes associated with each row of data. (If there are multiple zip codes in a row they are separated by a semi-colon.) The way the data currently looks is demonstrated in the column below labeled "zip_code_have" and is a CHAR variable. I need to: 1) add missing zeros to the zip codes that do not have them (in some cases it could be one zero, and others it could be two because there are some territory zip codes in there) and 2) remove the "-" and last four digits of the zip codes that have them. (So it looks like the column "zip_code_want". ) zip_code_have zip_code_want 916 00916 37322 37322 3452 03452 5701-4012 05701 98682 98682 12953 12953 46311 46311 1234; 1234; 23456-4444 01234; 01234; 23456 84032; 84095; 84065; 84065 84032; 84095; 84065; 84065 Any suggestions would be greatly appreciated! Thanks in advance!
... View more