topic Re: Extract First 5 Characters of String Variable with Varying Lengths in SAS Programming

Extract First 5 Characters of String Variable with Varying Lengths

sstac — Tue, 08 Aug 2017 15:31:22 GMT

I have a zip code variable in a dataset that includes both 5- and 9-digit zip codes. I want all of them to be 5-digits but am having trouble extracting the first 5 digits of the variable. It is an extensive list, but some examples are 15009, 15208, 191451652, 193760024.

When I try to use substr,

data cases; set cases;

zip=substr(zip_char,1,5);

run;

it seems to truncate the zip codes that are already 5 characters long to "1". Any thoughts on how to avoid this?

Re: Extract First 5 Characters of String Variable with Varying Lengths

LinusH — Tue, 08 Aug 2017 15:36:45 GMT

Perhaps your zip_char is right aligned.
Try to do left() prior to substr().

Re: Extract First 5 Characters of String Variable with Varying Lengths

Astounding — Tue, 08 Aug 2017 15:37:27 GMT

This would happen if ZIP_CHAR is not left-hand justified. Luckily, it's easy to left-hand justify:

length zip $ 5;

zip = left(zip_char);

SUBSTR isn't really needed, once you have assigned a length to the new variable.

Re: Extract First 5 Characters of String Variable with Varying Lengths

Kurt_Bremser — Tue, 08 Aug 2017 15:38:24 GMT

If zip_char has leading blanks this might be the cause. Use the strip() function to get rid of blanks before applying substr().