Storing and publishing files via the SDC Clearinghouse

Posted on Updated on

In March, we invited you to share new products or resources from your State Data Center. (Lead, coord, and affiliate members are all welcome.) Your new product can be an interactive data query tool, a data dashboard, a collection of area profiles, a presentation, or a traditional report.

You can tell us about your new product or resource through this google form…

When you submit the name and URL link of your product, we’ll format it as a new item in the wordpress database at


An SDC member has asked: Can we store and publish files via the SDC Clearinghouse?

Specifically, files that don’t (yet) have a home online.

If you have new resources to share, the best practice is to publish in a web-accessible space, where you have the control to add, revise or update (or delete) your own files. That space might or might not be your agency’s main public website.

Some options:

  • If the resource is programming or code, consider google drive or a code-publishing site, like github.
  • If the resource you wish to share is a database, consider storing it on an FTP site or google drive.
  • If the resource is a geodatabase (or shapefile), consider publishing to a geodata clearinghouse in your own state or region.

One more option is the SDC Clearinghouse on wordpress. Storage space is available, though with size restrictions (files less than 20 Meg).  To request space and provide files for publication, contact the SDC Clearinghouse webteam with a short note explaining your need.

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.

PUMS SPSS Code, Census and ACS

Posted on Updated on