1 The SAS System 09:23 Thursday, September 24, 2009 NOTE: Unable to open SASUSER.REGSTRY. WORK.REGSTRY will be opened instead. NOTE: All registry changes will be lost at the end of the session. WARNING: Unable to copy SASUSER registry to WORK registry. Because of this, you will not see registry customizations during this session. NOTE: Copyright (c) 2002-2003 by SAS Institute Inc., Cary, NC, USA. NOTE: SAS (r) 9.1 (TS1M3) Licensed to THE CURATORS OF THE UNIV OF MISSOURI - T&R, Site 0001242018. NOTE: This session is executing on the AIX 5.2 platform. NOTE: SAS 9.1.3 Service Pack 4 NOTE: SAS initialization used: real time 0.32 seconds cpu time 0.11 seconds NOTE: AUTOEXEC processing beginning; file is /home/john/autoexec.sas. v8= 0 v9= 1 ***** ****** Standard OSEDA/MCDC autoexec (autoexec9.sas in sascode) rev. 12/28/2004 3:06PM - Begin execution ******* _v9= v9 Standard filerefs and librefs assigned ***** NOTE: Libref SF32000X was successfully assigned as follows: Levels: 1 Engine(1): V9 Physical Name(1): /pub/data/sf32000x NOTE: Libref SF3X was successfully assigned as follows: Levels: 1 Engine(1): V9 Physical Name(1): /pub/data/sf32000x NOTE: Libref INDCTRS was successfully assigned as follows: Levels: 1 Engine(1): V9 Physical Name(1): /pub/data/indctrs NOTE: Libname LIBRARY refers to the same physical library as SASCTLGS. NOTE: Libref LIBRARY was successfully assigned as follows: Engine: V9 Physical Name: /pub/sasctlgs/v9 ****Finished with generic autoexec **** *** ****Executing my private autoexec.sas file, rev. 02/28/2006 7:40AM WARNING: Library MAPS is not assigned in this scope. WARNING: Library GISMAPS is not assigned in this scope. ***** dmsflag= NODMS dmchk execution begins *** **Begin execution on Thursday 24SEP09 at 09:23 PID=622684 NOTE: AUTOEXEC processing completed. 1 x cd /pub/data/sf32000/Tools 1 ! ; %let pgm=usgeos; filename pgm "&pgm..sas"; 2 The SAS System 09:23 Thursday, September 24, 2009 2 /*--Create sf3.usgeos by reading the geography-only file for the US (NO LONGER concatenating other XXgeos datasets.) 3 jgb, march, 2009. 4 (after the recovery). 5 Edited (to drop more variables) 4-20-09 . 6 Code added to assign State for ZCTAs at 860 sumlev. 5-5-09. 7 Modified 9/09 to add data for the PUMA level, taken from our custom sf3.uspumasph data set. 8 */ 9 libname sf32000 "/pub/data/sf32000"; NOTE: Libref SF32000 was successfully assigned as follows: Engine: V9 Physical Name: /pub/data/sf32000 9 ! *--we read from the rawdata directory but write to sf32000 so we cannot use 9 ! &inpath to 10 define this libref now.----; 11 libname sf3 (sf32000); NOTE: Libref SF3 was successfully assigned as follows: Levels: 1 Engine(1): V9 Physical Name(1): /pub/data/sf32000 11 ! *---alias name--; 12 title "Create sf3.usgoes"; 13 /* =======================Begin comment================ 14 Decided NOT TO DO IT TTHIS WAY. See below. 15 data 16 sf32000.usgeos (compress=yes label="2000 Summary File 3 (SF3) Geo Headers data for US" 17 keep=geocode--AreaSQMI ); 18 set sf3.usstcntygeos sf3.usregdivgeos sf3.usuasgeos sf3.usplacesgeos sf3.uszipsgeos 19 sf3.uspumasph(keep=sumlev geocode areaname state in=inpuma) open=defer; 20 if geocomp gt '00' then delete; 21 run; 22 proc sort; by sumlev logrecno; run; 23 ======================End comment================== */ 24 25 filename geos pipe "unzip -a -p /pub/data/sf32000/rawdata/usgeo_uf3"; 26 27 data sf32000.usgeos (compress=yes sortedby=LogRecNo label="2000 Summary File 3 (SF3) Geo Headers data for US (all 27 ! levels)") 28 sf32000.usgeocompgeos(compress=yes sortedby=LogRecNo label="2000 Summary File 3 (SF3) Geo Headers data for geographic 28 ! components"); 29 infile geos missover lrecl=1024 end=last; 30 retain _first 1; drop _first; 31 length GeoCode $44 SumLev $3 GeoComp $2 AreaName $90; *--establish variable order -- these go first--; 32 length geoid $34; 33 retain State " " Stab " "; length County $5 ; *--and then these... -; 34 format county $county.; 35 if _first then do; 36 input FileId $char6. stusab $2. @; retain FileId stusab; drop fileid stusab; 37 if substr(FileId,2,3) ne 'SF3' then do; 38 file log; put '******Problem with input geographic headers file. Did not find "SF3" in cols. 2-4 ' FileId= / 39 '***Conversion will not run***'; 40 list; 41 stop; 42 end; 43 end; 44 45 input 3 The SAS System 09:23 Thursday, September 24, 2009 46 @9 SumLev $3. geocomp $2. 47 @19 LogRecNo 7. 48 @26 Region $1. Division $1. StateCe $2. State $2. Cnty $3. CntySC $2. 49 @37 CouSubFP $5. CouSubCC $2. CouSubSC $2. PlaceFP $5. PlaceCC $2. PlaceDC $1. PlaceSC $2. 50 @56 _TractIn $6. BG $1. Block $4. @69 ConCit $5. 51 @78 aianhh $char4. aianhhfp $char5. aianhhcc $char2. aihhtli $1. aitsce $char3. aits $char5. aitscc $char2. 52 anrc $char5. anrccc $char2. 53 @107 MSACMSA $4. MASC $2. CMSA2 $2. MACCI $1. PMSA $4. NECMA $4. 54 @128 UA $5. UASC $2. UAType $1. 55 @136 UrbanRur $1. cd106 $2. cd108 $2. +4 (sldu sldl)($char3.) vtd $char6. vtdi $1. 56 @158 ZCTA3 $3. ZCTA5 $5. 57 @168 SubMCD $5. 58 @173 (AreaLand AreaWatr)(14.) AreaName $90. FuncStat $1. gcuni $1. 59 @293 Pop100 9. HU100 9. IntPtLat 9.6 IntPtLon 10.6 LSADC $2. 60 @332 PartFlag $1. (SDElm SDSec SDUni)($5.) TAZ $6. UGA $5. PUMA5 $5. PUMA1 $5. 61 @384 MACC $char5. UACP $char5. ; 62 63 if cnty ne ' ' then County=State||cnty; 64 if _tractin ne ' ' then tract=substr(_tractin,1,4)||'.'||substr(_tractin,5,2); 65 66 %include '/pub/data/sf32000/Tools/assign_geocode.sas'; *---Select statement to assign value to geocode variable-; 197 if zcta5 ne ' ' and state=' ' then do; 198 stab=put(zcta5,$zipstab.); 199 if stab=' ' then do; *---Mostly PR ZIPs--; 200 state=zipfips(zcta5); stab=put(state,$fipstab2.); 201 end; 202 else state=stfips(stab); 203 end; 204 *---Create land and total area values in square miles, as we do with sf32000 full table data sets--; 205 LandSQMI=AreaLand/2589988; AreaSQMI=LandSQMI + (AreaWatr/2589988); *<--where 2589988 is # sq km in a sq mile--; 206 attrib LandSQMI format=9.2 label='Land Area in Sq Miles' AreaSQMI format=9.2 label='Total Area incl Water in Sq 206 ! Miles'; 207 208 209 if geocode ne ' ' then geoid=sumlev||geocomp||'US'||compress(geocode,'-'); 210 _lgeocode=length(geocode); retain _maxl; _maxl=max(_maxl,_lgeocode); 211 if _n_=487093 then put _all_; 212 213 drop cd108 sldu sldl vtd puma1 puma5 sdelm sdsec sduni taz submcd ; *---these are never defined on this file---; 214 if geocomp='00' then output sf32000.usgeos; 215 else output sf32000.usgeocompgeos; 216 217 if last then do; 218 *----Read the uspumasph data set and add these new rows---; 219 array cfields(*) geocode-character-tract; 220 do _i=1 to dim( cfields); cfields{_i}=' '; end; 221 do until(nomorepumas); 222 set sf3.uspumasph(keep=geocode SumLev Areaname State intptlat intptlon puma5 landsqmi areasqmi pop100 HU100) 223 end=nomorepumas; 224 geoid='79500US'||geocode; geocomp='00'; stab=put(state,$fipstab2.); 225 *---Assign new LogRecNo values in the 500,000 series. Note that we specify sortedby=logrecno on these datasets-; 226 retain _logrecnopuma 500000; 227 *--We already have the area variables in square miles so we reverse the process and calculate the sq km 227 ! variables--; 228 AreaLand=LandSqmi* 2589988; AreaWatr=2589988*(Areasqmi-LandSqmi); 229 _logrecnopuma+1; logrecno=_logrecnopuma; 4 The SAS System 09:23 Thursday, September 24, 2009 230 output sf32000.usgeos; 231 end; 232 end; 233 drop _: ; 234 run; NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 200:14 202:16 NOTE: The infile GEOS is: Pipe command="unzip -a -p /pub/data/sf32000/rawdata/usgeo_uf3" NOTE: Invalid argument to function ZIPFIPS at line 200 column 14. RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0 453074 uSF3 US86000000 0453074 101 006006HH 0 1900872293 201 006HH 5-Digit ZCTA S 301 0 0+18473441-066834528Z5 400 last=0 _first=1 GeoCode=006HH SumLev=860 GeoComp=00 AreaName=006HH 5-Digit ZCTA geoid=86000US006HH State=. Stab=. County= FileId=uSF3 stusab=US LogRecNo=453074 Region= Division= StateCe= Cnty= CntySC= CouSubFP= CouSubCC= CouSubSC= PlaceFP= PlaceCC= PlaceDC= PlaceSC= _TractIn= BG= Block= ConCit= aianhh= aianhhfp= aianhhcc= aihhtli= aitsce= aits= aitscc= anrc= anrccc= MSACMSA= MASC= CMSA2= MACCI= PMSA= NECMA= UA= UASC= UAType= UrbanRur= cd106= cd108= sldu= sldl= vtd= vtdi= ZCTA3=006 ZCTA5=006HH SubMCD= AreaLand=0 AreaWatr=1900872293 FuncStat=S gcuni= Pop100=0 HU100=0 IntPtLat=18.473441 IntPtLon=-66.834528 LSADC=Z5 PartFlag= SDElm= SDSec= SDUni= TAZ= UGA= PUMA5= PUMA1= MACC= UACP= tract= _arg= _badsl=0 LandSQMI=0.00 AreaSQMI=733.93 _lgeocode=5 _maxl=24 _i=. nomorepumas=0 _logrecnopuma=500000 _ERROR_=1 _N_=453074 NOTE: Invalid argument to function ZIPFIPS at line 200 column 14. 453075 uSF3 US86000000 0453075 101 006006XX 58461203 19768424 201 006XX 5-Digit ZCTA S 301 0 6+18102537-067888030Z5 400 last=0 _first=1 GeoCode=006XX SumLev=860 GeoComp=00 AreaName=006XX 5-Digit ZCTA geoid=86000US006XX State=. Stab=. County= FileId=uSF3 stusab=US LogRecNo=453075 Region= Division= StateCe= Cnty= CntySC= CouSubFP= CouSubCC= CouSubSC= PlaceFP= PlaceCC= PlaceDC= PlaceSC= _TractIn= BG= Block= ConCit= aianhh= aianhhfp= aianhhcc= aihhtli= aitsce= aits= aitscc= anrc= anrccc= MSACMSA= MASC= CMSA2= MACCI= PMSA= NECMA= UA= UASC= UAType= UrbanRur= cd106= cd108= sldu= sldl= vtd= vtdi= ZCTA3=006 ZCTA5=006XX SubMCD= AreaLand=58461203 AreaWatr=19768424 FuncStat=S gcuni= Pop100=0 HU100=6 IntPtLat=18.102537 IntPtLon=-67.888030 LSADC=Z5 PartFlag= SDElm= SDSec= SDUni= TAZ= UGA= PUMA5= PUMA1= MACC= UACP= tract= _arg= _badsl=0 LandSQMI=22.57 AreaSQMI=30.20 _lgeocode=5 _maxl=24 _i=. nomorepumas=0 _logrecnopuma=500000 _ERROR_=1 _N_=453075 NOTE: Invalid argument to function ZIPFIPS at line 200 column 14. 453121 uSF3 US86000000 0453121 101 007007HH 0 2534023807 201 007HH 5-Digit ZCTA S 301 0 0+17981672-066014594Z5 400 last=0 _first=1 GeoCode=007HH SumLev=860 GeoComp=00 AreaName=007HH 5-Digit ZCTA geoid=86000US007HH State=. Stab=. County= FileId=uSF3 stusab=US LogRecNo=453121 Region= Division= StateCe= Cnty= CntySC= CouSubFP= CouSubCC= CouSubSC= PlaceFP= PlaceCC= PlaceDC= PlaceSC= _TractIn= BG= Block= ConCit= aianhh= aianhhfp= aianhhcc= aihhtli= aitsce= aits= aitscc= anrc= anrccc= MSACMSA= MASC= CMSA2= MACCI= PMSA= NECMA= UA= UASC= UAType= UrbanRur= cd106= cd108= sldu= sldl= vtd= vtdi= ZCTA3=007 ZCTA5=007HH SubMCD= AreaLand=0 AreaWatr=2534023807 FuncStat=S gcuni= Pop100=0 HU100=0 IntPtLat=17.981672 IntPtLon=-66.014594 LSADC=Z5 PartFlag= SDElm= SDSec= SDUni= TAZ= UGA= PUMA5= PUMA1= MACC= UACP= tract= _arg= _badsl=0 LandSQMI=0.00 AreaSQMI=978.39 _lgeocode=5 _maxl=24 _i=. nomorepumas=0 _logrecnopuma=500000 _ERROR_=1 _N_=453121 NOTE: Invalid argument to function ZIPFIPS at line 200 column 14. 453122 uSF3 US86000000 0453122 101 007007XX 1679766 20544187 201 007XX 5-Digit ZCTA S 301 0 0+17962234-066555461Z5 400 last=0 _first=1 GeoCode=007XX SumLev=860 GeoComp=00 AreaName=007XX 5-Digit ZCTA geoid=86000US007XX State=. Stab=. County= FileId=uSF3 stusab=US LogRecNo=453122 Region= Division= StateCe= Cnty= CntySC= CouSubFP= CouSubCC= CouSubSC= PlaceFP= PlaceCC= PlaceDC= PlaceSC= _TractIn= BG= Block= ConCit= aianhh= aianhhfp= aianhhcc= aihhtli= aitsce= aits= aitscc= 5 The SAS System 09:23 Thursday, September 24, 2009 anrc= anrccc= MSACMSA= MASC= CMSA2= MACCI= PMSA= NECMA= UA= UASC= UAType= UrbanRur= cd106= cd108= sldu= sldl= vtd= vtdi= ZCTA3=007 ZCTA5=007XX SubMCD= AreaLand=1679766 AreaWatr=20544187 FuncStat=S gcuni= Pop100=0 HU100=0 IntPtLat=17.962234 IntPtLon=-66.555461 LSADC=Z5 PartFlag= SDElm= SDSec= SDUni= TAZ= UGA= PUMA5= PUMA1= MACC= UACP= tract= _arg= _badsl=0 LandSQMI=0.65 AreaSQMI=8.58 _lgeocode=5 _maxl=24 _i=. nomorepumas=0 _logrecnopuma=500000 _ERROR_=1 _N_=453122 NOTE: Invalid argument to function ZIPFIPS at line 200 column 14. RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0 453161 uSF3 US86000000 0453161 101 009009HH 0 165668639 201 009HH 5-Digit ZCTA S 301 0 0+18435287-066066533Z5 400 last=0 _first=1 GeoCode=009HH SumLev=860 GeoComp=00 AreaName=009HH 5-Digit ZCTA geoid=86000US009HH State=. Stab=. County= FileId=uSF3 stusab=US LogRecNo=453161 Region= Division= StateCe= Cnty= CntySC= CouSubFP= CouSubCC= CouSubSC= PlaceFP= PlaceCC= PlaceDC= PlaceSC= _TractIn= BG= Block= ConCit= aianhh= aianhhfp= aianhhcc= aihhtli= aitsce= aits= aitscc= anrc= anrccc= MSACMSA= MASC= CMSA2= MACCI= PMSA= NECMA= UA= UASC= UAType= UrbanRur= cd106= cd108= sldu= sldl= vtd= vtdi= ZCTA3=009 ZCTA5=009HH SubMCD= AreaLand=0 AreaWatr=165668639 FuncStat=S gcuni= Pop100=0 HU100=0 IntPtLat=18.435287 IntPtLon=-66.066533 LSADC=Z5 PartFlag= SDElm= SDSec= SDUni= TAZ= UGA= PUMA5= PUMA1= MACC= UACP= tract= _arg= _badsl=0 LandSQMI=0.00 AreaSQMI=63.97 _lgeocode=5 _maxl=24 _i=. nomorepumas=0 _logrecnopuma=500000 _ERROR_=1 _N_=453161 NOTE: Invalid argument to function ZIPFIPS at line 200 column 14. 453698 uSF3 US86000000 0453698 101 027027HH 0 744123700 201 027HH 5-Digit ZCTA S 301 0 0+41711052-071036300Z5 400 last=0 _first=1 GeoCode=027HH SumLev=860 GeoComp=00 AreaName=027HH 5-Digit ZCTA geoid=86000US027HH State=. Stab=. County= FileId=uSF3 stusab=US LogRecNo=453698 Region= Division= StateCe= Cnty= CntySC= CouSubFP= CouSubCC= CouSubSC= PlaceFP= PlaceCC= PlaceDC= PlaceSC= _TractIn= BG= Block= ConCit= aianhh= aianhhfp= aianhhcc= aihhtli= aitsce= aits= aitscc= anrc= anrccc= MSACMSA= MASC= CMSA2= MACCI= PMSA= NECMA= UA= UASC= UAType= UrbanRur= cd106= cd108= sldu= sldl= vtd= vtdi= ZCTA3=027 ZCTA5=027HH SubMCD= AreaLand=0 AreaWatr=744123700 FuncStat=S gcuni= Pop100=0 HU100=0 IntPtLat=41.711052 IntPtLon=-71.036300 LSADC=Z5 PartFlag= SDElm= SDSec= SDUni= TAZ= UGA= PUMA5= PUMA1= MACC= UACP= tract= _arg= _badsl=0 LandSQMI=0.00 AreaSQMI=287.31 _lgeocode=5 _maxl=24 _i=. nomorepumas=0 _logrecnopuma=500000 _ERROR_=1 _N_=453698 NOTE: Invalid argument to function ZIPFIPS at line 200 column 14. 453772 uSF3 US86000000 0453772 101 029029HH 0 13647202 201 029HH 5-Digit ZCTA S 301 0 0+41814100-071401451Z5 400 last=0 _first=1 GeoCode=029HH SumLev=860 GeoComp=00 AreaName=029HH 5-Digit ZCTA geoid=86000US029HH State=. Stab=. County= FileId=uSF3 stusab=US LogRecNo=453772 Region= Division= StateCe= Cnty= CntySC= CouSubFP= CouSubCC= CouSubSC= PlaceFP= PlaceCC= PlaceDC= PlaceSC= _TractIn= BG= Block= ConCit= aianhh= aianhhfp= aianhhcc= aihhtli= aitsce= aits= aitscc= anrc= anrccc= MSACMSA= MASC= CMSA2= MACCI= PMSA= NECMA= UA= UASC= UAType= UrbanRur= cd106= cd108= sldu= sldl= vtd= vtdi= ZCTA3=029 ZCTA5=029HH SubMCD= AreaLand=0 AreaWatr=13647202 FuncStat=S gcuni= Pop100=0 HU100=0 IntPtLat=41.814100 IntPtLon=-71.401451 LSADC=Z5 PartFlag= SDElm= SDSec= SDUni= TAZ= UGA= PUMA5= PUMA1= MACC= UACP= tract= _arg= _badsl=0 LandSQMI=0.00 AreaSQMI=5.27 _lgeocode=5 _maxl=24 _i=. nomorepumas=0 _logrecnopuma=500000 _ERROR_=1 _N_=453772 NOTE: Invalid argument to function ZIPFIPS at line 200 column 14. 454019 uSF3 US86000000 0454019 101 038038HH 0 341524299 201 038HH 5-Digit ZCTA S 301 0 0+43311793-070913936Z5 400 last=0 _first=1 GeoCode=038HH SumLev=860 GeoComp=00 AreaName=038HH 5-Digit ZCTA geoid=86000US038HH State=. Stab=. County= FileId=uSF3 stusab=US LogRecNo=454019 Region= Division= StateCe= Cnty= CntySC= CouSubFP= CouSubCC= CouSubSC= PlaceFP= PlaceCC= PlaceDC= PlaceSC= _TractIn= BG= Block= ConCit= aianhh= aianhhfp= aianhhcc= aihhtli= aitsce= aits= aitscc= anrc= anrccc= MSACMSA= MASC= CMSA2= MACCI= PMSA= NECMA= UA= UASC= UAType= UrbanRur= cd106= cd108= sldu= sldl= vtd= vtdi= ZCTA3=038 ZCTA5=038HH SubMCD= AreaLand=0 AreaWatr=341524299 FuncStat=S gcuni= Pop100=0 HU100=0 IntPtLat=43.311793 IntPtLon=-70.913936 LSADC=Z5 PartFlag= SDElm= SDSec= SDUni= TAZ= UGA= PUMA5= PUMA1= MACC= UACP= tract= _arg= _badsl=0 LandSQMI=0.00 AreaSQMI=131.86 _lgeocode=5 _maxl=24 _i=. nomorepumas=0 _logrecnopuma=500000 _ERROR_=1 _N_=454019 NOTE: Invalid argument to function ZIPFIPS at line 200 column 14. 454444 uSF3 US86000000 0454444 101 049049HH 0 451136232 6 The SAS System 09:23 Thursday, September 24, 2009 RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0 201 049HH 5-Digit ZCTA S 301 0 0+44762422-069719614Z5 400 last=0 _first=1 GeoCode=049HH SumLev=860 GeoComp=00 AreaName=049HH 5-Digit ZCTA geoid=86000US049HH State=. Stab=. County= FileId=uSF3 stusab=US LogRecNo=454444 Region= Division= StateCe= Cnty= CntySC= CouSubFP= CouSubCC= CouSubSC= PlaceFP= PlaceCC= PlaceDC= PlaceSC= _TractIn= BG= Block= ConCit= aianhh= aianhhfp= aianhhcc= aihhtli= aitsce= aits= aitscc= anrc= anrccc= MSACMSA= MASC= CMSA2= MACCI= PMSA= NECMA= UA= UASC= UAType= UrbanRur= cd106= cd108= sldu= sldl= vtd= vtdi= ZCTA3=049 ZCTA5=049HH SubMCD= AreaLand=0 AreaWatr=451136232 FuncStat=S gcuni= Pop100=0 HU100=0 IntPtLat=44.762422 IntPtLon=-69.719614 LSADC=Z5 PartFlag= SDElm= SDSec= SDUni= TAZ= UGA= PUMA5= PUMA1= MACC= UACP= tract= _arg= _badsl=0 LandSQMI=0.00 AreaSQMI=174.18 _lgeocode=5 _maxl=24 _i=. nomorepumas=0 _logrecnopuma=500000 _ERROR_=1 _N_=454444 NOTE: Invalid argument to function ZIPFIPS at line 200 column 14. 454445 uSF3 US86000000 0454445 101 049049XX 986262153 7997666 201 049XX 5-Digit ZCTA S 301 1 109+45266601-070385639Z5 400 last=0 _first=1 GeoCode=049XX SumLev=860 GeoComp=00 AreaName=049XX 5-Digit ZCTA geoid=86000US049XX State=. Stab=. County= FileId=uSF3 stusab=US LogRecNo=454445 Region= Division= StateCe= Cnty= CntySC= CouSubFP= CouSubCC= CouSubSC= PlaceFP= PlaceCC= PlaceDC= PlaceSC= _TractIn= BG= Block= ConCit= aianhh= aianhhfp= aianhhcc= aihhtli= aitsce= aits= aitscc= anrc= anrccc= MSACMSA= MASC= CMSA2= MACCI= PMSA= NECMA= UA= UASC= UAType= UrbanRur= cd106= cd108= sldu= sldl= vtd= vtdi= ZCTA3=049 ZCTA5=049XX SubMCD= AreaLand=986262153 AreaWatr=7997666 FuncStat=S gcuni= Pop100=1 HU100=109 IntPtLat=45.266601 IntPtLon=-70.385639 LSADC=Z5 PartFlag= SDElm= SDSec= SDUni= TAZ= UGA= PUMA5= PUMA1= MACC= UACP= tract= _arg= _badsl=0 LandSQMI=380.80 AreaSQMI=383.89 _lgeocode=5 _maxl=24 _i=. nomorepumas=0 _logrecnopuma=500000 _ERROR_=1 _N_=454445 NOTE: Invalid argument to function ZIPFIPS at line 200 column 14. 455002 uSF3 US86000000 0455002 101 069069HH 0 34834201 201 069HH 5-Digit ZCTA S 301 0 0+41022330-073536283Z5 400 last=0 _first=1 GeoCode=069HH SumLev=860 GeoComp=00 AreaName=069HH 5-Digit ZCTA geoid=86000US069HH State=. Stab=. County= FileId=uSF3 stusab=US LogRecNo=455002 Region= Division= StateCe= Cnty= CntySC= CouSubFP= CouSubCC= CouSubSC= PlaceFP= PlaceCC= PlaceDC= PlaceSC= _TractIn= BG= Block= ConCit= aianhh= aianhhfp= aianhhcc= aihhtli= aitsce= aits= aitscc= anrc= anrccc= MSACMSA= MASC= CMSA2= MACCI= PMSA= NECMA= UA= UASC= UAType= UrbanRur= cd106= cd108= sldu= sldl= vtd= vtdi= ZCTA3=069 ZCTA5=069HH SubMCD= AreaLand=0 AreaWatr=34834201 FuncStat=S gcuni= Pop100=0 HU100=0 IntPtLat=41.022330 IntPtLon=-73.536283 LSADC=Z5 PartFlag= SDElm= SDSec= SDUni= TAZ= UGA= PUMA5= PUMA1= MACC= UACP= tract= _arg= _badsl=0 LandSQMI=0.00 AreaSQMI=13.45 _lgeocode=5 _maxl=24 _i=. nomorepumas=0 _logrecnopuma=500000 _ERROR_=1 _N_=455002 NOTE: Invalid argument to function ZIPFIPS at line 200 column 14. 455625 uSF3 US86000000 0455625 101 089089HH 0 989426 201 089HH 5-Digit ZCTA S 301 0 0+40443875-074455385Z5 400 last=0 _first=1 GeoCode=089HH SumLev=860 GeoComp=00 AreaName=089HH 5-Digit ZCTA geoid=86000US089HH State=. Stab=. County= FileId=uSF3 stusab=US LogRecNo=455625 Region= Division= StateCe= Cnty= CntySC= CouSubFP= CouSubCC= CouSubSC= PlaceFP= PlaceCC= PlaceDC= PlaceSC= _TractIn= BG= Block= ConCit= aianhh= aianhhfp= aianhhcc= aihhtli= aitsce= aits= aitscc= anrc= anrccc= MSACMSA= MASC= CMSA2= MACCI= PMSA= NECMA= UA= UASC= UAType= UrbanRur= cd106= cd108= sldu= sldl= vtd= vtdi= ZCTA3=089 ZCTA5=089HH SubMCD= AreaLand=0 AreaWatr=989426 FuncStat=S gcuni= Pop100=0 HU100=0 IntPtLat=40.443875 IntPtLon=-74.455385 LSADC=Z5 PartFlag= SDElm= SDSec= SDUni= TAZ= UGA= PUMA5= PUMA1= MACC= UACP= tract= _arg= _badsl=0 LandSQMI=0.00 AreaSQMI=0.38 _lgeocode=5 _maxl=24 _i=. nomorepumas=0 _logrecnopuma=500000 _ERROR_=1 _N_=455625 NOTE: Invalid argument to function ZIPFIPS at line 200 column 14. 457350 uSF3 US86000000 0457350 101 149149HH 0 3138962 201 149HH 5-Digit ZCTA S 301 0 0+42086874-076792693Z5 400 last=0 _first=1 GeoCode=149HH SumLev=860 GeoComp=00 AreaName=149HH 5-Digit ZCTA geoid=86000US149HH State=. Stab=. County= FileId=uSF3 stusab=US LogRecNo=457350 Region= Division= StateCe= Cnty= CntySC= CouSubFP= CouSubCC= CouSubSC= PlaceFP= PlaceCC= PlaceDC= PlaceSC= _TractIn= BG= Block= ConCit= aianhh= aianhhfp= aianhhcc= aihhtli= aitsce= aits= aitscc= anrc= anrccc= MSACMSA= MASC= CMSA2= MACCI= PMSA= NECMA= UA= UASC= UAType= UrbanRur= cd106= cd108= sldu= sldl= vtd= vtdi= ZCTA3=149 ZCTA5=149HH SubMCD= AreaLand=0 AreaWatr=3138962 FuncStat=S gcuni= Pop100=0 HU100=0 IntPtLat=42.086874 7 The SAS System 09:23 Thursday, September 24, 2009 IntPtLon=-76.792693 LSADC=Z5 PartFlag= SDElm= SDSec= SDUni= TAZ= UGA= PUMA5= PUMA1= MACC= UACP= tract= _arg= _badsl=0 LandSQMI=0.00 AreaSQMI=1.21 _lgeocode=5 _maxl=24 _i=. nomorepumas=0 _logrecnopuma=500000 _ERROR_=1 _N_=457350 NOTE: Invalid argument to function ZIPFIPS at line 200 column 14. RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0 459172 uSF3 US86000000 0459172 101 196196HH 0 3476151 201 196HH 5-Digit ZCTA S 301 0 0+40355292-075939272Z5 400 last=0 _first=1 GeoCode=196HH SumLev=860 GeoComp=00 AreaName=196HH 5-Digit ZCTA geoid=86000US196HH State=. Stab=. County= FileId=uSF3 stusab=US LogRecNo=459172 Region= Division= StateCe= Cnty= CntySC= CouSubFP= CouSubCC= CouSubSC= PlaceFP= PlaceCC= PlaceDC= PlaceSC= _TractIn= BG= Block= ConCit= aianhh= aianhhfp= aianhhcc= aihhtli= aitsce= aits= aitscc= anrc= anrccc= MSACMSA= MASC= CMSA2= MACCI= PMSA= NECMA= UA= UASC= UAType= UrbanRur= cd106= cd108= sldu= sldl= vtd= vtdi= ZCTA3=196 ZCTA5=196HH SubMCD= AreaLand=0 AreaWatr=3476151 FuncStat=S gcuni= Pop100=0 HU100=0 IntPtLat=40.355292 IntPtLon=-75.939272 LSADC=Z5 PartFlag= SDElm= SDSec= SDUni= TAZ= UGA= PUMA5= PUMA1= MACC= UACP= tract= _arg= _badsl=0 LandSQMI=0.00 AreaSQMI=1.34 _lgeocode=5 _maxl=24 _i=. nomorepumas=0 _logrecnopuma=500000 _ERROR_=1 _N_=459172 NOTE: Invalid argument to function ZIPFIPS at line 200 column 14. 459243 uSF3 US86000000 0459243 101 199199HH 0 1183510928 201 199HH 5-Digit ZCTA S 301 0 0+38747453-075226714Z5 400 last=0 _first=1 GeoCode=199HH SumLev=860 GeoComp=00 AreaName=199HH 5-Digit ZCTA geoid=86000US199HH State=. Stab=. County= FileId=uSF3 stusab=US LogRecNo=459243 Region= Division= StateCe= Cnty= CntySC= CouSubFP= CouSubCC= CouSubSC= PlaceFP= PlaceCC= PlaceDC= PlaceSC= _TractIn= BG= Block= ConCit= aianhh= aianhhfp= aianhhcc= aihhtli= aitsce= aits= aitscc= anrc= anrccc= MSACMSA= MASC= CMSA2= MACCI= PMSA= NECMA= UA= UASC= UAType= UrbanRur= cd106= cd108= sldu= sldl= vtd= vtdi= ZCTA3=199 ZCTA5=199HH SubMCD= AreaLand=0 AreaWatr=1183510928 FuncStat=S gcuni= Pop100=0 HU100=0 IntPtLat=38.747453 IntPtLon=-75.226714 LSADC=Z5 PartFlag= SDElm= SDSec= SDUni= TAZ= UGA= PUMA5= PUMA1= MACC= UACP= tract= _arg= _badsl=0 LandSQMI=0.00 AreaSQMI=456.96 _lgeocode=5 _maxl=24 _i=. nomorepumas=0 _logrecnopuma=500000 _ERROR_=1 _N_=459243 NOTE: Invalid argument to function ZIPFIPS at line 200 column 14. 459803 uSF3 US86000000 0459803 101 219219HH 0 176715298 201 219HH 5-Digit ZCTA S 301 0 0+39571786-075871185Z5 400 last=0 _first=1 GeoCode=219HH SumLev=860 GeoComp=00 AreaName=219HH 5-Digit ZCTA geoid=86000US219HH State=. Stab=. County= FileId=uSF3 stusab=US LogRecNo=459803 Region= Division= StateCe= Cnty= CntySC= CouSubFP= CouSubCC= CouSubSC= PlaceFP= PlaceCC= PlaceDC= PlaceSC= _TractIn= BG= Block= ConCit= aianhh= aianhhfp= aianhhcc= aihhtli= aitsce= aits= aitscc= anrc= anrccc= MSACMSA= MASC= CMSA2= MACCI= PMSA= NECMA= UA= UASC= UAType= UrbanRur= cd106= cd108= sldu= sldl= vtd= vtdi= ZCTA3=219 ZCTA5=219HH SubMCD= AreaLand=0 AreaWatr=176715298 FuncStat=S gcuni= Pop100=0 HU100=0 IntPtLat=39.571786 IntPtLon=-75.871185 LSADC=Z5 PartFlag= SDElm= SDSec= SDUni= TAZ= UGA= PUMA5= PUMA1= MACC= UACP= tract= _arg= _badsl=0 LandSQMI=0.00 AreaSQMI=68.23 _lgeocode=5 _maxl=24 _i=. nomorepumas=0 _logrecnopuma=500000 _ERROR_=1 _N_=459803 NOTE: Invalid argument to function ZIPFIPS at line 200 column 14. 461482 uSF3 US86000000 0461482 101 268268HH 0 4117576 201 268HH 5-Digit ZCTA S 301 0 0+39061639-078990194Z5 400 last=0 _first=1 GeoCode=268HH SumLev=860 GeoComp=00 AreaName=268HH 5-Digit ZCTA geoid=86000US268HH State=. Stab=. County= FileId=uSF3 stusab=US LogRecNo=461482 Region= Division= StateCe= Cnty= CntySC= CouSubFP= CouSubCC= CouSubSC= PlaceFP= PlaceCC= PlaceDC= PlaceSC= _TractIn= BG= Block= ConCit= aianhh= aianhhfp= aianhhcc= aihhtli= aitsce= aits= aitscc= anrc= anrccc= MSACMSA= MASC= CMSA2= MACCI= PMSA= NECMA= UA= UASC= UAType= UrbanRur= cd106= cd108= sldu= sldl= vtd= vtdi= ZCTA3=268 ZCTA5=268HH SubMCD= AreaLand=0 AreaWatr=4117576 FuncStat=S gcuni= Pop100=0 HU100=0 IntPtLat=39.061639 IntPtLon=-78.990194 LSADC=Z5 PartFlag= SDElm= SDSec= SDUni= TAZ= UGA= PUMA5= PUMA1= MACC= UACP= tract= _arg= _badsl=0 LandSQMI=0.00 AreaSQMI=1.59 _lgeocode=5 _maxl=24 _i=. nomorepumas=0 _logrecnopuma=500000 _ERROR_=1 _N_=461482 NOTE: Invalid argument to function ZIPFIPS at line 200 column 14. 461483 uSF3 US86000000 0461483 101 268268XX 140817982 30828 201 268XX 5-Digit ZCTA S 301 8 36+38878991-079462926Z5 400 8 The SAS System 09:23 Thursday, September 24, 2009 last=0 _first=1 GeoCode=268XX SumLev=860 GeoComp=00 AreaName=268XX 5-Digit ZCTA geoid=86000US268XX State=. Stab=. County= FileId=uSF3 stusab=US LogRecNo=461483 Region= Division= StateCe= Cnty= CntySC= CouSubFP= CouSubCC= CouSubSC= PlaceFP= PlaceCC= PlaceDC= PlaceSC= _TractIn= BG= Block= ConCit= aianhh= aianhhfp= aianhhcc= aihhtli= aitsce= aits= aitscc= anrc= anrccc= MSACMSA= MASC= CMSA2= MACCI= PMSA= NECMA= UA= UASC= UAType= UrbanRur= cd106= cd108= sldu= sldl= vtd= vtdi= ZCTA3=268 ZCTA5=268XX SubMCD= AreaLand=140817982 AreaWatr=30828 FuncStat=S gcuni= Pop100=8 HU100=36 IntPtLat=38.878991 IntPtLon=-79.462926 LSADC=Z5 PartFlag= SDElm= SDSec= SDUni= TAZ= UGA= PUMA5= PUMA1= MACC= UACP= tract= _arg= _badsl=0 LandSQMI=54.37 AreaSQMI=54.38 _lgeocode=5 _maxl=24 _i=. nomorepumas=0 _logrecnopuma=500000 _ERROR_=1 _N_=461483 NOTE: Invalid argument to function ZIPFIPS at line 200 column 14. RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0 462312 uSF3 US86000000 0462312 101 289289HH 0 29533315 201 289HH 5-Digit ZCTA S 301 0 0+35092382-084074013Z5 400 last=0 _first=1 GeoCode=289HH SumLev=860 GeoComp=00 AreaName=289HH 5-Digit ZCTA geoid=86000US289HH State=. Stab=. County= FileId=uSF3 stusab=US LogRecNo=462312 Region= Division= StateCe= Cnty= CntySC= CouSubFP= CouSubCC= CouSubSC= PlaceFP= PlaceCC= PlaceDC= PlaceSC= _TractIn= BG= Block= ConCit= aianhh= aianhhfp= aianhhcc= aihhtli= aitsce= aits= aitscc= anrc= anrccc= MSACMSA= MASC= CMSA2= MACCI= PMSA= NECMA= UA= UASC= UAType= UrbanRur= cd106= cd108= sldu= sldl= vtd= vtdi= ZCTA3=289 ZCTA5=289HH SubMCD= AreaLand=0 AreaWatr=29533315 FuncStat=S gcuni= Pop100=0 HU100=0 IntPtLat=35.092382 IntPtLon=-84.074013 LSADC=Z5 PartFlag= SDElm= SDSec= SDUni= TAZ= UGA= PUMA5= PUMA1= MACC= UACP= tract= _arg= _badsl=0 LandSQMI=0.00 AreaSQMI=11.40 _lgeocode=5 _maxl=24 _i=. nomorepumas=0 _logrecnopuma=500000 _ERROR_=1 _N_=462312 NOTE: Invalid argument to function ZIPFIPS at line 200 column 14. ERROR: Limit set by ERRORS= option reached. Further errors of this type will not be printed. 462745 uSF3 US86000000 0462745 101 299299HH 0 868314989 201 299HH 5-Digit ZCTA S 301 0 0+32352170-080737556Z5 400 last=0 _first=1 GeoCode=299HH SumLev=860 GeoComp=00 AreaName=299HH 5-Digit ZCTA geoid=86000US299HH State=. Stab=. County= FileId=uSF3 stusab=US LogRecNo=462745 Region= Division= StateCe= Cnty= CntySC= CouSubFP= CouSubCC= CouSubSC= PlaceFP= PlaceCC= PlaceDC= PlaceSC= _TractIn= BG= Block= ConCit= aianhh= aianhhfp= aianhhcc= aihhtli= aitsce= aits= aitscc= anrc= anrccc= MSACMSA= MASC= CMSA2= MACCI= PMSA= NECMA= UA= UASC= UAType= UrbanRur= cd106= cd108= sldu= sldl= vtd= vtdi= ZCTA3=299 ZCTA5=299HH SubMCD= AreaLand=0 AreaWatr=868314989 FuncStat=S gcuni= Pop100=0 HU100=0 IntPtLat=32.352170 IntPtLon=-80.737556 LSADC=Z5 PartFlag= SDElm= SDSec= SDUni= TAZ= UGA= PUMA5= PUMA1= MACC= UACP= tract= _arg= _badsl=0 LandSQMI=0.00 AreaSQMI=335.26 _lgeocode=5 _maxl=24 _i=. nomorepumas=0 _logrecnopuma=500000 _ERROR_=1 _N_=462745 last=1 _first=1 GeoCode=999XX SumLev=860 GeoComp=00 AreaName=999XX 5-Digit ZCTA geoid=86000US999XX State=. Stab=. County= FileId=uSF3 stusab=US LogRecNo=487093 Region= Division= StateCe= Cnty= CntySC= CouSubFP= CouSubCC= CouSubSC= PlaceFP= PlaceCC= PlaceDC= PlaceSC= _TractIn= BG= Block= ConCit= aianhh= aianhhfp= aianhhcc= aihhtli= aitsce= aits= aitscc= anrc= anrccc= MSACMSA= MASC= CMSA2= MACCI= PMSA= NECMA= UA= UASC= UAType= UrbanRur= cd106= cd108= sldu= sldl= vtd= vtdi= ZCTA3=999 ZCTA5=999XX SubMCD= AreaLand=22748606833 AreaWatr=186337834 FuncStat=S gcuni= Pop100=424 HU100=448 IntPtLat=55.616026 IntPtLon=-132.549366 LSADC=Z5 PartFlag= SDElm= SDSec= SDUni= TAZ= UGA= PUMA5= PUMA1= MACC= UACP= tract= _arg= _badsl=0 LandSQMI=8783.29 AreaSQMI=8855.23 _lgeocode=5 _maxl=24 _i=. nomorepumas=0 _logrecnopuma=500000 _ERROR_=1 _N_=487093 NOTE: 487093 records were read from the infile GEOS. The minimum record length was 400. The maximum record length was 400. NOTE: Mathematical operations could not be performed at the following places. The results of the operations have been set to missing values. Each place is given by: (Number of times) at (Line):(Column). 70 at 200:14 NOTE: There were 2071 observations read from the data set SF3.USPUMASPH. NOTE: The data set SF32000.USGEOS has 282389 observations and 63 variables. NOTE: Compressing data set SF32000.USGEOS decreased size by 50.81 percent. Compressed is 2241 pages; un-compressed would require 4556 pages. NOTE: The data set SF32000.USGEOCOMPGEOS has 206775 observations and 63 variables. NOTE: Compressing data set SF32000.USGEOCOMPGEOS decreased size by 57.79 percent. Compressed is 1408 pages; un-compressed would require 3336 pages. NOTE: DATA statement used (Total process time): 9 The SAS System 09:23 Thursday, September 24, 2009 real time 1:16.92 cpu time 1:10.72 235 236 237 proc print data=sf3.usgeos(obs=150); *by sumlev; id logrecno; run; NOTE: There were 150 observations read from the data set SF3.USGEOS. NOTE: At least one W.D format was too small for the number to be printed. The decimal may be shifted by the "BEST" format. NOTE: The PROCEDURE PRINT printed pages 1-15. NOTE: PROCEDURE PRINT used (Total process time): real time 0.08 seconds cpu time 0.07 seconds 238 239 240 proc freq data=sf32000.usgeos(keep=state sumlev); 241 table state sumlev; 242 run; NOTE: There were 282389 observations read from the data set SF32000.USGEOS. NOTE: The PROCEDURE FREQ printed pages 16-19. NOTE: PROCEDURE FREQ used (Total process time): real time 2.83 seconds cpu time 2.76 seconds 243 244 proc datasets library=sf32000 nolist; 245 modify usgeos; 246 index create slgeo=(sumlev geocode); NOTE: Composite index slgeo has been defined. 247 index create geoid; NOTE: Simple index geoid has been defined. 248 index create logrecno; NOTE: Simple index LogRecNo has been defined. 249 quit; NOTE: MODIFY was successful for SF32000.USGEOS.DATA. NOTE: PROCEDURE DATASETS used (Total process time): real time 13.24 seconds cpu time 15.56 seconds 250 251 252 253 %include sascode(notify); *<==========Missouri only, delete everywhere else!!!=====; 0 **** usgeos (622684) has completed 24SEP09 9:24:39 syserr=0 sysrc= 0 ***** ERROR: Errors printed on page 8. NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414 10 The SAS System 09:23 Thursday, September 24, 2009 NOTE: The SAS System used: real time 1:33.67 cpu time 1:29.37