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
Measuring Marriage & Divorce among Same-Sex Couples
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;