Tips and Documentation

Refresher on Census’s embargo data access program

Posted on Updated on

Many of you have embargo data access privileges with the Census Bureau. This post is a refresher on the rules associated with the embargo access program.

Your embargo data access privileges allow you to download, review and analyze data prior to its public release. This early access enables you to provide relevant and accurate assistance. Access privileges also allow you to prepare a local news release to coincide with the Census Bureau’s release.

If you have embargo data access privileges, this access is for YOU ALONE. It is NOT to be shared with anyone.

Within your SDC, if there are co-workers who need embargo access, these co-workers can request their own embargo data access login. To discuss this possibility, please contact any member of the SDC Steering Committee.

Some SDC coordinating agencies have access. Please share this email with them, as they are subject to the same rules.

With this access, certain rules MUST be followed. The embargo policy is online, here:

Embargo access is granted on an individual basis only and cannot be shared with unapproved colleagues or associates ….

Embargoed news releases and data files may not be released to the public by any means (including print, broadcast, Internet, podcast, blogs, or in any other form) before the specified date and time of release. Failure to adhere to this embargo policy will result in the removal of embargo privileges of the reporter (or SDC participant) as follow:

  1. First breach – six-month suspension of embargo privileges.
  2. Subsequent breach – one-year suspension of embargo privileges. Reinstatement must be requested in writing …

The Census Bureau, through its Public Information Office, reserves the right to deny access to embargoed information to any entity that abuses embargo privileges.

If an embargo is broken, the Census Bureau will immediately release the data to the public and a notification will be sent alerting data users that the information is now available to the public.

The Associate Director for Communications or his/her designee has final approval on all matters pertaining to embargo access.

If you have questions about appropriate use of embargo data, please ask Census Bureau staff. We recommend starting with Barbara LaFleur in CLMSO DUB:

Finally, if you know of co-workers or SDC coordinating or affiliate colleagues who need embargo access, please contact any member of the SDC Steering Committee to discuss.

Thanks for your attention to this!



The SDC Network Steering Committee

GSS Initiative – Draft Address Data Content Guidelines

Posted on Updated on

Geographic Support System (GSS) Initiative Announcement from the U.S. Census Bureau – Geography Divsion.

Draft address data content guidelines are now available as part of the U.S. Census Bureau – Geography Division’s GSS Initiative.

As a part of the U.S. Census Bureau’s Geographic Support System Initiative (GSS-I), the Census Bureau is committed to accepting address and structure point data from our partners beginning in the second quarter of fiscal year 2013. These documents outline the address data elements and metadata that the Census Bureau identifies as optimal components in address and structure datasets.   Learn more

Optimal Address Data Submission Guidelines (Draft) – PDF

Census Address to FGDC Address Standard Crosswalk (Draft)  – PDF

Contact us at

SF2 Profile

Posted on Updated on

The 2010 Summary File 2 (SF2) profile was developed by the State Data Center (SDC) Network.  This profile allows users to run a profile on any race/ethnic group listed in the SF2, as long as there are 100 or more people of that specific group in a particular geographic area. We would like to thank John Blodgett of the University of Missouri for his excellent work converting the SF2 data files to SAS datasets. This has made the job of generating the 2010 SF2 profile much easier and more efficient.  We would also like to thank Xan Wedel of the University of Kansas who graciously helped with the SAS coding and proofreading the profile.

Download the SAS programs that can be used to generate the 11-page SF2 profile. A copy of the SF2 profile for Nevada is also provided in the zipped file as an example.

The programs are designed to run in two-phases:

Step 1:  Conversion phase:  convert SF2 data files to SAS data sets. You can download the 2010 SF2 data files from the census FTP site at  and run the conversion program ( to get the data converted to SAS data sets. The program is attached and can also be accessed at

Step 2:  Profile generation phase:  Generate the profile using the SAS data files output from Step 1 as input.

  •  This is the main SAS program used to run the profile. It is set up so the user can select to run only the section(s) of interest and comment out the other sections.  This code controls all of the other modules – you will only change this file when you run the profile.  The instructions on how to run the profile are included in the program.
  • contains the SAS code to generate the General Profile.
  • contains the SAS code to generate the Age Profile.
  • contains the SAS code to generate the Table of Contents.
  • – This file is used by the main routine.  Note that in the program, the specific geography (place and county) is for CA only so you will need to add the codes for your state.

SF1 SAS Profiles for Census 2010

Posted on Updated on

The 2010 Summary File 1 (SF1) profile was developed by the State Data Center (SDC) Network. The 2010 profile generally uses the same formats as the 2000 SF1 profile.

The SAS programs that are used to generate the 58-page SF1 profile are available in the zipped file below. Last revised 8/15/2011.

2010 Census Demographic Profile Template and Production Macro

Posted on Updated on

The California State Census Data Center has prepared a 2-column 2-page Demographic Profile in Excel.  Download this file and change the extension from “.xlsx” to “.xlsm” in order to ensure that this is an Excel 7.0 macro file.  Also ensure that you have set macros to be enabled.

Directions are contained within the Excel file.

2010 Demographic Profiles

Posted on Updated on

This profile in Excel was provided by the Pennsylvania State Data Center:

The attached workbook produces a one-page profile for a geographic area similar to the 2000 DP-1 profile in Excel for printing or viewing.  It also contains a data sheet created from the Access database provided by the Census Bureau with Pennsylvania state, county and county subdivision data.

Pennsylvania used the vlookup function so that you can just type in the name of the geographic area you are interested in (in cell A3) and create the profile for that area.  The Pennsylvania State Data Center finds this worksheet useful when providing data profiles to customers or as a quick way to access the data when responding to requests rather than using American FactFinder.  The profiles are already formatted to print.