Home > Data Services > Catalog . Restricted Data . Census . ACS

Search Data Services

Meta Search
search across all the following databases:

Data Catalog
Data and documentation

KnowledgeBase
Common questions and answers.

Resources
Entire collection of data resources.


Latest Data News

RSS Feed icon

A questionnaire change: politics or not?

Finding “war brides” in the ACS

Census Bureau is considering adding a new Middle East/North Africa ethnic category

Big Data Initiative at NIH-OBSSR

UM Now Has Access to IndiaStat

Data Services Knowledge Base

Q:  

I need many tables from the summary census data for 1990 at the census tract and block group level. I find American FactFinder difficult to use because I can only get data for a single tract at a time. I need all census tracts and block in Los Angeles county. Is there a better solution?

A:  

The easiest way to get data for many units of geography for the 1990 data is to use a statistical package. Here is an example from SAS the first 10 or so tables you want:

filename sf90 PIPE 'zcat 
 /usr/data/level2/data/s436/s436_ca06.Z';
data LA;
infile sf90 lrecl=7925;
input sumlev 11-13  blkgrp 51 @52 tract $char6. county 72-74 
P1 301-309  P4 337-345  P5 346-354  @409 (P8c1-P8c5) (9.)
@454 (P9c1-P9c25) (9.) P10 679-687 @688 (P11c1-P11c16) (9.)
@832 (P12c1-P12c10) (9.) @1201 (P14c1-P14c31) (9.)
@4612 (P17c1-P17c15) (9.) @4918 (P20c1-P20c35) (9.)
@5233 (P21c1-P21c7) (9.) @5539 (P24c1-P24c14) (9.)
@5764 (P27c1-P27c12) (9.) @7897 (P38c1-P38c3) (9.) #2
@301 (P38c4-P38c8) (9.) #4;
if county ne 37 then delete;
data tract;
  set LA;
if sumlev ne 140 then delete;
file 'LA-tracts' lrecl=1646;
   put @1 tract $char6.  P1 9-17  P4 18-26  P5 27-35
@36 (P8c1-P8c5) (9.) @81 (P9c1-P9c25) (9.) P10 306-314
@315 (P11c1-P11c16) (9.) @459 (P12c1-P12c10) (9.)
@549 (P14c1-P14c31) (9.) @828 (P17c1-P17c15) (9.)
@963 (P20c1-P20c35) (9.) @1278 (P21c1-P21c7) (9.)
@1341 (P24c1-P24c14) (9.) @1467 (P27c1-P27c12) (9.)
@1575 (P38c1-P38c8) (9.);
data blkgrp;
   set LA;
if sumlev ne 150 then delete;  
file 'LA-blkgrp' lrecl=1646;
 put @1 tract $char6. blkgrp 7-7 P1 9-17  P4 18-26  P5 27-35
@36 (P8c1-P8c5) (9.) @81 (P9c1-P9c25) (9.) P10 306-314
@315 (P11c1-P11c16) (9.) @459 (P12c1-P12c10) (9.) 
@549 (P14c1-P14c31) (9.) @828 (P17c1-P17c15) (9.) 
@963 (P20c1-P20c35) (9.) @1278 (P21c1-P21c7) (9.)
@1341 (P24c1-P24c14) (9.) @1467 (P27c1-P27c12) (9.)
@1575 (P38c1-P38c8) (9.);
run;

Annotated Resources:

Related Question Groups: