Code
Storing and publishing files via the SDC Clearinghouse
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… https://goo.gl/forms/fLc3pxkFNWO7t9zQ2
When you submit the name and URL link of your product, we’ll format it as a new item in the wordpress database at SDCClearinghouse.com.
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
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 ftp://ftp2.census.gov/census_2010/ and run the conversion program (cnvtsf2.sas) to get the data converted to SAS data sets. The cnvtsf2.sas program is attached and can also be accessed at http://mcdc2.missouri.edu/cgi-bin/uexplore?/pub/data/sf22010/Tools.
Step 2: Profile generation phase: Generate the profile using the SAS data files output from Step 1 as input.
- SF2_main_2010_pdf.sas. 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.
- Genprof1.sas contains the SAS code to generate the General Profile.
- Genprof2.sas contains the SAS code to generate the Age Profile.
- PageTOC.sas contains the SAS code to generate the Table of Contents.
- Formats.sas – This file is used by the main routine. Note that in the program Formats.sas, 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
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.
P.L. Redistricting Data SAS Code
- SAS code for use with the PL files (PA):
- SAS Program
- Sample PDF
- Readme (doc)
- Formatting Macro (doc)
- SAS program for PL (OH)
PUMS SPSS Code, Census and ACS
- Betty Brown at Florida State has made available the following SPSS code
- The Institute for Health and Social Policy has made available the following SPSS code
State Data Center (SDC) Clearinghouse 