COUNTY CODES FROM ZIP CODES

[robertrao]

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

[Reeza]

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

[Haikuo]

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.