topic COUNTY CODES FROM ZIP CODES in SAS Programming

COUNTY CODES FROM ZIP CODES

robertrao — Fri, 26 Feb 2016 23:47:08 GMT

Hello,

I have Zipcodes/CITY where the patient is from and I want to find the corresponsing COUNTY code to which it belongs.

Is it possible with SAS?

Thanks in Advance

Re: COUNTY CODES FROM ZIP CODES

Reeza — Sat, 27 Feb 2016 01:01:58 GMT

Yes, look at the sashelp.zip file. There may be a function ... But I can't recall.

Re: COUNTY CODES FROM ZIP CODES

Haikuo — Sat, 27 Feb 2016 01:44:22 GMT

There is no function for 'zip to county code', and I think the reason lies in the fact that it is not uncommon one zipcode could be shared by multiple counties(Some say as many as 20%).

@Reeza is correct, you need to use sashelp.zipcode table, with the help of city name you have, your zip code should reach a satisfactory pin down on county code.

Update:

When using sashelp.zipcode, the 'county' variable is the county code within states. If you need five digits county code, you need to concatenate 'state' as z2. and 'county' as z3.