[sas-users] County FIPS codes

Wed Aug 10 09:01:52 EDT 2011

This could be a duplicate.  If it is I apologize.

The problem with counties is they may change yearly.  The Econ Area avoids 
this by creating a Geographic Area Reference File (GARF) for each 5-year 
census.  Many programs such as CBP and Nonemployers use this list for the 
next 5 years.  The garf is available on the census web site.  If you 
cannot find it, let me know and I will send you a copy.

The GARF contains records for states, counties, places(I thin), and the 
three types of metropolitan statistical area.  Each record contains the 
fips code(s) and the name.  It also contains any related codes. 

For example the county record give the county fips, the state fips, the 
code of any MSA the county is in, and the name.

It is straight forward to use this file to create a user define format.

There is at least one NESUG paper on this topic.

David

David D. Chapman
Chief, Quality Assurance Staff
Economic Planning and Coordination Division
U.S. Census Bureau - Economic Statistics
Office: 301-763-6535
Cell: 703-498-5782
E-mail: david.d.chapman at census.gov 

Connect with us:

From:
kevin.m.shaw at census.gov
To:
sas-users at lists.census.gov
Cc:
dssd.cevb.mailing.list at census.gov
Date:
08/09/2011 02:05 PM
Subject:
Re: [sas-users] County FIPS codes
Sent by:
sas-users-bounces at lists.census.gov

Hi Nancy. 

As of a cpl years ago, no, no county FIPS-to-name or name-to-FIPS SAS 
function.  However, in my last cpl divisions, we built a quick format 
table ourselves and let other users in the div point to it. 

It can be a bit tricky tho (this might explain why sas hasn't implemented 
a function), since some codes have expired and deciding on whether to use, 
or use-and-convert, or disregard the expired codes is likely unique to 
each user's project.  For example, Dade Cty, FL, Broomfield Cty, CO and 
Skagway, AK come to mind -- 
http://www.census.gov/geo/www/ansi/changenotes.html. 

Here's a good st-cty list that you could easily pull into a sas format 
table (look for csv on the pg) -- 
http://www.census.gov/popest/counties/counties.html

-KMS. x1851

-----sas-users-bounces at lists.census.gov wrote: ----- 
To: sas-users list for SAS Users Group <sas-users at lists.census.gov>
From: b.nathaniel.miller at census.gov
Sent by: sas-users-bounces at lists.census.gov
Date: 08/09/2011 12:53PM
Subject: Re: [sas-users] County FIPS codes

Hi Nancy, 

I haven't used these personally, but they might be helpful: 
Base SAS software provides several functions that convert state names to 
FIPS codes and vice versa. The following table lists these functions and a 
brief description of each. See SAS Language Reference: Dictionary for more 
information. 
FIPS and Postal Code Functions 
Function 
Description 
STFIPS 
converts state postal code to FIPS state code 
STNAME 
converts state postal code to state name in upper case 
STNAMEL 
converts state postal code to state name in mixed case 
FIPNAME 
converts FIPS code to state name in upper case 
FIPNAMEL 
converts FIPS code to state name in mixed case 
FIPSTATE 
converts FIPS code to state postal code

Nate Miller
Survey Statistician
Economic Planning & Coordination Division
Register Operations Branch
U.S. Census Bureau - Economic Statistics
301-763-9058 

From: 
nancy.l.robbins at census.gov 
To: 
sas-users at lists.census.gov 
Date: 
08/09/2011 12:43 PM 
Subject: 
[sas-users] County FIPS codes 
Sent by: 
sas-users-bounces at lists.census.gov

Does anyone know if there is a FIPS function in SAS to use with the 
3-digit
county codes?  I thought there was but cannot find it in the 
documentation,

_______________________________________________
sas-users mailing list
sas-users at lists.census.gov
http://lists.census.gov/mailman/listinfo/sas-users

_______________________________________________
sas-users mailing list
sas-users at lists.census.gov
http://lists.census.gov/mailman/listinfo/sas-users
_______________________________________________
sas-users mailing list
sas-users at lists.census.gov
http://lists.census.gov/mailman/listinfo/sas-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.census.gov/pipermail/sas-users/attachments/20110810/649cebda/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 4056 bytes
Desc: not available
URL: <http://lists.census.gov/pipermail/sas-users/attachments/20110810/649cebda/attachment-0001.jpe>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/gif
Size: 660 bytes
Desc: not available
URL: <http://lists.census.gov/pipermail/sas-users/attachments/20110810/649cebda/attachment-0004.gif>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/gif
Size: 646 bytes
Desc: not available
URL: <http://lists.census.gov/pipermail/sas-users/attachments/20110810/649cebda/attachment-0005.gif>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/gif
Size: 1177 bytes
Desc: not available
URL: <http://lists.census.gov/pipermail/sas-users/attachments/20110810/649cebda/attachment-0006.gif>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/gif
Size: 654 bytes
Desc: not available
URL: <http://lists.census.gov/pipermail/sas-users/attachments/20110810/649cebda/attachment-0007.gif>