Date:         Sat, 13 Oct 2001 16:38:49 GMT
Reply-To:     Xlr82sas <xlr82sas@AOL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Xlr82sas <xlr82sas@AOL.COM>
Organization: AOL http://www.aol.com
Subject:      Re: Cooperative work on 2000 Census data

Hi SAS-L'rs,

   I posted record counts for each of the 2,080 files comprising the SF1 census
data, on my site.

  The data is in a SAS table of 52 rows and 40 columns. The columns
  correspond to Segments; SEG01-SEG39, GeoHeader and the rows are states.

  Notice that Seg12-Seg36 columns are identical with totals of 724,015 records,
  while all other columns have 9,541,315 records. Notice also that within
  each group the states counts are identical.

  The entire SF1 data only requires 9.85Gig ( using compress=binary in
  40 SAS tables), each table contains all States, ie one table per segment.

  I have added closest ZIp+4 based on latitude and longitude, along with Census
90
  geocode ( bases on Zip+4 ) to all tables.

 I am thinking about posting checksums so that other users can validate
compilations
 of the data.



Roger J DeAngelis
CompuCraft Inc
XLR82SAS@aol.com ( Accelerate to SAS )
http://members.aol.com/xlr82sas/utl.html