[CTPP] PUMS on DVD, MS-Access tutorial

There are two newsworthy items related to the Census Public Use Microdata Data. 1. The first is the recent release of the PUMS DVD. This DVD includes the entire U.S. dataset for the 1-percent and 5-percent PUMS, and includes the Beyond 20/20 software to produce user-defined cross-tabulations of PUMS data. This software is VERY fast and is excellent for developing basic two-way, three-way, four-way, n-way cross-tabulations of PUMS. (For example, to produce a California tabulation of persons by PUMA of residence by tenure by vehicles available by means of transportation to work took just a few seconds to produce this four-way table....Hours to analyze, just seconds to create!) The DVD contains about 3.9 gigabytes of data and software, including the national set of raw ASCII record data. You can use the Beyond 20/20 to create your own tabulations and export into various database formats, like csv, txt, xls, dbf, wk1, wk2, etc. The DVD costs $70.00, and is available from the Census Bureau at: http://www.census.gov/mp/www/Tempcat/C2KPUMS.html 2. There was a message on the Investigative Reporters & Editors' Census listserv, from Professor Steve Doig of Arizona State University, on some Microsoft Access code that Mr. Dick O'Reilly of the Los Angeles Times is making available. From Prof. Doig: "It's been a while since I put anything new on my "Reporting Census 2000" site. But Dick O'Reilly of the LA Times has gifted us with a PUMS tutorial, complete with import specs and sample data and queries, that he put together for those unfamiliar with the oddities of PUMS." Go to this page, and follow the navigation bar to What's New: http://cronkite.pp.asu.edu/census/ This is an excellent "how-to" Census site, and has some great information for non-journalists, as well. The MS-Access "PUMS Tutorial" was uploaded 2/10/04. (Please don't ask me about MS-Access or how this works. I have Access on my machine, but I use SAS as my workhorse software to process PUMS data....) Hope this helps, Chuck Purvis, MTC ************************************************************** Charles L. Purvis, AICP Principal Transportation Planner/Analyst Metropolitan Transportation Commission 101 Eighth Street Oakland, CA 94607-4700 (510) 464-7731 (office) (510) 464-7848 (fax) www: http://www.mtc.ca.gov/ Census WWW: http://www.bayareacensus.ca.gov/ **************************************************************