DATA Step, Macro, Functions and more

COUNTY CODES FROM ZIP CODES

Reply
Super Contributor
Posts: 1,041

COUNTY CODES FROM ZIP CODES

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

 

Super User
Posts: 19,877

Re: COUNTY CODES FROM ZIP CODES

Posted in reply to robertrao

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

Respected Advisor
Posts: 3,156

Re: COUNTY CODES FROM ZIP CODES

[ Edited ]
Posted in reply to robertrao

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.  

Ask a Question
Discussion stats
  • 2 replies
  • 214 views
  • 2 likes
  • 3 in conversation