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/
