Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: ZIP to State or ZIP to FIPS?


From   Joseph Coveney <[email protected]>
To   Statalist <[email protected]>
Subject   Re: st: ZIP to State or ZIP to FIPS?
Date   Sat, 17 Dec 2005 21:33:57 +0900

David Jaeger wrote:

Anyone know if there is a State equivalent to ZIPSTATE() or ZIPFIPS()
functions in
SAS that will convert a zipcode to the state abbreviation or FIPS
code, respectively?

--------------------------------------------------------------------------------

-findit state fips zipcode- doesn't bring anything up.  There are commercial
datasets in a variety of formats (Microsoft Access, Excel and so on) that
you could purchase and call from Stata in a program or write a Mata function
to do so.

Doesn't the U.S. Bureau of the Census or Department of Labor have
downloadable ASCII files for these kinds of things?  If so, then you could
do the same thing:  write a brief wrapper ado-file for a -merge- (if you
convert the file to Stata) or an SQL join via -odbc- (if you leave it in
ASCII) to return the state when you enter the ZIP code or FIPS code.

Joseph Coveney

*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/



© Copyright 1996–2024 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index