1 The SAS System 14:38 Wednesday, June 17, 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.80 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 Wednesday 17JUN09 at 14:38 PID=270384 NOTE: AUTOEXEC processing completed. 1 x cd /pub/data/sf32000/Tools 1 ! ; %let pgm=cnvtsf3us; filename pgm "&pgm..sas"; *<====mo only===; 2 The SAS System 14:38 Wednesday, June 17, 2009 2 3 ****NOTES: 6/09 4 1. We may need to reconvert the geocomps to keep only a few sumlevs. Otherwise way too big. Down to state is enuf. 4 ! We 5 currently only have the ph tables for the geocomps. Not sure why but suspect it was due to lack of space. 6 2. Want to convert data for mcds (county subs, 060), metros and possibly a catchall others, which might or might not 6 ! include CDs. 7 3. We run a post-processor setup that merges the data sets created here to create a single data set with all 3 types of 7 ! tables. I.e. 8 instead of usstcntyph, usstcntyphct and usstcntyphctr we just get uscnty. We also add indices in that setup. 9 4. There is a program in W:\mcdc\data\Tools\download_data.sas that copies the original sets of 3 ph,phct and phctr 9 ! data sets down to 10 a directory on the "w" drive. Which is really the "mcdc3" Windows machine in 626 Clark (my office). 11 5. We may want to add a geoid variable at some point. We need something that can used as a key (based on geocodes, not 11 ! logrecno) so t 12 that we can do relatively fast where-filter access in the sf3tabgen2 web app. 13 This has gotten a bit more complicated than we wanted or expected. 14 ******; 15 16 /*--This setup is a variation on the one in cnvtsf3.sas. We used that setup to convert state data sets, we use this 17 one for the national datasets. jgb, march, 2009. 18 (after the recovery). 19 */ 20 21 %let curpath=%str(/pub/data/sf32000/Tools/); 22 %let ucstab=US; 23 %let inpath=%str(/pub/data/sf32000/rawdata); *<===path (directory) where the input raw data is stored---*; 24 25 filename curpath "&curpath"; *<===points to current directory. We shall do some %include s below that 26 reference sas label-statement modules in the same directory as the current program.--; 27 28 29 libname sf32000 "/pub/data/sf32000"; NOTE: Libref SF32000 was successfully assigned as follows: Engine: V9 Physical Name: /pub/data/sf32000 30 libname sf3 (sf32000); NOTE: Libref SF3 was successfully assigned as follows: Levels: 1 Engine(1): V9 Physical Name(1): /pub/data/sf32000 30 ! *---alias name--; 31 %*let maxobs=999999; *<=======while testing, limits processing to this many input recs==; 32 33 %let filesfx=uf3; %*<---does not vary as it did with sf2--; 34 35 *filename geos "&inpath/usgeo._&filesfx"; *<====assumes you have unzipped the .zip file with this inside; 36 filename geos pipe "unzip -a -p &inpath/usgeo_&filesfx"; 37 38 /* =======================Begin comment================ 39 *---Create a data set that tells us how many obs we have for each sumlev and where the first and last 40 obs are for each.---; 41 data sf3.sumlevs; 42 infile geos lrecl=2048 obs=max; *** 10000; 43 input sumlev $9-11 geocomp $12-13; 44 length obsno 5; obsno=_n_; 3 The SAS System 14:38 Wednesday, June 17, 2009 45 if geocomp='00' then TotalSums=1; else GeocompSums=1; 46 sumlev_code=sumlev; 47 format sumlev $sumlev64.; 48 run; 49 proc sort; by sumlev; run; 50 51 proc means data=sf3.sumlevs noprint; 52 by sumlev; format sumlev $3.; 53 id sumlev_code; 54 var obsno TotalSums GeocompSums; 55 output out=sf3.sumlev_means(drop=_type_ _freq_) n=TotalObs Geocomp00 GeocompXX min=FirstObs max=LastObs; 56 run; 57 proc print data=sf3.sumlev_means; 58 title2 'sf3.sumlev_means'; 59 id sumlev_code sumlev; 60 format sumlev $sumlev64.; 61 run; 62 ======================End comment================== */ 63 64 65 66 67 x cd &inpath; *<---make it the current directory--; 68 69 %macro concatd(g1,g2,g3,g4,g5,g6,g7,g8); %*--utility macro used to create geocode values-; 70 %*--utility macro to return a SAS expression that will be the concatenation of specified char variables 71 separated by dashes-; 72 %local dash gc; %let dash=%str(||'-'||); 73 %*--we build the value of local variable gc which is then "returned" as the result of invoking the macro-; 74 %let gc=&g1; %if &g2= %then %goto rtrn; 75 %let gc=&gc&dash&g2; %if &g3= %then %goto rtrn; 76 %let gc=&gc&dash&g3; %if &g4= %then %goto rtrn; 77 %let gc=&gc&dash&g4; %if &g5= %then %goto rtrn; 78 %let gc=&gc&dash&g5; %if &g6= %then %goto rtrn; 79 %let gc=&gc&dash&g6; %if &g7= %then %goto rtrn; 80 %let gc=&gc&dash&g7; %if &g8= %then %goto rtrn; 81 %let gc=&gc&dash&g8; 82 %rtrn: 83 &gc 84 %mend concatd; 85 86 %macro docnvt(set=,sumlevs=,idvars=,indices=,geocomps=0); 87 proc printto print = "/pub/data/sf32000/Tools/&pgm&set..lst" new; run; 88 89 title "Conversion of 2000 Summary File 3 Data for us&set"; 90 %global firstobs maxobs; 91 *---access the above-generated sumlev_means data set to dtermine the first and last observations we shall need to 91 ! access-; 92 proc means data=sf3.sumlev_means; 93 where index("&sumlevs",sumlev); 94 var firstobs lastobs; 95 output out=minmaxobs min=minobs minlast max=maxfirst maxobs; 96 run; 97 data _null_; 98 set minmaxobs; put _all_; 99 call symput('firstobs',left(put(minobs,7.))); 4 The SAS System 14:38 Wednesday, June 17, 2009 100 call symput('maxobs',left(put(maxobs,7.))); 101 run; 102 %put _global_; 103 104 105 data 106 sf32000.us&set.geos (compress=yes sortedby=LogRecNo label="2000 Summary File 3 (SF3) Geo Headers data for US &set" 107 keep=geocode--AreaSQMI PCT) 108 sf32000.us&set.ph(compress=yes sortedby=LogRecNo label="2000 sf3 P & H Tables for US &set" keep=geocode--AreaSQMI 109 PCT P1i1--P160Ii41 H1i1--H121i7) 110 sf32000.us&set.phct(compress=yes sortedby=LogRecNo label="2000 sf3 PCT & HCT tables exc PCTr for US &set" 110 ! keep=geocode--AreaSQMI 111 PCT1i1--PCT61i81 HCT1i1--HCT28i13) 112 sf32000.us&set.phctR(compress=yes sortedby=LogRecNo label="2000 sf3 PCT & HCT Tables by Race for US &set" 112 ! keep=geocode--AreaSQMI 113 PCT62Ai1--PCT76Ii29 HCT29Ai1--HCT48Ii3) 114 ; 115 116 117 infile geos missover lrecl=1024 firstobs=&firstobs obs=&maxobs; 118 retain _first 1; drop _first; 119 length GeoCode $44 SumLev $3 GeoComp $2 AreaName $90; *--establish variable order -- these go first--; 120 retain State " " Stab " "; length County $5 ; *--and then these... -; 121 format county $county.; 122 if _first then do; 123 input FileId $char6. stusab $2. @; retain FileId stusab; drop fileid stusab; 124 if substr(FileId,2,3) ne 'SF3' then do; 125 file log; put '******Problem with input geographic headers file. Did not find "SF3" in cols. 2-4 ' FileId= / 126 '***Conversion will not run***'; 127 list; 128 stop; 129 end; 130 end; 131 132 input 133 @9 SumLev $3. geocomp $2. 134 @19 LogRecNo 7. 135 @26 Region $1. Division $1. StateCe $2. State $2. Cnty $3. CntySC $2. 136 @37 CouSubFP $5. CouSubCC $2. CouSubSC $2. PlaceFP $5. PlaceCC $2. PlaceDC $1. PlaceSC $2. 137 @56 TractIn $6. BG $1. Block $4. @69 ConCit $5. 138 @78 aianhh $char4. aianhhfp $char5. aianhhcc $char2. aihhtli $1. aitsce $char3. aits $char5. aitscc $char2. 139 anrc $char5. anrccc $char2. 140 @107 MSACMSA $4. MASC $2. CMSA2 $2. MACCI $1. PMSA $4. NECMA $4. 141 @128 UA $5. UASC $2. UAType $1. 142 @136 UrbanRur $1. cd106 $2. cd108 $2. +4 (sldu sldl)($char3.) vtd $char6. vtdi $1. 143 @158 ZCTA3 $3. ZCTA5 $5. 144 @168 SubMCD $5. 145 @173 (AreaLand AreaWatr)(14.) AreaName $90. FuncStat $1. gcuni $1. 146 @293 Pop100 9. HU100 9. IntPtLat 9.6 IntPtLon 10.6 LSADC $2. 147 @332 PartFlag $1. (SDElm SDSec SDUni)($5.) TAZ $6. UGA $5. PUMA5 $5. PUMA1 $5. 148 @384 MACC $char5. UACP $char5. ; 149 150 if index("&sumlevs",sumlev) then _keep=1; else _keep=0; retain _keep; 151 *--the geocomps parms tells us how to handle geographic component summaries. The default value, 0, 152 says to skip and geo componnents. A value of 2 means to keep ONLY geographic components. Any 153 other value - like 1 - says to keep them but only if sumlevs indicates a keeper.---; 5 The SAS System 14:38 Wednesday, June 17, 2009 154 155 if &geocomps=0 then _keep=_keep and (geocomp='00'); 156 else if &geocomps=2 then _keep=(geocomp ne "00"); 157 else _keep= _keep and (geocomp ne '00'); 158 159 if _keep=0 then goto aftergeoprocessing; 160 161 if cnty ne ' ' then County=state||cnty; 162 *--edit the tract so that it is in xxxx.xx format with leading and trailing zeroes--; 163 if TractIn ne ' ' then Tract=translate( substr(TractIn,1,4)||'.'||substr(TractIn,5,2) ,'0',' '); 164 drop tractin; 165 166 select(SumLev); *---Assign the standardized Geographic Code to uniquely ID the geographic area--; 167 when('010') geocode=' '; 168 when('020') geocode=region; 169 when('030') geocode=division; 170 when('040') geocode=state; 171 when('050') geocode=county; 172 when('060') geocode=%concatd(county,cousubfp); 173 when('070') geocode=%concatd(county,cousubfp,placefp); 174 when('080') geocode=%concatd(county,cousubfp,placefp,tract); 175 when('085') do; 176 geocode=%concatd(county,cousubfp,placefp,tract,UrbanRur); 177 Areaname = "Census Tract "||tract||" ("||TRIM(areaname)||" part)" ; 178 end; 179 when('090') geocode=%concatd(county,cousubfp,placefp,tract,UrbanRur,bg); 180 when('067') geocode=%concatd(county,cousubfp,SubMCD); 181 182 when('140') geocode=%concatd(county,tract); 183 when('144') geocode=%concatd(county,tract,aianhhfp); 184 when('150') geocode=%concatd(county,tract,bg); 185 when('154') geocode=%concatd(county,tract,bg,aianhhfp); 186 when('155') do; 187 geocode=%concatd(county,placefp); 188 189 *<===Override areaname to make it the name of the place rather than the county.To leave as-is delete this + next 4 189 ! lines; 190 length _arg $7; _arg=state||placefp; 191 drop _arg; 192 areaname=put(_arg,$fplace.); 193 if areaname=_arg then areaname='Place '||placefp; 194 195 end; 196 when('158') geocode=%concatd(state,placefp,cnty,tract); 197 when('160') geocode=%concatd(state,placefp); 198 when('170') geocode=%concatd(state,concit); 199 when('172') geocode=%concatd(state,concit,placefp); 200 when('250') geocode=aianhh; 201 when('260') geocode=%concatd(aianhhfp,state); 202 when('270') geocode=%concatd(aianhhfp,cnty); 203 when('271') geocode=%concatd(aianhhfp,cnty,cousubfp); 204 when('273') geocode=%concatd(aianhhfp,cnty,cousubfp,placefp); 205 206 when('252') geocode=aianhh; 207 when('262') geocode=%concatd(aianhhfp,state); 208 when('272') geocode=%concatd(aianhhfp,cnty); 6 The SAS System 14:38 Wednesday, June 17, 2009 209 when('275') geocode=%concatd(aianhhfp,cnty,cousubfp); 210 when('276') geocode=%concatd(aianhhfp,cnty,cousubfp,placefp); 211 212 when('254') geocode=aianhh; 213 when('264') geocode=%concatd(aianhhfp,state); 214 when('274') geocode=%concatd(aianhhfp,cnty); 215 when('277') geocode=%concatd(aianhhfp,cnty,cousubfp); 216 when('278') geocode=%concatd(aianhhfp,cnty,cousubfp,placefp); 217 218 when('256','291','292') geocode=%concatd(aianhhfp,tract); 219 when('258','293','294') geocode=%concatd(aianhhfp,tract,bg); 220 221 when('251','253','255') geocode=%concatd(aianhhfp,aits); 222 when('257') geocode=%concatd(aianhhfp,aits,tract); 223 when('259') geocode=%concatd(aianhhfp,aits,tract,bg); 224 when('290') geocode=%concatd(aianhhfp,aits,state); 225 226 227 when('280','283','286') geocode=%concatd(state,aianhhfp); 228 when('282','285','288') geocode=%concatd(state,aianhhfp,cnty); 229 when('261','265','267') geocode=%concatd(state,aianhhfp,cnty,cousubfp); 230 when('263','266','268') geocode=%concatd(state,aianhhfp,cnty,cousubfp,placefp); 231 when('281','284','287') geocode=%concatd(state,aianhhfp,aits); 232 when('230') geocode=%concatd(state,anrc); 233 when('380') geocode=msacmsa; 234 when('381') geocode=%concatd(msacmsa,state); 235 when('382') geocode=%concatd(msacmsa,state,placefp); 236 when('383') geocode=%concatd(msacmsa,state,cnty); 237 when('384') geocode=%concatd(msacmsa,state,cousubfp); 238 when('385') geocode=pmsa; 239 when('386') geocode=%concatd(pmsa,state); 240 when('387') geocode=%concatd(pmsa,state,cnty); 241 when('388') geocode=%concatd(pmsa,state,cousubfp); 242 243 when('370') geocode=necma; 244 when('371') geocode=%concatd(necma,state); 245 when('372') geocode=%concatd(necma,state,placefp); 246 when('373') geocode=%concatd(necma,state,cnty); 247 248 249 when('390') geocode=%concatd(state,msacmsa); 250 when('391') geocode=%concatd(state,msacmsa,placefp); 251 when('392') geocode=%concatd(state,msacmsa,cnty); 252 when('393') geocode=%concatd(state,msacmsa,cnty,cousubfp); 253 when('395') geocode=%concatd(state,msacmsa,pmsa); 254 when('396') geocode=%concatd(state,msacmsa,pmsa,cnty); 255 when('397') geocode=%concatd(state,msacmsa,pmsa,cnty,cousubfp); 256 when('374') geocode=%concatd(state,necma); 257 when('375') geocode=%concatd(state,necma,placefp); 258 when('376') geocode=%concatd(state,necma,cnty); 259 when('400') geocode=UA; 260 *---the following 7 When clauses treat the SumLev pairs as equivalents. The only "difference" is the order of the 260 ! variables. 261 On a state level file 420 is State-UA, while on the national file it is UA-State. For assigning geocode, we treat 262 them as the same and always put UA ahead of state.--; 263 when('410','420') geocode=%concatd(UA,state); 7 The SAS System 14:38 Wednesday, June 17, 2009 264 when('430','431') geocode=%concatd(UA,state,cnty); 265 when('440','441') geocode=%concatd(UA,state,cnty,cousubfp); 266 when('450','451') geocode=%concatd(UA,state,cnty,cousubfp,placefp); 267 when('460','461') geocode=%concatd(UA,state,placefp); 268 when('462','463') geocode=%concatd(UA,state,concit); 269 when('464','465') geocode=%concatd(UA,state,concit,placefp); 270 271 when('500') geocode=%concatd(state,cd106); 272 when('510') geocode=%concatd(state,cd106,cnty); 273 when('511') geocode=%concatd(state,cd106,cnty,tract); 274 when('521') geocode=%concatd(state,cd106,cnty,cousubfp); 275 when('531') geocode=%concatd(state,cd106,placefp); 276 when('541') geocode=%concatd(state,cd106,concit,placefp); 277 when('550','551','552') geocode=%concatd(state,cd106,aianhhfp); 278 when('553','554','555') geocode=%concatd(state,cd106,aianhhfp,aits); 279 when('850') geocode=zcta3; 280 when('860') geocode=zcta5; 281 282 283 when('851') geocode=%concatd(state,zcta3); 284 when('852') geocode=%concatd(state,zcta3,cnty); 285 when('871') geocode=%concatd(state,zcta5); 286 when('881') geocode=%concatd(state,zcta5,cnty); 287 288 otherwise do; 289 if sumlev ne lag(sumlev) then do; 290 _badsl+1; drop _badsl; 291 if _badsl le 50 then put '**Unrecognized SUMLEV: ' sumlev; 292 end; 293 end; 294 end; *--select group--; 295 geocode=compress(geocode,' '); *---remove any blanks from geocode---; 296 297 if state=' ' then stab=' '; 298 else stab=put(state,$fipstab.); *<====requires the $fipstab format code be defined. 299 See http://mcdc2.missouri.edu/sastools/sas_formats/Sfipstab.sas --; 300 301 *--Create land and total area values in square miles. --; 302 LandSQMI=AreaLand/2589988; AreaSQMI=LandSQMI + (AreaWatr/2589988); 303 format LandSQMI AreaSQMI 9.2; 304 format IntPtLon 11.6 IntPtLat 10.6; *<--added 7-13-01-; 305 306 label SumLev='Geographic Summary Level' GeoComp='Geographic Component'; 307 label cnty='County code'; 308 label LandSQMI='Land Area Sq Mls' AreaSQMI='Total Area Sq Mls' 309 AreaLand='Land Area Sq Meters' AreaWatr='Water Area Sq Meters'; 310 label cd106='Cong District - 106th (1998)' sldu='State Leg District Upper Chbr' 311 sldl='State Leg District Lower Chbr'; 312 label ZCTA5='ZIP Census Tabulation Area'; 313 314 *---For processing zip codes on the national files we assign the "primary" state code associated with the zip or 315 zip center (zcta5 or zcta3) using the builtin SAS functions zipfips and zipstate--; 316 if sumlev in ('850','860') then do; 317 length _ziparg $5 ; 318 if sumlev='850' then _ziparg=zcta3||'01'; else _ziparg=zcta5; 319 if sumlev='860' and substr(zcta5,4,2) in ("XX","HH") then _ziparg=substr(zcta5,1,3)||'01'; 8 The SAS System 14:38 Wednesday, June 17, 2009 320 state= put ( zipfips(_ziparg), z2. ); 321 stab = lowcase ( zipstate(_ziparg) ); 322 if stab=' ' then do; 323 _error_=0; 324 file log; _nziperr+1; 325 if _nziperr=1 then put '****ZIP codes not assigned to states****'; 326 put +2 _ziparg $5. @@; 327 end; 328 drop _ziparg _nziperr; 329 end; 330 aftergeoprocessing: 331 _first=0; ****************************************************; 332 *--Set flag to indicate whether this geographic summary level will have data for the CT tables--; 333 _readCT= ( sumlev not in ('Z85','090','150','154') ); *<--note that 085, tract/UR is NOT!(now) considered sub-tract-; 334 attrib PCT length=3 format=1. label='PCT /HCT data flag'; 335 336 PCT=_readCT; *<--------save the flag on the geos data set-------------------------; 337 drop _keep _readCT; 338 *---Use length statements to set up the variables in order in the PDV (program data vector). Then we can 339 used "double-dash" variable intervals in the input statements and SAS will know 340 which variables are in those intervals----*; 341 342 %*--assign the macro vars containing the first and last variables in each input file--; 343 *<=============================Parm assignment code starts here============================; 344 length P1i1 P2i1 P3i1 P4i1 P5i1-P5i7 P6i1-P6i8 P7i1-P7i17 P8i1-P8i79 P9i1-P9i27 P10i1-P10i19 P11i1-P11i21 345 P12i1-P12i31 P13i1-P13i19 P14i1-P14i16 5; 346 %let fvar1=P1i1; %let lvar1=P14i16; %let nvar1=248; 347 348 length P15i1-P15i20 P16i1-P16i26 P17i1-P17i20 P18i1-P18i19 P19i1-P19i67 P20i1-P20i14 P21i1-P21i15 349 P22i1-P22i9 P23i1-P23i10 P24i1-P24i18 5; 350 %let fvar2=P15i1; %let lvar2=P24i18; %let nvar2=218; 351 352 length P25i1-P25i35 P26i1-P26i5 P27i1-P27i5 P28i1-P28i25 P29i1-P29i5 P30i1-P30i16 353 P31i1-P31i15 P32i1-P32i13 P33i1-P33i13 P34i1-P34i17 P35i1-P35i10 P36i1-P36i47 P37i1-P37i35 5; 354 %let fvar3=P25i1; %let lvar3=P37i35; %let nvar3=241; 355 356 length P38i1-P38i22 P39i1-P39i23 P40i1-P40i21 P41i1-P41i19 P42i1-P42i49 P43i1-P43i15 357 P44i1-P44i29 P45i1-P45i22 P46i1-P46i27 5; 358 %let fvar4=P38i1; %let lvar4=P46i27; %let nvar4=227; 359 360 length P47i1-P47i49 P48i1-P48i21 P49i1-P49i55 P50i1-P50i95 5; 361 %let fvar5=P47i1 ; %let lvar5=P50i95; %let nvar5=220; 362 363 length P51i1-P51i65 P52i1-P52i17 P53i1 P54i1-P54i3 P55i1-P55i120 364 P56i1-P56i8 P57i1-P57i8 P58i1-P58i3 P59i1-P59i3 P60i1-P60i3 365 P61i1-P61i3 P62i1-P62i3 P63i1-P63i3 P64i1-P64i3 P65i1-P65i3 366 P66i1-P66i3 P67i1 5; 367 %let fvar6=P51i1; %let lvar6=P67i1; %let nvar6=250; 368 369 length P68i1 P69i1 P70i1 P71i1 P72i1 P73i1 P74i1 P75i1 P76i1-P76i17 370 P77i1 P78i1-P78i3 P79i1-P79i17 P80i1 P81i1-P81i3 P82i1 P83i1 P84i1-P84i43 371 P85i1-P85i3 P86i1-P86i3 P87i1-P87i17 P88i1-P88i10 P89i1-P89i39 372 P90i1-P90i41 P91i1-P91i5 5; 373 %let fvar7=P68i1; %let lvar7=P91i5; %let nvar7=213; 374 375 length P92i1-P92i59 P93i1-P93i19 P94i1-P94i3 9 The SAS System 14:38 Wednesday, June 17, 2009 376 P95i1-P95i3 P96i1-P96i3 P97i1-P97i3 P98i1-P98i3 P99i1-P99i3 377 P100i1-P100i3 P101i1-P101i3 P102i1-P102i5 P103i1-P103i7 378 P104i1-P104i3 P105i1-P105i3 P106i1-P106i3 P107i1-P107i3 P108i1-P108i3 379 P109i1-P109i7 P110i1-P110i5 P111i1-P111i3 P112i1-P112i3 P113i1-P113i3 380 P114i1-P114i3 P115i1-P115i7 P116i1-P116i3 P117i1-P117i3 381 P118i1-P118i3 P119i1-P119i3 P120i1-P120i3 P121i1-P121i3 P122i1-P122i3 382 P123i1-P123i3 P124i1-P124i3 P125i1-P125i3 P126i1-P126i5 P127i1-P127i3 383 P128i1-P128i5 P129i1-P129i5 P130i1-P130i5 P131i1-P131i3 P132i1-P132i3 384 P133i1-P133i5 P134i1-P134i5 P135i1-P135i3 P136i1-P136i3 P137i1-P137i3 385 P138i1-P138i7 5; 386 %let fvar8=P92i1; %let lvar8=P138i7; %let nvar8=245; 387 388 length P139i1-P139i7 P140i1-P140i7 P141i1-P141i7 P142i1-P142i7 P143i1-P143i14 389 P144i1-P144i14 P145Ai1-P145Ai49 P145Bi1-P145Bi49 P145Ci1-P145Ci49 5; 390 %let fvar9=P139i1; %let lvar9=P145Ci49; %let nvar9=203; 391 392 length P145Di1-P145Di49 P145Ei1-P145Ei49 P145Fi1-P145Fi49 P145Gi1-P145Gi49 393 P145Hi1-P145Hi49 5; 394 %let fvar10=P145Di1; %let lvar10=P145Hi49; %let nvar10=245; 395 396 length P145Ii1-P145Ii49 P146Ai1-P146Ai31 P146Bi1-P146Bi31 P146Ci1-P146Ci31 397 P146Di1-P146Di31 P146Ei1-P146Ei31 P146Fi1-P146Fi31 5; 398 %let fvar11=P145Ii1; %let lvar11=P146Fi31; %let nvar11=235; 399 400 length P146Gi1-P146Gi31 P146Hi1-P146Hi31 P146Ii1-P146Ii31 P147Ai1-P147Ai17 401 P147Bi1-P147Bi17 P147Ci1-P147Ci17 P147Di1-P147Di17 P147Ei1-P147Ei17 402 P147Fi1-P147Fi17 P147Gi1-P147Gi17 P147Hi1-P147Hi17 P147Ii1-P147Ii17 5; 403 %let fvar12=P146Gi1; %let lvar12=P147Ii17; %let nvar12=246; 404 405 406 length P148Ai1-P148Ai17 P148Bi1-P148Bi17 P148Ci1-P148Ci17 P148Di1-P148Di17 407 P148Ei1-P148Ei17 P148Fi1-P148Fi17 P148Gi1-P148Gi17 P148Hi1-P148Hi17 408 P148Ii1-P148Ii17 P149Ai1-P149Ai22 P149Bi1-P149Bi22 P149Ci1-P149Ci22 409 P149Di1-P149Di22 5; 410 %let fvar13=P148Ai1; %let lvar13=P149Di22; %let nvar13=241; 411 412 length P149Ei1-P149Ei22 P149Fi1-P149Fi22 P149Gi1-P149Gi22 P149Hi1-P149Hi22 413 P149Ii1-P149Ii22 P150Ai1-P150Ai15 P150Bi1-P150Bi15 P150Ci1-P150Ci15 414 P150Di1-P150Di15 P150Ei1-P150Ei15 P150Fi1-P150Fi15 P150Gi1-P150Gi15 415 P150Hi1-P150Hi15 P150Ii1-P150Ii15 5; 416 %let fvar14=P149Ei1; %let lvar14=P150Ii15; %let nvar14=245; 417 418 length P151Ai1-P151Ai17 P151Bi1-P151Bi17 P151Ci1-P151Ci17 419 P151Di1-P151Di17 P151Ei1-P151Ei17 P151Fi1-P151Fi17 420 P151Gi1-P151Gi17 P151Hi1-P151Hi17 P151Ii1-P151Ii17 421 P152Ai1 P152Bi1 P152Ci1 P152Di1 P152Ei1 P152Fi1 P152Gi1 P152Hi1 P152Ii1 422 P153Ai1 P153Bi1 P153Ci1 P153Di1 P153Ei1 P153Fi1 P153Gi1 P153Hi1 P153Ii1 423 P154Ai1-P154Ai17 P154Bi1-P154Bi17 P154Ci1-P154Ci17 P154Di1-P154Di17 5; 424 %let fvar15=P151Ai1; %let lvar15=P154Di17; %let nvar15=239; 425 426 length P154Ei1-P154Ei17 P154Fi1-P154Fi17 P154Gi1-P154Gi17 P154Hi1-P154Hi17 P154Ii1-P154Ii17 427 P155Ai1 P155Bi1 P155Ci1 P155Di1 P155Ei1 P155Fi1 P155Gi1 P155Hi1 P155Ii1 428 P156Ai1 P156Bi1 P156Ci1 P156Di1 P156Ei1 P156Fi1 P156Gi1 P156Hi1 P156Ii1 429 P157Ai1 P157Bi1 P157Ci1 P157Di1 P157Ei1 P157Fi1 P157Gi1 P157Hi1 P157Ii1 430 P158Ai1 P158Bi1 P158Ci1 P158Di1 P158Ei1 P158Fi1 P158Gi1 P158Hi1 P158Ii1 431 P159Ai1-P159Ai17 P159Bi1-P159Bi17 P159Ci1-P159Ci17 P159Di1-P159Di17 10 The SAS System 14:38 Wednesday, June 17, 2009 432 P159Ei1-P159Ei17 P159Fi1-P159Fi17 P159Gi1-P159Gi17 5; 433 %let fvar16=P154Ei1; %let lvar16=P159Gi17; %let nvar16=240; 434 435 length P159Hi1-P159Hi17 P159Ii1-P159Ii17 P160Ai1-P160Ai41 P160Bi1-P160Bi41 436 P160Ci1-P160Ci41 P160Di1-P160Di41 P160Ei1-P160Ei41 5; 437 %let fvar17=P159Hi1; %let lvar17=P160Ei41; %let nvar17=239; 438 439 length P160Fi1-P160Fi41 P160Gi1-P160Gi41 P160Hi1-P160Hi41 P160Ii1-P160Ii41 5; 440 %let fvar18=P160Fi1; %let lvar18=P160Ii41; %let nvar18=164; 441 442 length PCT1i1-PCT1i7 PCT2i1-PCT2i15 PCT3i1-PCT3i29 PCT4i1-PCT4i6 PCT5i1-PCT5i11 443 PCT6i1-PCT6i6 PCT7i1-PCT7i163 PCT8i1-PCT8i10 5; 444 %let fvar19=PCT1i1; %let lvar19=PCT8i10; %let nvar19=247; 445 446 length PCT9i1-PCT9i16 PCT10i1-PCT10i83 PCT11i1-PCT11i8 PCT12i1-PCT12i45 447 PCT13i1-PCT13i17 PCT14i1-PCT14i28 PCT15i1-PCT15i7 5; 448 %let fvar20=PCT9i1; %let lvar20=PCT15i7; %let nvar20=204; 449 450 length PCT16i1-PCT16i111 PCT17i1-PCT17i111 5; 451 %let fvar21=PCT16i1; %let lvar21=PCT17i111; %let nvar21=222; 452 453 length PCT18i1-PCT18i109 PCT19i1-PCT19i126 5; 454 %let fvar22=PCT18i1; %let lvar22=PCT19i126; %let nvar22=235; 455 456 length PCT20i1-PCT20i104 PCT21i1-PCT21i24 PCT22i1-PCT22i43 457 PCT23i1-PCT23i39 PCT24i1-PCT24i23 5; 458 %let fvar23=PCT20i1; %let lvar23=PCT24i23; %let nvar23=233; 459 460 length PCT25i1-PCT25i83 PCT26i1-PCT26i101 PCT27i1-PCT27i49 5; 461 %let fvar24=PCT25i1; %let lvar24=PCT27i49; %let nvar24=233; 462 463 length PCT28i1-PCT28i49 PCT29i1-PCT29i49 PCT30i1-PCT30i49 PCT31i1-PCT31i43 PCT32i1-PCT32i31 5; 464 %let fvar25=PCT28i1; %let lvar25=PCT32i31; %let nvar25=235; %let nvar25=221; *<---override documentation; 465 466 length PCT33i1-PCT33i47 PCT34i1-PCT34i59 5; 467 %let fvar26=PCT33i1; %let lvar26=PCT34i59; %let nvar26 =106; 468 469 length PCT35i1-PCT35i185 PCT36i1-PCT36i7 PCT37i1-PCT37i29 5; 470 %let fvar27=PCT35i1; %let lvar27=PCT37i29; %let nvar27 =221; 471 472 length PCT38i1-PCT38i107 PCT39i1-PCT39i3 PCT40i1-PCT40i11 PCT41i1-PCT41i11 PCT42i1-PCT42i15 473 PCT43i1-PCT43i15 5; 474 %let fvar28=PCT38i1; %let lvar28=PCT43i15; %let nvar28 =162; 475 476 length PCT44i1-PCT44i95 PCT45i1-PCT45i6 PCT46i1-PCT46i95 PCT47i1-PCT47i6 PCT48i1-PCT48i3 5; 477 %let fvar29=PCT44i1; %let lvar29=PCT48i3; %let nvar29 =205; 478 479 length PCT49i1-PCT49i59 PCT50i1-PCT50i144 PCT51i1-PCT51i21 5; 480 %let fvar30=PCT49i1; %let lvar30=PCT51i21; %let nvar30 =224; 481 482 length PCT52i1-PCT52i29 PCT53i1-PCT53i43 PCT54i1-PCT54i3 PCT55i1-PCT55i107 PCT56i1-PCT56i23 5; 483 %let fvar31=PCT52i1; %let lvar31=PCT56i23; %let nvar31 =205; 484 485 length PCT57i1-PCT57i47 PCT58i1-PCT58i21 PCT59i1-PCT59i47 PCT60i1-PCT60i47 PCT61i1-PCT61i81 5; 486 %let fvar32=PCT57i1; %let lvar32=PCT61i81; %let nvar32 =243; 487 11 The SAS System 14:38 Wednesday, June 17, 2009 488 length PCT62Ai1-PCT62Ai22 PCT62Bi1-PCT62Bi22 PCT62Ci1-PCT62Ci22 PCT62Di1-PCT62Di22 489 PCT62Ei1-PCT62Ei22 PCT62Fi1-PCT62Fi22 PCT62Gi1-PCT62Gi22 PCT62Hi1-PCT62Hi22 490 PCT62Ii1-PCT62Ii22 PCT63Ai1-PCT63Ai15 PCT63Bi1-PCT63Bi15 PCT63Ci1-PCT63Ci15 5; 491 %let fvar33=PCT62Ai1; %let lvar33=PCT63Ci15; %let nvar33 =243; 492 493 length PCT63Di1-PCT63Di15 PCT63Ei1-PCT63Ei15 PCT63Fi1-PCT63Fi15 PCT63Gi1-PCT63Gi15 494 PCT63Hi1-PCT63Hi15 PCT63Ii1-PCT63Ii15 PCT64Ai1-PCT64Ai18 PCT64Bi1-PCT64Bi18 495 PCT64Ci1-PCT64Ci18 PCT64Di1-PCT64Di18 PCT64Ei1-PCT64Ei18 PCT64Fi1-PCT64Fi18 496 PCT64Gi1-PCT64Gi18 PCT64Hi1-PCT64Hi18 5; 497 %let fvar34=PCT63Di1; %let lvar34=PCT64Hi18; %let nvar34 =234; 498 499 length PCT64Ii1-PCT64Ii18 PCT65Ai1-PCT65Ai16 PCT65Bi1-PCT65Bi16 PCT65Ci1-PCT65Ci16 PCT65Di1-PCT65Di16 500 PCT65Ei1-PCT65Ei16 PCT65Fi1-PCT65Fi16 PCT65Gi1-PCT65Gi16 PCT65Hi1-PCT65Hi16 501 PCT65Ii1-PCT65Ii16 PCT66Ai1-PCT66Ai23 PCT66Bi1-PCT66Bi23 PCT66Ci1-PCT66Ci23 5; 502 %let fvar35=PCT64Ii1; %let lvar35=PCT66Ci23; %let nvar35 =231; 503 504 length PCT66Di1-PCT66Di23 PCT66Ei1-PCT66Ei23 PCT66Fi1-PCT66Fi23 PCT66Gi1-PCT66Gi23 PCT66Hi1-PCT66Hi23 505 PCT66Ii1-PCT66Ii23 PCT67Ai1-PCT67Ai19 PCT67Bi1-PCT67Bi19 PCT67Ci1-PCT67Ci19 PCT67Di1-PCT67Di19 506 PCT67Ei1-PCT67Ei19 5; 507 %let fvar36=PCT66Di1; %let lvar36=PCT67Ei19; %let nvar36 =233; 508 509 length PCT67Fi1-PCT67Fi19 PCT67Gi1-PCT67Gi19 PCT67Hi1-PCT67Hi19 510 PCT67Ii1-PCT67Ii19 PCT68Ai1-PCT68Ai49 PCT68Bi1-PCT68Bi49 PCT68Ci1-PCT68Ci49 5; 511 %let fvar37=PCT67Fi1; %let lvar37=PCT68Ci49; %let nvar37 =223; 512 513 514 length PCT68Di1-PCT68Di49 PCT68Ei1-PCT68Ei49 PCT68Fi1-PCT68Fi49 PCT68Gi1-PCT68Gi49 PCT68Hi1-PCT68Hi49 5; 515 %let fvar38=PCT68Di1; %let lvar38=PCT68Hi49; %let nvar38 =245; 516 517 length PCT68Ii1-PCT68Ii49 PCT69Ai1-PCT69Ai22 PCT69Bi1-PCT69Bi22 PCT69Ci1-PCT69Ci22 PCT69Di1-PCT69Di22 518 PCT69Ei1-PCT69Ei22 PCT69Fi1-PCT69Fi22 PCT69Gi1-PCT69Gi22 PCT69Hi1-PCT69Hi22 519 PCT69Ii1-PCT69Ii22 5; 520 %let fvar39=PCT68Ii1; %let lvar39=PCT69Ii22; %let nvar39 =247; 521 522 length PCT70Ai1-PCT70Ai27 PCT70Bi1-PCT70Bi27 PCT70Ci1-PCT70Ci27 PCT70Di1-PCT70Di27 523 PCT70Ei1-PCT70Ei27 PCT70Fi1-PCT70Fi27 PCT70Gi1-PCT70Gi27 PCT70Hi1-PCT70Hi27 524 PCT70Ii1-PCT70Ii27 5; 525 %let fvar40=PCT70Ai1; %let lvar40=PCT70Ii27; %let nvar40 =243; 526 527 length PCT71Ai1-PCT71Ai49 PCT71Bi1-PCT71Bi49 PCT71Ci1-PCT71Ci49 PCT71Di1-PCT71Di49 528 PCT71Ei1-PCT71Ei49 5; 529 %let fvar41=PCT71Ai1; %let lvar41=PCT71Ei49; %let nvar41 =245; 530 531 length PCT71Fi1-PCT71Fi49 PCT71Gi1-PCT71Gi49 PCT71Hi1-PCT71Hi49 532 PCT71Ii1-PCT71Ii49 5; 533 %let fvar42=PCT71Fi1; %let lvar42=PCT71Ii49; %let nvar42 =196; 534 535 length PCT72Ai1-PCT72Ai120 PCT72Bi1-PCT72Bi120 5; 536 %let fvar43=PCT72Ai1; %let lvar43=PCT72Bi120; %let nvar43 =240; 537 538 length PCT72Ci1-PCT72Ci120 PCT72Di1-PCT72Di120 5; 539 %let fvar44=PCT72Ci1; %let lvar44=PCT72Di120; %let nvar44 =240; 540 541 length PCT72Ei1-PCT72Ei120 PCT72Fi1-PCT72Fi120 5; 542 %let fvar45=PCT72Ei1; %let lvar45=PCT72Fi120; %let nvar45 =240; 543 12 The SAS System 14:38 Wednesday, June 17, 2009 544 length PCT72Gi1-PCT72Gi120 PCT72Hi1-PCT72Hi120 5; 545 %let fvar46=PCT72Gi1; %let lvar46=PCT72Hi120; %let nvar46 =240; 546 547 length PCT72Ii1-PCT72Ii120 PCT73Ai1-PCT73Ai95 5; 548 %let fvar47=PCT72Ii1; %let lvar47=PCT73Ai95; %let nvar47 =215; 549 550 length PCT73Bi1-PCT73Bi95 PCT73Ci1-PCT73Ci95 5; 551 %let fvar48=PCT73Bi1; %let lvar48=PCT73Ci95; %let nvar48 =190; 552 553 length PCT73Di1-PCT73Di95 PCT73Ei1-PCT73Ei95 5; 554 %let fvar49=PCT73Di1; %let lvar49=PCT73Ei95; %let nvar49 =190; 555 556 length PCT73Fi1-PCT73Fi95 PCT73Gi1-PCT73Gi95 5; 557 %let fvar50=PCT73Fi1; %let lvar50=PCT73Gi95; %let nvar50 =190; 558 559 length PCT73Hi1-PCT73Hi95 PCT73Ii1-PCT73Ii95 5; 560 %let fvar51=PCT73Hi1; %let lvar51=PCT73Ii95; %let nvar51 =190; 561 562 length PCT74Ai1-PCT74Ai6 PCT74Bi1-PCT74Bi6 PCT74Ci1-PCT74Ci6 PCT74Di1-PCT74Di6 563 PCT74Ei1-PCT74Ei6 PCT74Fi1-PCT74Fi6 PCT74Gi1-PCT74Gi6 PCT74Hi1-PCT74Hi6 564 PCT74Ii1-PCT74Ii6 PCT75Ai1-PCT75Ai59 PCT75Bi1-PCT75Bi59 PCT75Ci1-PCT75Ci59 5; 565 %let fvar52=PCT74Ai1; %let lvar52=PCT75Ci59; %let nvar52 =231; 566 567 length PCT75Di1-PCT75Di59 PCT75Ei1-PCT75Ei59 PCT75Fi1-PCT75Fi59 PCT75Gi1-PCT75Gi59 5; 568 %let fvar53=PCT75Di1; %let lvar53=PCT75Gi59; %let nvar53 =236; 569 570 length PCT75Hi1-PCT75Hi59 PCT75Ii1-PCT75Ii59 PCT76Ai1-PCT76Ai29 PCT76Bi1-PCT76Bi29 571 PCT76Ci1-PCT76Ci29 PCT76Di1-PCT76Di29 5; 572 %let fvar54=PCT75Hi1; %let lvar54=PCT76Di29; %let nvar54 =234; 573 574 length PCT76Ei1-PCT76Ei29 PCT76Fi1-PCT76Fi29 PCT76Gi1-PCT76Gi29 PCT76Hi1-PCT76Hi29 PCT76Ii1-PCT76Ii29 5; 575 %let fvar55=PCT76Ei1; %let lvar55=PCT76Ii29; %let nvar55 =145; 576 577 length H1i1 H2i1-H2i3 H3i1 H4i1-H4i2 H5i1-H5i7 H6i1-H6i3 H7i1-H7i3 H8i1-H8i7 578 H9i1-H9i8 H10i1-H10i17 H11i1-H11i17 H12i1-H12i3 H13i1-H13i3 H14i1-H14i21 579 H15i1-H15i3 H16i1-H16i8 H17i1-H17i17 H18i1-H18i3 5; 580 %let fvar56=H1i1; %let lvar56=H18i3; %let nvar56 =127; 581 582 length H19i1-H19i125 H20i1-H20i13 H21i1-H21i59 H22i1-H22i19 583 H23i1-H23i10 H24i1 H25i1 H26i1-H26i21 5; 584 %let fvar57=H19i1; %let lvar57=H26i21; %let nvar57 =249; 585 586 length H27i1-H27i3 H28i1-H28i3 H29i1-H29i7 H30i1-H30i11 H31i1-H31i11 H32i1-H32i23 587 H33i1-H33i23 H34i1-H34i10 H35i1 H36i1-H36i21 H37i1-H37i3 H38i1-H38i15 588 H39i1-H39i3 H40i1-H40i10 H41i1-H41i7 H42i1-H42i15 H43i1-H43i35 H44i1-H44i15 5; 589 %let fvar58=H27i1; %let lvar58=H44i15; %let nvar58 =216; 590 591 length H45i1-H45i35 H46i1-H46i3 H47i1-H47i3 H48i1-H48i7 H49i1-H49i43 H50i1-H50i3 592 H51i1-H51i7 H52i1-H52i7 H53i1-H53i13 H54i1-H54i24 593 H55i1 H56i1 H57i1 H58i1 H59i1-H59i22 H60i1 H61i1 H62i1-H62i24 H63i1 594 H64i1 H65i1-H65i3 H66i1-H66i8 H67i1-H67i37 H68i1-H68i3 5; 595 %let fvar59=H45i1; %let lvar59=H68i3; %let nvar59 =250; 596 597 length H69i1-H69i11 H70i1 H71i1-H71i50 H72i1-H72i50 H73i1-H73i50 H74i1-H74i25 598 H75i1 H76i1 H77i1 H78i1-H78i8 H79i1-H79i8 H80i1-H80i8 H81i1-H81i3 599 H82i1 H83i1-H83i3 H84i1-H84i25 H85i1 H86i1 5; 13 The SAS System 14:38 Wednesday, June 17, 2009 600 %let fvar60=H69i1; %let lvar60=H86i1; %let nvar60 =248; 601 602 length H87i1-H87i25 H88i1 H89i1 H90i1-H90i32 H91i1-H91i2 H92i1-H92i3 H93i1-H93i3 603 H94i1-H94i23 H95i1-H95i3 H96i1-H96i50 H97i1-H97i57 H98i1-H98i32 H99i1-H99i3 604 H100i1-H100i3 H101i1-H101i3 H102i1-H102i3 H103i1-H103i3 H104i1-H104i3 5; 605 %let fvar61=H87i1; %let lvar61=H104i3; %let nvar61 =250; 606 607 length H105i1-H105i3 H106i1-H106i3 H107i1-H107i3 H108i1-H108i3 H109i1-H109i3 H110i1-H110i3 608 H111i1-H111i3 H112i1-H112i3 H113i1-H113i3 H114i1-H114i3 H115i1-H115i3 H116i1-H116i3 609 H117i1-H117i3 H118i1-H118i3 H119i1-H119i3 H120i1-H120i7 H121i1-H121i7 5; 610 %let fvar62=H105i1; %let lvar62=H121i7; %let nvar62 =59; 611 612 length HCT1i1-HCT1i53 HCT2i1-HCT2i35 HCT3i1-HCT3i83 5; 613 %let fvar63=HCT1i1; %let lvar63=HCT3i83; %let nvar63 =171; 614 615 length HCT4i1-HCT4i115 5; 616 %let fvar64=HCT4i1; %let lvar64=HCT4i115; %let nvar64 =115; 617 618 length HCT5i1-HCT5i143 5; 619 %let fvar65=HCT5i1; %let lvar65=HCT5i143; %let nvar65 =143; 620 621 length HCT6i1-HCT6i147 HCT7i1-HCT7i101 5; 622 %let fvar66=HCT6i1; %let lvar66=HCT7i101; %let nvar66 =248; 623 624 length HCT8i1-HCT8i99 HCT9i1-HCT9i15 HCT10i1-HCT10i21 HCT11i1-HCT11i25 HCT12i1-HCT12i3 625 HCT13i1-HCT13i5 HCT14i1-HCT14i51 5; 626 %let fvar67=HCT8i1; %let lvar67=HCT14i51; %let nvar67 =219; 627 628 length HCT15i1-HCT15i63 HCT16i1-HCT16i45 HCT17i1-HCT17i106 5; 629 %let fvar68=HCT15i1; %let lvar68=HCT17i106; %let nvar68 =214; 630 631 length HCT18i1-HCT18i120 HCT19i1-HCT19i16 HCT20i1 HCT21i1 HCT22i1-HCT22i39 HCT23i1-HCT23i43 5; 632 %let fvar69=HCT18i1; %let lvar69=HCT23i43; %let nvar69 =220; 633 634 length HCT24i1-HCT24i43 HCT25i1-HCT25i15 HCT26i1-HCT26i15 HCT27i1-HCT27i15 HCT28i1-HCT28i13 635 HCT29Ai1-HCT29Ai3 HCT29Bi1-HCT29Bi3 HCT29Ci1-HCT29Ci3 HCT29Di1-HCT29Di3 636 HCT29Ei1-HCT29Ei3 HCT29Fi1-HCT29Fi3 HCT29Gi1-HCT29Gi3 HCT29Hi1-HCT29Hi3 637 HCT29Ii1-HCT29Ii3 HCT30Ai1-HCT30Ai11 638 HCT30Bi1-HCT30Bi11 HCT30Ci1-HCT30Ci11 HCT30Di1-HCT30Di11 639 HCT30Ei1-HCT30Ei11 HCT30Fi1-HCT30Fi11 HCT30Gi1-HCT30Gi11 640 HCT30Hi1-HCT30Hi11 HCT30Ii1-HCT30Ii11 641 HCT31Ai1-HCT31Ai7 HCT31Bi1-HCT31Bi7 HCT31Ci1-HCT31Ci7 5; 642 %let fvar70=HCT24i1; %let lvar70=HCT31Ci7; %let nvar70=248; 643 644 length HCT31Di1-HCT31Di7 HCT31Ei1-HCT31Ei7 HCT31Fi1-HCT31Fi7 HCT31Gi1-HCT31Gi7 HCT31Hi1-HCT31Hi7 HCT31Ii1-HCT31Ii7 645 HCT32Ai1-HCT32Ai3 HCT32Bi1-HCT32Bi3 HCT32Ci1-HCT32Ci3 HCT32Di1-HCT32Di3 646 HCT32Ei1-HCT32Ei3 HCT32Fi1-HCT32Fi3 HCT32Gi1-HCT32Gi3 HCT32Hi1-HCT32Hi3 HCT32Ii1-HCT32Ii3 647 HCT33Ai1-HCT33Ai3 HCT33Bi1-HCT33Bi3 HCT33Ci1-HCT33Ci3 HCT33Di1-HCT33Di3 648 HCT33Ei1-HCT33Ei3 HCT33Fi1-HCT33Fi3 HCT33Gi1-HCT33Gi3 HCT33Hi1-HCT33Hi3 HCT33Ii1-HCT33Ii3 649 HCT34Ai1-HCT34Ai3 HCT34Bi1-HCT34Bi3 HCT34Ci1-HCT34Ci3 HCT34Di1-HCT34Di3 650 HCT34Ei1-HCT34Ei3 HCT34Fi1-HCT34Fi3 HCT34Gi1-HCT34Gi3 HCT34Hi1-HCT34Hi3 HCT34Ii1-HCT34Ii3 651 HCT35Ai1-HCT35Ai3 HCT35Bi1-HCT35Bi3 HCT35Ci1-HCT35Ci3 HCT35Di1-HCT35Di3 652 HCT35Ei1-HCT35Ei3 HCT35Fi1-HCT35Fi3 HCT35Gi1-HCT35Gi3 HCT35Hi1-HCT35Hi3 HCT35Ii1-HCT35Ii3 653 HCT36Ai1-HCT36Ai24 HCT36Bi1-HCT36Bi24 HCT36Ci1-HCT36Ci24 HCT36Di1-HCT36Di24 5; 654 %let fvar71=HCT31Di1; %let lvar71=HCT36Di24; %let nvar71=246; 655 14 The SAS System 14:38 Wednesday, June 17, 2009 656 length HCT36Ei1-HCT36Ei24 HCT36Fi1-HCT36Fi24 HCT36Gi1-HCT36Gi24 HCT36Hi1-HCT36Hi24 HCT36Ii1-HCT36Ii24 657 HCT37Ai1 HCT37Bi1 HCT37Ci1 HCT37Di1 HCT37Ei1 HCT37Fi1 HCT37Gi1 HCT37Hi1 HCT37Ii1 658 HCT38Ai1 HCT38Bi1 HCT38Ci1 HCT38Di1 HCT38Ei1 HCT38Fi1 HCT38Gi1 HCT38Hi1 HCT38Ii1 659 HCT39Ai1-HCT39Ai11 HCT39Bi1-HCT39Bi11 HCT39Ci1-HCT39Ci11 HCT39Di1-HCT39Di11 660 HCT39Ei1-HCT39Ei11 HCT39Fi1-HCT39Fi11 HCT39Gi1-HCT39Gi11 HCT39Hi1-HCT39Hi11 661 HCT39Ii1-HCT39Ii11 HCT40Ai1 HCT40Bi1 HCT40Ci1 HCT40Di1 HCT40Ei1 HCT40Fi1 HCT40Gi1 HCT40Hi1 HCT40Ii1 5; 662 %let fvar72=HCT36Ei1; %let lvar72=HCT40Ii1; %let nvar72=246; 663 664 length HCT41Ai1-HCT41Ai25 HCT41Bi1-HCT41Bi25 HCT41Ci1-HCT41Ci25 HCT41Di1-HCT41Di25 665 HCT41Ei1-HCT41Ei25 HCT41Fi1-HCT41Fi25 HCT41Gi1-HCT41Gi25 HCT41Hi1-HCT41Hi25 HCT41Ii1-HCT41Ii25 666 HCT42Ai1 HCT42Bi1 HCT42Ci1 HCT42Di1 HCT42Ei1 HCT42Fi1 HCT42Gi1 HCT42Hi1 HCT42Ii1 667 HCT43Ai1 HCT43Bi1 HCT43Ci1 HCT43Di1 HCT43Ei1 HCT43Fi1 HCT43Gi1 HCT43Hi1 HCT43Ii1 5; 668 %let fvar73=HCT41Ai1; %let lvar73=HCT43Ii1; %let nvar73=243; 669 670 length HCT44Ai1-HCT44Ai32 HCT44Bi1-HCT44Bi32 HCT44Ci1-HCT44Ci32 HCT44Di1-HCT44Di32 671 HCT44Ei1-HCT44Ei32 HCT44Fi1-HCT44Fi32 HCT44Gi1-HCT44Gi32 HCT44Hi1-HCT44Hi32 HCT44Ii1-HCT44Ii32 5; 672 %let fvar74=HCT44Ai1; %let lvar74=HCT44Ii32; %let nvar74 =224; 673 674 length HCT44Hi1-HCT44Hi32 HCT44Ii1-HCT44Ii32 HCT45Ai1-HCT45Ai2 HCT45Bi1-HCT45Bi2 675 HCT45Ci1-HCT45Ci2 HCT45Di1-HCT45Di2 HCT45Ei1-HCT45Ei2 HCT45Fi1-HCT45Fi2 676 HCT45Gi1-HCT45Gi2 HCT45Hi1-HCT45Hi2 HCT45Ii1-HCT45Ii2 HCT46Ai1-HCT46Ai3 HCT46Bi1-HCT46Bi3 677 HCT46Ci1-HCT46Ci3 HCT46Di1-HCT46Di3 HCT46Ei1-HCT46Ei3 HCT46Fi1-HCT46Fi3 678 HCT46Gi1-HCT46Gi3 HCT46Hi1-HCT46Hi3 HCT46Ii1-HCT46Ii3 HCT47Ai1-HCT47Ai23 HCT47Bi1-HCT47Bi23 679 HCT47Ci1-HCT47Ci23 HCT47Di1-HCT47Di23 HCT47Ei1-HCT47Ei23 HCT47Fi1-HCT47Fi23 5; 680 %let fvar75=HCT44Hi1; %let lvar75=HCT47Fi23; %let nvar75=247; 681 682 length HCT47Gi1-HCT47Gi23 HCT47Hi1-HCT47Hi23 HCT47Ii1-HCT47Ii23 HCT48Ai1-HCT48Ai3 HCT48Bi1-HCT48Bi3 683 HCT48Ci1-HCT48Ci3 HCT48Di1-HCT48Di3 HCT48Ei1-HCT48Ei3 HCT48Fi1-HCT48Fi3 684 HCT48Gi1-HCT48Gi3 HCT48Hi1-HCT48Hi3 HCT48Ii1-HCT48Ii3 5; 685 %let fvar76=HCT47Gi1; %let lvar76=HCT48Ii3; %let nvar76 =96; 686 687 688 689 *<==================================End parm assignment code=================================== *; 690 691 *<====You can comment out or delete these 4 %include statements if you do not want or need the variable labels. 692 These modules created by Roy Williams, MISER, Mass. SDC from the sf3 data dictionary file. -----*; 693 %include "&curpath/PLabels.sas"/nosource2; *--label statements for the P tables--; 694 %include "&curpath/PCTLabels.sas"/nosource2; *--label statements for PCT tables--; 695 %include "&curpath/HLabels.sas"/nosource2; *--label statements for the H tables--; 696 %include "&curpath/HCTLabels.sas"/nosource2; *--label statements for HCT tables--; 697 698 %local ifile i2 verify; 699 %let verify=0; 700 701 %*----loop to read from all 76 input csv files -- at least those that are relevant----*; 702 %do ifile=1 %to 76; 703 %if &ifile < 10 %then %let i2=0&ifile; %else %let i2=&ifile; 704 *filename in&ifile "us&set.000&i2..&filesfx"; *--e.g. vt00012.uf3 after substitution when ifile=12--; 705 filename in&ifile pipe "unzip -a -p us000&i2._&filesfx" ; %*<==========NOTE====================; 706 _iseg="&i2"; 707 _isegck=' '; %*--in case we do not read the segment because it is a PCT segment for a below-tract sumlev--; 708 infile in&ifile firstobs=&firstobs 709 obs=&maxobs dsd missover lrecl=4096; %*<===lrecl may need to be increased for larger areas==; 710 %if %upcase( %substr(&&fvar&ifile , 2,2)) =CT %then %let ctfile=1; %else %let ctfile=0; 711 15 The SAS System 14:38 Wednesday, June 17, 2009 712 %*--We read the variables associated with the ith input file. Except that for certain 713 summary levels and certain input files there will not be any data. We check for 714 this with the _readCT flag and generate that extra conditions when we detect that 715 we have a file with pct variables-; 716 if _keep 717 %if &ctfile %then %str( and _readCT ); 718 then input _fileid $ _stateid $ _000 $ _isegck $2. +1 logrecnock 7. +1 719 &&fvar&ifile -- &&lvar&ifile ; *<--------here is where we reap reward for declaring all vars in order-; 720 %if &ctfile %then %str( else if _readCT then input; ); 721 %else %str( else input;); 722 %*--to flush the record when _keep=0---; 723 if _isegck ne ' ' then link cklogrecno; 724 retain _varerr 0; drop _varerr; 725 %if &verify=1 %then %do; 726 *---verify that we have read the correct number of variables from the input file---*; 727 array _file&ifile (*) &&fvar&ifile -- &&lvar&ifile; 728 if _first then _ndim=dim(_file&ifile); 729 if _first then if _ndim ne &&nvar&ifile then do; 730 _varerr+1; 731 file log; put "***Problem with variables specified for file &ifile . Expecting &&nvar&ifile variables," 732 " found " _ndim 3.; 733 end; 734 %end; %*--verify processing--; 735 736 %end; %*--do ifile loop--------*; 737 738 ; 739 if _varerr then do; 740 file log; 741 put '*****Conversion run aborting due to above note variable list errors****'; 742 stop; *<=======================Batch runs should replace this with an abort statement--; 743 end; 744 _first=0; 745 if _keep; *---subsetting if. No observation output if _keep=0---; 746 747 *-----output the data sets.---------------*; 748 749 output sf32000.us&set.geos; 750 output sf32000.us&set.ph; 751 if _readCT then do; 752 output sf32000.us&set.phct; 753 output sf32000.us&set.phctR; 754 end; 755 756 **drop logrecnock _isegck _iseg _readCT _keep _fileid _stateid _000 ; **_first12; 757 return; 758 cklogrecno: 759 if logrecno ne logrecnock or _isegck ne _iseg then do; 760 file log; 761 put ///"********Problem with file synching: LogRecNo on segment " _iseg " does not match the geo headers value " 762 "or segment code not expected. ******" 763 / 764 "Reading seg file " _iseg +1 'found segment code ' _isegck / 765 LogRecNo= logrecnock= _n_= / 766 _all_ / '******Job is aborting*********************************' ; 767 stop; 16 The SAS System 14:38 Wednesday, June 17, 2009 768 end; 769 return; 770 771 772 run; 773 774 *-----------Create datasets indices to allow for quicker queries--------------------*; 775 %if %superq(indices) ne %str() %then %do; 776 proc datasets library=sf32000 nolist; 777 %let settypes=geos ph phct phctr; 778 %do _iset=1 %to 4; 779 %let settype=%scan(&settypes,&_iset); 780 781 modify us&set.&settype; 782 %let nindices=%lenlst(&indices); 783 %do _index=1 %to &nindices; 784 %let indexvar=%scan(&indices,&_index); 785 index create &indexvar; 786 %end; 787 %end; %*--_iset loop---; 788 quit; 789 %end; 790 791 792 data sumlevs/view=sumlevs; set sf3.us&set.geos(keep=SumLev State geocomp pop100); 793 sumlev_code=sumlev; 794 if geocomp='00'; 795 run; 796 797 proc tabulate data=sumlevs; 798 class sumlev_code sumlev; 799 var pop100; 800 format sumlev $sumlev.; 801 table sumlev_code*SumLev=' '*pop100*(n*f=comma7. sum*f=comma12.) ; 802 title2 'Proc Tabulate Report: Geography Summary Levels: # Occurrences & Total Pops'; 803 title3 '(excludes cases where geocomp is not 00)'; 804 run; 805 %mend docnvt; 806 807 /* =======================Begin comment================ 808 %docnvt(set=regdiv,sumlevs=010 020 030,idvars=,indices=,geocomps=1); 809 %docnvt(set=stcnty,sumlevs=040 050,idvars=,indices=,geocomps=0); 810 %docnvt(set=places,sumlevs=155 160,indices=,geocomps=0) 811 %docnvt(set=zips,sumlevs=850 860,indices=,geocomps=0) 812 ======================End comment================== */ 813 814 %docnvt(set=uas,sumlevs=400 410,indices=,geocomps=0) NOTE: PROCEDURE PRINTTO used (Total process time): real time 0.01 seconds cpu time 0.00 seconds NOTE: There were 2 observations read from the data set SF3.SUMLEV_MEANS. WHERE INDEX('400 410', sumlev); 17 The SAS System 14:38 Wednesday, June 17, 2009 NOTE: The data set WORK.MINMAXOBS has 1 observations and 6 variables. NOTE: The PROCEDURE MEANS printed page 1. NOTE: PROCEDURE MEANS used (Total process time): real time 0.43 seconds cpu time 0.12 seconds _TYPE_=0 _FREQ_=2 minobs=381195 minlast=453019 maxfirst=381198 maxobs=453022 _ERROR_=0 _N_=1 NOTE: There were 1 observations read from the data set WORK.MINMAXOBS. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.02 seconds GLOBAL DMRVAL NODMR GLOBAL PGM cnvtsf3us GLOBAL DMSFLAG NODMS GLOBAL MAXOBS 453022 GLOBAL FILESFX uf3 GLOBAL V8 0 GLOBAL V9 1 GLOBAL FIRSTOBS 381195 GLOBAL SYSODSPATH SASCTLGS.TEMPLAT(READ) SASHELP.TMPLMST(READ) GLOBAL CURPATH pubdatasf32000Tools GLOBAL UCSTAB US GLOBAL OSEDA oseda.missouri.edu GLOBAL _V9 v9 GLOBAL INPATH pubdatasf32000rawdata GLOBAL REVDATE 02/28/2006 7:40AM NOTE: The infile GEOS is: Pipe command="unzip -a -p /pub/data/sf32000/rawdata/usgeo_uf3" NOTE: The infile IN1 is: Pipe command="unzip -a -p us00001_uf3" NOTE: The infile IN2 is: Pipe command="unzip -a -p us00002_uf3" NOTE: The infile IN3 is: Pipe command="unzip -a -p us00003_uf3" NOTE: The infile IN4 is: Pipe command="unzip -a -p us00004_uf3" NOTE: The infile IN5 is: Pipe command="unzip -a -p us00005_uf3" NOTE: The infile IN6 is: Pipe command="unzip -a -p us00006_uf3" NOTE: The infile IN7 is: Pipe command="unzip -a -p us00007_uf3" NOTE: The infile IN8 is: 18 The SAS System 14:38 Wednesday, June 17, 2009 Pipe command="unzip -a -p us00008_uf3" NOTE: The infile IN9 is: Pipe command="unzip -a -p us00009_uf3" NOTE: The infile IN10 is: Pipe command="unzip -a -p us00010_uf3" NOTE: The infile IN11 is: Pipe command="unzip -a -p us00011_uf3" NOTE: The infile IN12 is: Pipe command="unzip -a -p us00012_uf3" NOTE: The infile IN13 is: Pipe command="unzip -a -p us00013_uf3" NOTE: The infile IN14 is: Pipe command="unzip -a -p us00014_uf3" NOTE: The infile IN15 is: Pipe command="unzip -a -p us00015_uf3" NOTE: The infile IN16 is: Pipe command="unzip -a -p us00016_uf3" NOTE: The infile IN17 is: Pipe command="unzip -a -p us00017_uf3" NOTE: The infile IN18 is: Pipe command="unzip -a -p us00018_uf3" NOTE: The infile IN19 is: Pipe command="unzip -a -p us00019_uf3" NOTE: The infile IN20 is: Pipe command="unzip -a -p us00020_uf3" NOTE: The infile IN21 is: Pipe command="unzip -a -p us00021_uf3" NOTE: The infile IN22 is: Pipe command="unzip -a -p us00022_uf3" NOTE: The infile IN23 is: Pipe command="unzip -a -p us00023_uf3" NOTE: The infile IN24 is: Pipe command="unzip -a -p us00024_uf3" NOTE: The infile IN25 is: Pipe command="unzip -a -p us00025_uf3" NOTE: The infile IN26 is: Pipe command="unzip -a -p us00026_uf3" 19 The SAS System 14:38 Wednesday, June 17, 2009 NOTE: The infile IN27 is: Pipe command="unzip -a -p us00027_uf3" NOTE: The infile IN28 is: Pipe command="unzip -a -p us00028_uf3" NOTE: The infile IN29 is: Pipe command="unzip -a -p us00029_uf3" NOTE: The infile IN30 is: Pipe command="unzip -a -p us00030_uf3" NOTE: The infile IN31 is: Pipe command="unzip -a -p us00031_uf3" NOTE: The infile IN32 is: Pipe command="unzip -a -p us00032_uf3" NOTE: The infile IN33 is: Pipe command="unzip -a -p us00033_uf3" NOTE: The infile IN34 is: Pipe command="unzip -a -p us00034_uf3" NOTE: The infile IN35 is: Pipe command="unzip -a -p us00035_uf3" NOTE: The infile IN36 is: Pipe command="unzip -a -p us00036_uf3" NOTE: The infile IN37 is: Pipe command="unzip -a -p us00037_uf3" NOTE: The infile IN38 is: Pipe command="unzip -a -p us00038_uf3" NOTE: The infile IN39 is: Pipe command="unzip -a -p us00039_uf3" NOTE: The infile IN40 is: Pipe command="unzip -a -p us00040_uf3" NOTE: The infile IN41 is: Pipe command="unzip -a -p us00041_uf3" NOTE: The infile IN42 is: Pipe command="unzip -a -p us00042_uf3" NOTE: The infile IN43 is: Pipe command="unzip -a -p us00043_uf3" NOTE: The infile IN44 is: Pipe command="unzip -a -p us00044_uf3" NOTE: The infile IN45 is: Pipe command="unzip -a -p us00045_uf3" 20 The SAS System 14:38 Wednesday, June 17, 2009 NOTE: The infile IN46 is: Pipe command="unzip -a -p us00046_uf3" NOTE: The infile IN47 is: Pipe command="unzip -a -p us00047_uf3" NOTE: The infile IN48 is: Pipe command="unzip -a -p us00048_uf3" NOTE: The infile IN49 is: Pipe command="unzip -a -p us00049_uf3" NOTE: The infile IN50 is: Pipe command="unzip -a -p us00050_uf3" NOTE: The infile IN51 is: Pipe command="unzip -a -p us00051_uf3" NOTE: The infile IN52 is: Pipe command="unzip -a -p us00052_uf3" NOTE: The infile IN53 is: Pipe command="unzip -a -p us00053_uf3" NOTE: The infile IN54 is: Pipe command="unzip -a -p us00054_uf3" NOTE: The infile IN55 is: Pipe command="unzip -a -p us00055_uf3" NOTE: The infile IN56 is: Pipe command="unzip -a -p us00056_uf3" NOTE: The infile IN57 is: Pipe command="unzip -a -p us00057_uf3" NOTE: The infile IN58 is: Pipe command="unzip -a -p us00058_uf3" NOTE: The infile IN59 is: Pipe command="unzip -a -p us00059_uf3" NOTE: The infile IN60 is: Pipe command="unzip -a -p us00060_uf3" NOTE: The infile IN61 is: Pipe command="unzip -a -p us00061_uf3" NOTE: The infile IN62 is: Pipe command="unzip -a -p us00062_uf3" NOTE: The infile IN63 is: Pipe command="unzip -a -p us00063_uf3" NOTE: The infile IN64 is: 21 The SAS System 14:38 Wednesday, June 17, 2009 Pipe command="unzip -a -p us00064_uf3" NOTE: The infile IN65 is: Pipe command="unzip -a -p us00065_uf3" NOTE: The infile IN66 is: Pipe command="unzip -a -p us00066_uf3" NOTE: The infile IN67 is: Pipe command="unzip -a -p us00067_uf3" NOTE: The infile IN68 is: Pipe command="unzip -a -p us00068_uf3" NOTE: The infile IN69 is: Pipe command="unzip -a -p us00069_uf3" NOTE: The infile IN70 is: Pipe command="unzip -a -p us00070_uf3" NOTE: The infile IN71 is: Pipe command="unzip -a -p us00071_uf3" NOTE: The infile IN72 is: Pipe command="unzip -a -p us00072_uf3" NOTE: The infile IN73 is: Pipe command="unzip -a -p us00073_uf3" NOTE: The infile IN74 is: Pipe command="unzip -a -p us00074_uf3" NOTE: The infile IN75 is: Pipe command="unzip -a -p us00075_uf3" NOTE: The infile IN76 is: Pipe command="unzip -a -p us00076_uf3" NOTE: 71828 records were read from the infile GEOS. The minimum record length was 400. The maximum record length was 400. NOTE: 71828 records were read from the infile IN1. The minimum record length was 520. The maximum record length was 1778. NOTE: 71828 records were read from the infile IN2. The minimum record length was 458. The maximum record length was 1529. NOTE: 71828 records were read from the infile IN3. The minimum record length was 504. The maximum record length was 1632. NOTE: 71828 records were read from the infile IN4. The minimum record length was 476. The maximum record length was 1575. NOTE: 71828 records were read from the infile IN5. The minimum record length was 462. The maximum record length was 1476. 22 The SAS System 14:38 Wednesday, June 17, 2009 NOTE: 71828 records were read from the infile IN6. The minimum record length was 522. The maximum record length was 1610. NOTE: 71828 records were read from the infile IN7. The minimum record length was 448. The maximum record length was 1619. NOTE: 71828 records were read from the infile IN8. The minimum record length was 512. The maximum record length was 1894. NOTE: 71828 records were read from the infile IN9. The minimum record length was 428. The maximum record length was 1264. NOTE: 71828 records were read from the infile IN10. The minimum record length was 512. The maximum record length was 1419. NOTE: 71828 records were read from the infile IN11. The minimum record length was 492. The maximum record length was 1350. NOTE: 71828 records were read from the infile IN12. The minimum record length was 514. The maximum record length was 1510. NOTE: 71828 records were read from the infile IN13. The minimum record length was 504. The maximum record length was 1369. NOTE: 71828 records were read from the infile IN14. The minimum record length was 512. The maximum record length was 1370. NOTE: 71828 records were read from the infile IN15. The minimum record length was 500. The maximum record length was 1473. NOTE: 71828 records were read from the infile IN16. The minimum record length was 502. The maximum record length was 1465. NOTE: 71828 records were read from the infile IN17. The minimum record length was 500. The maximum record length was 1298. NOTE: 71828 records were read from the infile IN18. The minimum record length was 350. The maximum record length was 982. NOTE: 71828 records were read from the infile IN19. The minimum record length was 516. The maximum record length was 1571. NOTE: 71828 records were read from the infile IN20. The minimum record length was 430. The maximum record length was 1338. NOTE: 71828 records were read from the infile IN21. The minimum record length was 466. The maximum record length was 1194. NOTE: 71828 records were read from the infile IN22. The minimum record length was 492. The maximum record length was 1398. NOTE: 71828 records were read from the infile IN23. The minimum record length was 488. The maximum record length was 1417. NOTE: 71828 records were read from the infile IN24. The minimum record length was 488. 23 The SAS System 14:38 Wednesday, June 17, 2009 The maximum record length was 1564. NOTE: 71828 records were read from the infile IN25. The minimum record length was 464. The maximum record length was 1569. NOTE: 71828 records were read from the infile IN26. The minimum record length was 234. The maximum record length was 752. NOTE: 71828 records were read from the infile IN27. The minimum record length was 464. The maximum record length was 1574. NOTE: 71828 records were read from the infile IN28. The minimum record length was 346. The maximum record length was 1150. NOTE: 71828 records were read from the infile IN29. The minimum record length was 432. The maximum record length was 1391. NOTE: 71828 records were read from the infile IN30. The minimum record length was 470. The maximum record length was 1482. NOTE: 71828 records were read from the infile IN31. The minimum record length was 432. The maximum record length was 1327. NOTE: 71828 records were read from the infile IN32. The minimum record length was 508. The maximum record length was 1571. NOTE: 71828 records were read from the infile IN33. The minimum record length was 508. The maximum record length was 1519. NOTE: 71828 records were read from the infile IN34. The minimum record length was 490. The maximum record length was 1367. NOTE: 71828 records were read from the infile IN35. The minimum record length was 484. The maximum record length was 1358. NOTE: 71828 records were read from the infile IN36. The minimum record length was 488. The maximum record length was 1331. NOTE: 71828 records were read from the infile IN37. The minimum record length was 468. The maximum record length was 1384. NOTE: 71828 records were read from the infile IN38. The minimum record length was 512. The maximum record length was 1465. NOTE: 71828 records were read from the infile IN39. The minimum record length was 516. The maximum record length was 1542. NOTE: 71828 records were read from the infile IN40. The minimum record length was 508. The maximum record length was 1424. NOTE: 71828 records were read from the infile IN41. The minimum record length was 512. The maximum record length was 1316. NOTE: 71828 records were read from the infile IN42. The minimum record length was 414. The maximum record length was 1185. NOTE: 71828 records were read from the infile IN43. 24 The SAS System 14:38 Wednesday, June 17, 2009 The minimum record length was 502. The maximum record length was 1391. NOTE: 71828 records were read from the infile IN44. The minimum record length was 502. The maximum record length was 1066. NOTE: 71828 records were read from the infile IN45. The minimum record length was 502. The maximum record length was 1016. NOTE: 71828 records were read from the infile IN46. The minimum record length was 502. The maximum record length was 1217. NOTE: 71828 records were read from the infile IN47. The minimum record length was 452. The maximum record length was 1342. NOTE: 71828 records were read from the infile IN48. The minimum record length was 402. The maximum record length was 947. NOTE: 71828 records were read from the infile IN49. The minimum record length was 402. The maximum record length was 908. NOTE: 71828 records were read from the infile IN50. The minimum record length was 402. The maximum record length was 1036. NOTE: 71828 records were read from the infile IN51. The minimum record length was 402. The maximum record length was 1179. NOTE: 71828 records were read from the infile IN52. The minimum record length was 484. The maximum record length was 1364. NOTE: 71828 records were read from the infile IN53. The minimum record length was 494. The maximum record length was 1301. NOTE: 71828 records were read from the infile IN54. The minimum record length was 490. The maximum record length was 1422. NOTE: 71828 records were read from the infile IN55. The minimum record length was 312. The maximum record length was 844. NOTE: 71828 records were read from the infile IN56. The minimum record length was 289. The maximum record length was 883. NOTE: 71828 records were read from the infile IN57. The minimum record length was 522. The maximum record length was 1616. NOTE: 71828 records were read from the infile IN58. The minimum record length was 460. The maximum record length was 1485. NOTE: 71828 records were read from the infile IN59. The minimum record length was 522. The maximum record length was 1681. NOTE: 71828 records were read from the infile IN60. The minimum record length was 520. The maximum record length was 1705. NOTE: 71828 records were read from the infile IN61. The minimum record length was 528. The maximum record length was 1535. 25 The SAS System 14:38 Wednesday, June 17, 2009 NOTE: 71828 records were read from the infile IN62. The minimum record length was 140. The maximum record length was 463. NOTE: 71828 records were read from the infile IN63. The minimum record length was 364. The maximum record length was 1118. NOTE: 71828 records were read from the infile IN64. The minimum record length was 252. The maximum record length was 683. NOTE: 71828 records were read from the infile IN65. The minimum record length was 308. The maximum record length was 883. NOTE: 71828 records were read from the infile IN66. The minimum record length was 518. The maximum record length was 1454. NOTE: 71828 records were read from the infile IN67. The minimum record length was 460. The maximum record length was 1671. NOTE: 71828 records were read from the infile IN68. The minimum record length was 450. The maximum record length was 1789. NOTE: 71828 records were read from the infile IN69. The minimum record length was 462. The maximum record length was 1372. NOTE: 71828 records were read from the infile IN70. The minimum record length was 518. The maximum record length was 1614. NOTE: 71828 records were read from the infile IN71. The minimum record length was 514. The maximum record length was 1515. NOTE: 71828 records were read from the infile IN72. The minimum record length was 532. The maximum record length was 1407. NOTE: 71828 records were read from the infile IN73. The minimum record length was 508. The maximum record length was 1221. NOTE: 71828 records were read from the infile IN74. The minimum record length was 470. The maximum record length was 1053. NOTE: 71828 records were read from the infile IN75. The minimum record length was 516. The maximum record length was 1374. NOTE: 71828 records were read from the infile IN76. The minimum record length was 268. The maximum record length was 534. NOTE: The data set SF32000.USUASGEOS has 7406 observations and 74 variables. NOTE: Compressing data set SF32000.USUASGEOS decreased size by 63.57 percent. Compressed is 47 pages; un-compressed would require 129 pages. NOTE: The data set SF32000.USUASPH has 7406 observations and 5632 variables. NOTE: Compressing data set SF32000.USUASPH decreased size by 36.51 percent. Compressed is 2360 pages; un-compressed would require 3717 pages. NOTE: The data set SF32000.USUASPHCT has 7406 observations and 4465 variables. NOTE: Compressing data set SF32000.USUASPHCT decreased size by 50.50 percent. Compressed is 1838 pages; un-compressed would require 3713 pages. NOTE: The data set SF32000.USUASPHCTR has 7406 observations and 6643 variables. NOTE: Compressing data set SF32000.USUASPHCTR decreased size by 78.53 percent. 26 The SAS System 14:38 Wednesday, June 17, 2009 Compressed is 1593 pages; un-compressed would require 7421 pages. NOTE: DATA statement used (Total process time): real time 1:23:57.24 cpu time 1:22:15.69 NOTE: DATA STEP view saved on file WORK.SUMLEVS. NOTE: A stored DATA STEP view cannot run under a different operating system. NOTE: DATA statement used (Total process time): real time 0.36 seconds cpu time 0.01 seconds NOTE: View WORK.SUMLEVS.VIEW used (Total process time): real time 0.91 seconds cpu time 0.24 seconds NOTE: There were 7406 observations read from the data set SF3.USUASGEOS. NOTE: There were 7406 observations read from the data set WORK.SUMLEVS. NOTE: The PROCEDURE TABULATE printed page 2. NOTE: PROCEDURE TABULATE used (Total process time): real time 1.18 seconds cpu time 0.27 seconds 22002 %docnvt(set=metros,sumlevs=370 371 380 381 385 386,indices=,geocomps=0) NOTE: PROCEDURE PRINTTO used (Total process time): real time 0.03 seconds cpu time 0.00 seconds NOTE: There were 6 observations read from the data set SF3.SUMLEV_MEANS. WHERE INDEX('370 371 380 381 385 386', sumlev); NOTE: The data set WORK.MINMAXOBS has 1 observations and 6 variables. NOTE: The PROCEDURE MEANS printed page 3. NOTE: PROCEDURE MEANS used (Total process time): real time 0.43 seconds cpu time 0.08 seconds _TYPE_=0 _FREQ_=6 minobs=374819 minlast=380862 maxfirst=381074 maxobs=381188 _ERROR_=0 _N_=1 NOTE: There were 1 observations read from the data set WORK.MINMAXOBS. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.00 seconds GLOBAL DMRVAL NODMR GLOBAL PGM cnvtsf3us GLOBAL DMSFLAG NODMS GLOBAL MAXOBS 381188 27 The SAS System 14:38 Wednesday, June 17, 2009 GLOBAL FILESFX uf3 GLOBAL V8 0 GLOBAL V9 1 GLOBAL FIRSTOBS 374819 GLOBAL SYSODSPATH SASCTLGS.TEMPLAT(READ) SASHELP.TMPLMST(READ) GLOBAL CURPATH pubdatasf32000Tools GLOBAL UCSTAB US GLOBAL OSEDA oseda.missouri.edu GLOBAL _V9 v9 GLOBAL INPATH pubdatasf32000rawdata GLOBAL REVDATE 02/28/2006 7:40AM NOTE: The infile GEOS is: Pipe command="unzip -a -p /pub/data/sf32000/rawdata/usgeo_uf3" NOTE: The infile IN1 is: Pipe command="unzip -a -p us00001_uf3" NOTE: The infile IN2 is: Pipe command="unzip -a -p us00002_uf3" NOTE: The infile IN3 is: Pipe command="unzip -a -p us00003_uf3" NOTE: The infile IN4 is: Pipe command="unzip -a -p us00004_uf3" NOTE: The infile IN5 is: Pipe command="unzip -a -p us00005_uf3" NOTE: The infile IN6 is: Pipe command="unzip -a -p us00006_uf3" NOTE: The infile IN7 is: Pipe command="unzip -a -p us00007_uf3" NOTE: The infile IN8 is: Pipe command="unzip -a -p us00008_uf3" NOTE: The infile IN9 is: Pipe command="unzip -a -p us00009_uf3" NOTE: The infile IN10 is: Pipe command="unzip -a -p us00010_uf3" NOTE: The infile IN11 is: Pipe command="unzip -a -p us00011_uf3" NOTE: The infile IN12 is: Pipe command="unzip -a -p us00012_uf3" NOTE: The infile IN13 is: Pipe command="unzip -a -p us00013_uf3" NOTE: The infile IN14 is: Pipe command="unzip -a -p us00014_uf3" 28 The SAS System 14:38 Wednesday, June 17, 2009 NOTE: The infile IN15 is: Pipe command="unzip -a -p us00015_uf3" NOTE: The infile IN16 is: Pipe command="unzip -a -p us00016_uf3" NOTE: The infile IN17 is: Pipe command="unzip -a -p us00017_uf3" NOTE: The infile IN18 is: Pipe command="unzip -a -p us00018_uf3" NOTE: The infile IN19 is: Pipe command="unzip -a -p us00019_uf3" NOTE: The infile IN20 is: Pipe command="unzip -a -p us00020_uf3" NOTE: The infile IN21 is: Pipe command="unzip -a -p us00021_uf3" NOTE: The infile IN22 is: Pipe command="unzip -a -p us00022_uf3" NOTE: The infile IN23 is: Pipe command="unzip -a -p us00023_uf3" NOTE: The infile IN24 is: Pipe command="unzip -a -p us00024_uf3" NOTE: The infile IN25 is: Pipe command="unzip -a -p us00025_uf3" NOTE: The infile IN26 is: Pipe command="unzip -a -p us00026_uf3" NOTE: The infile IN27 is: Pipe command="unzip -a -p us00027_uf3" NOTE: The infile IN28 is: Pipe command="unzip -a -p us00028_uf3" NOTE: The infile IN29 is: Pipe command="unzip -a -p us00029_uf3" NOTE: The infile IN30 is: Pipe command="unzip -a -p us00030_uf3" NOTE: The infile IN31 is: Pipe command="unzip -a -p us00031_uf3" NOTE: The infile IN32 is: Pipe command="unzip -a -p us00032_uf3" NOTE: The infile IN33 is: 29 The SAS System 14:38 Wednesday, June 17, 2009 Pipe command="unzip -a -p us00033_uf3" NOTE: The infile IN34 is: Pipe command="unzip -a -p us00034_uf3" NOTE: The infile IN35 is: Pipe command="unzip -a -p us00035_uf3" NOTE: The infile IN36 is: Pipe command="unzip -a -p us00036_uf3" NOTE: The infile IN37 is: Pipe command="unzip -a -p us00037_uf3" NOTE: The infile IN38 is: Pipe command="unzip -a -p us00038_uf3" NOTE: The infile IN39 is: Pipe command="unzip -a -p us00039_uf3" NOTE: The infile IN40 is: Pipe command="unzip -a -p us00040_uf3" NOTE: The infile IN41 is: Pipe command="unzip -a -p us00041_uf3" NOTE: The infile IN42 is: Pipe command="unzip -a -p us00042_uf3" NOTE: The infile IN43 is: Pipe command="unzip -a -p us00043_uf3" NOTE: The infile IN44 is: Pipe command="unzip -a -p us00044_uf3" NOTE: The infile IN45 is: Pipe command="unzip -a -p us00045_uf3" NOTE: The infile IN46 is: Pipe command="unzip -a -p us00046_uf3" NOTE: The infile IN47 is: Pipe command="unzip -a -p us00047_uf3" NOTE: The infile IN48 is: Pipe command="unzip -a -p us00048_uf3" NOTE: The infile IN49 is: Pipe command="unzip -a -p us00049_uf3" NOTE: The infile IN50 is: Pipe command="unzip -a -p us00050_uf3" NOTE: The infile IN51 is: Pipe command="unzip -a -p us00051_uf3" 30 The SAS System 14:38 Wednesday, June 17, 2009 NOTE: The infile IN52 is: Pipe command="unzip -a -p us00052_uf3" NOTE: The infile IN53 is: Pipe command="unzip -a -p us00053_uf3" NOTE: The infile IN54 is: Pipe command="unzip -a -p us00054_uf3" NOTE: The infile IN55 is: Pipe command="unzip -a -p us00055_uf3" NOTE: The infile IN56 is: Pipe command="unzip -a -p us00056_uf3" NOTE: The infile IN57 is: Pipe command="unzip -a -p us00057_uf3" NOTE: The infile IN58 is: Pipe command="unzip -a -p us00058_uf3" NOTE: The infile IN59 is: Pipe command="unzip -a -p us00059_uf3" NOTE: The infile IN60 is: Pipe command="unzip -a -p us00060_uf3" NOTE: The infile IN61 is: Pipe command="unzip -a -p us00061_uf3" NOTE: The infile IN62 is: Pipe command="unzip -a -p us00062_uf3" NOTE: The infile IN63 is: Pipe command="unzip -a -p us00063_uf3" NOTE: The infile IN64 is: Pipe command="unzip -a -p us00064_uf3" NOTE: The infile IN65 is: Pipe command="unzip -a -p us00065_uf3" NOTE: The infile IN66 is: Pipe command="unzip -a -p us00066_uf3" NOTE: The infile IN67 is: Pipe command="unzip -a -p us00067_uf3" NOTE: The infile IN68 is: Pipe command="unzip -a -p us00068_uf3" NOTE: The infile IN69 is: Pipe command="unzip -a -p us00069_uf3" NOTE: The infile IN70 is: Pipe command="unzip -a -p us00070_uf3" 31 The SAS System 14:38 Wednesday, June 17, 2009 NOTE: The infile IN71 is: Pipe command="unzip -a -p us00071_uf3" NOTE: The infile IN72 is: Pipe command="unzip -a -p us00072_uf3" NOTE: The infile IN73 is: Pipe command="unzip -a -p us00073_uf3" NOTE: The infile IN74 is: Pipe command="unzip -a -p us00074_uf3" NOTE: The infile IN75 is: Pipe command="unzip -a -p us00075_uf3" NOTE: The infile IN76 is: Pipe command="unzip -a -p us00076_uf3" NOTE: 6370 records were read from the infile GEOS. The minimum record length was 400. The maximum record length was 400. NOTE: 6370 records were read from the infile IN1. The minimum record length was 520. The maximum record length was 1806. NOTE: 6370 records were read from the infile IN2. The minimum record length was 458. The maximum record length was 1542. NOTE: 6370 records were read from the infile IN3. The minimum record length was 504. The maximum record length was 1649. NOTE: 6370 records were read from the infile IN4. The minimum record length was 476. The maximum record length was 1591. NOTE: 6370 records were read from the infile IN5. The minimum record length was 462. The maximum record length was 1492. NOTE: 6370 records were read from the infile IN6. The minimum record length was 522. The maximum record length was 1631. NOTE: 6370 records were read from the infile IN7. The minimum record length was 448. The maximum record length was 1631. NOTE: 6370 records were read from the infile IN8. The minimum record length was 512. The maximum record length was 1912. NOTE: 6370 records were read from the infile IN9. The minimum record length was 428. The maximum record length was 1274. NOTE: 6370 records were read from the infile IN10. The minimum record length was 512. The maximum record length was 1441. NOTE: 6370 records were read from the infile IN11. The minimum record length was 492. The maximum record length was 1369. NOTE: 6370 records were read from the infile IN12. 32 The SAS System 14:38 Wednesday, June 17, 2009 The minimum record length was 514. The maximum record length was 1528. NOTE: 6370 records were read from the infile IN13. The minimum record length was 504. The maximum record length was 1398. NOTE: 6370 records were read from the infile IN14. The minimum record length was 512. The maximum record length was 1434. NOTE: 6370 records were read from the infile IN15. The minimum record length was 500. The maximum record length was 1499. NOTE: 6370 records were read from the infile IN16. The minimum record length was 502. The maximum record length was 1500. NOTE: 6370 records were read from the infile IN17. The minimum record length was 500. The maximum record length was 1326. NOTE: 6370 records were read from the infile IN18. The minimum record length was 350. The maximum record length was 991. NOTE: 6370 records were read from the infile IN19. The minimum record length was 516. The maximum record length was 1584. NOTE: 6370 records were read from the infile IN20. The minimum record length was 430. The maximum record length was 1351. NOTE: 6370 records were read from the infile IN21. The minimum record length was 466. The maximum record length was 1210. NOTE: 6370 records were read from the infile IN22. The minimum record length was 492. The maximum record length was 1411. NOTE: 6370 records were read from the infile IN23. The minimum record length was 488. The maximum record length was 1429. NOTE: 6370 records were read from the infile IN24. The minimum record length was 488. The maximum record length was 1578. NOTE: 6370 records were read from the infile IN25. The minimum record length was 464. The maximum record length was 1579. NOTE: 6370 records were read from the infile IN26. The minimum record length was 234. The maximum record length was 759. NOTE: 6370 records were read from the infile IN27. The minimum record length was 464. The maximum record length was 1604. NOTE: 6370 records were read from the infile IN28. The minimum record length was 346. The maximum record length was 1162. NOTE: 6370 records were read from the infile IN29. The minimum record length was 432. The maximum record length was 1408. NOTE: 6370 records were read from the infile IN30. The minimum record length was 470. The maximum record length was 1499. 33 The SAS System 14:38 Wednesday, June 17, 2009 NOTE: 6370 records were read from the infile IN31. The minimum record length was 432. The maximum record length was 1332. NOTE: 6370 records were read from the infile IN32. The minimum record length was 508. The maximum record length was 1587. NOTE: 6370 records were read from the infile IN33. The minimum record length was 508. The maximum record length was 1533. NOTE: 6370 records were read from the infile IN34. The minimum record length was 490. The maximum record length was 1385. NOTE: 6370 records were read from the infile IN35. The minimum record length was 484. The maximum record length was 1365. NOTE: 6370 records were read from the infile IN36. The minimum record length was 488. The maximum record length was 1376. NOTE: 6370 records were read from the infile IN37. The minimum record length was 468. The maximum record length was 1399. NOTE: 6370 records were read from the infile IN38. The minimum record length was 512. The maximum record length was 1478. NOTE: 6370 records were read from the infile IN39. The minimum record length was 516. The maximum record length was 1563. NOTE: 6370 records were read from the infile IN40. The minimum record length was 508. The maximum record length was 1461. NOTE: 6370 records were read from the infile IN41. The minimum record length was 512. The maximum record length was 1349. NOTE: 6370 records were read from the infile IN42. The minimum record length was 414. The maximum record length was 1208. NOTE: 6370 records were read from the infile IN43. The minimum record length was 502. The maximum record length was 1413. NOTE: 6370 records were read from the infile IN44. The minimum record length was 502. The maximum record length was 1092. NOTE: 6370 records were read from the infile IN45. The minimum record length was 502. The maximum record length was 1040. NOTE: 6370 records were read from the infile IN46. The minimum record length was 502. The maximum record length was 1236. NOTE: 6370 records were read from the infile IN47. The minimum record length was 452. The maximum record length was 1358. NOTE: 6370 records were read from the infile IN48. The minimum record length was 402. The maximum record length was 954. NOTE: 6370 records were read from the infile IN49. The minimum record length was 402. 34 The SAS System 14:38 Wednesday, June 17, 2009 The maximum record length was 923. NOTE: 6370 records were read from the infile IN50. The minimum record length was 402. The maximum record length was 1056. NOTE: 6370 records were read from the infile IN51. The minimum record length was 402. The maximum record length was 1189. NOTE: 6370 records were read from the infile IN52. The minimum record length was 484. The maximum record length was 1370. NOTE: 6370 records were read from the infile IN53. The minimum record length was 494. The maximum record length was 1328. NOTE: 6370 records were read from the infile IN54. The minimum record length was 490. The maximum record length was 1440. NOTE: 6370 records were read from the infile IN55. The minimum record length was 312. The maximum record length was 863. NOTE: 6370 records were read from the infile IN56. The minimum record length was 289. The maximum record length was 908. NOTE: 6370 records were read from the infile IN57. The minimum record length was 522. The maximum record length was 1628. NOTE: 6370 records were read from the infile IN58. The minimum record length was 460. The maximum record length was 1497. NOTE: 6370 records were read from the infile IN59. The minimum record length was 522. The maximum record length was 1695. NOTE: 6370 records were read from the infile IN60. The minimum record length was 520. The maximum record length was 1722. NOTE: 6370 records were read from the infile IN61. The minimum record length was 528. The maximum record length was 1562. NOTE: 6370 records were read from the infile IN62. The minimum record length was 140. The maximum record length was 464. NOTE: 6370 records were read from the infile IN63. The minimum record length was 364. The maximum record length was 1130. NOTE: 6370 records were read from the infile IN64. The minimum record length was 252. The maximum record length was 691. NOTE: 6370 records were read from the infile IN65. The minimum record length was 308. The maximum record length was 896. NOTE: 6370 records were read from the infile IN66. The minimum record length was 518. The maximum record length was 1479. NOTE: 6370 records were read from the infile IN67. The minimum record length was 460. The maximum record length was 1687. NOTE: 6370 records were read from the infile IN68. 35 The SAS System 14:38 Wednesday, June 17, 2009 The minimum record length was 450. The maximum record length was 1821. NOTE: 6370 records were read from the infile IN69. The minimum record length was 462. The maximum record length was 1380. NOTE: 6370 records were read from the infile IN70. The minimum record length was 518. The maximum record length was 1621. NOTE: 6370 records were read from the infile IN71. The minimum record length was 514. The maximum record length was 1528. NOTE: 6370 records were read from the infile IN72. The minimum record length was 532. The maximum record length was 1423. NOTE: 6370 records were read from the infile IN73. The minimum record length was 508. The maximum record length was 1290. NOTE: 6370 records were read from the infile IN74. The minimum record length was 470. The maximum record length was 1084. NOTE: 6370 records were read from the infile IN75. The minimum record length was 516. The maximum record length was 1423. NOTE: 6370 records were read from the infile IN76. The minimum record length was 268. The maximum record length was 539. NOTE: The data set SF32000.USMETROSGEOS has 801 observations and 74 variables. NOTE: Compressing data set SF32000.USMETROSGEOS decreased size by 53.33 percent. Compressed is 7 pages; un-compressed would require 15 pages. NOTE: The data set SF32000.USMETROSPH has 801 observations and 5632 variables. NOTE: Compressing data set SF32000.USMETROSPH decreased size by 0.48 percent. Compressed is 413 pages; un-compressed would require 415 pages. NOTE: The data set SF32000.USMETROSPHCT has 801 observations and 4465 variables. NOTE: Compressing data set SF32000.USMETROSPHCT decreased size by 32.36 percent. Compressed is 278 pages; un-compressed would require 411 pages. NOTE: The data set SF32000.USMETROSPHCTR has 801 observations and 6643 variables. NOTE: Compressing data set SF32000.USMETROSPHCTR decreased size by 52.70 percent. Compressed is 386 pages; un-compressed would require 816 pages. NOTE: DATA statement used (Total process time): real time 1:08:43.17 cpu time 1:07:05.24 NOTE: DATA STEP view saved on file WORK.SUMLEVS. NOTE: A stored DATA STEP view cannot run under a different operating system. NOTE: DATA statement used (Total process time): real time 0.16 seconds cpu time 0.03 seconds NOTE: View WORK.SUMLEVS.VIEW used (Total process time): real time 1.53 seconds cpu time 0.16 seconds 36 The SAS System 14:38 Wednesday, June 17, 2009 NOTE: There were 801 observations read from the data set SF3.USMETROSGEOS. NOTE: There were 801 observations read from the data set WORK.SUMLEVS. NOTE: The PROCEDURE TABULATE printed page 4. NOTE: PROCEDURE TABULATE used (Total process time): real time 1.75 seconds cpu time 0.18 seconds 43190 %docnvt(set=cd106,sumlevs=500,indices=,geocomps=0) NOTE: PROCEDURE PRINTTO used (Total process time): real time 0.04 seconds cpu time 0.00 seconds NOTE: There were 1 observations read from the data set SF3.SUMLEV_MEANS. WHERE INDEX('500', sumlev); NOTE: The data set WORK.MINMAXOBS has 1 observations and 6 variables. NOTE: The PROCEDURE MEANS printed page 5. NOTE: PROCEDURE MEANS used (Total process time): real time 0.48 seconds cpu time 0.09 seconds _TYPE_=0 _FREQ_=1 minobs=7026 minlast=345044 maxfirst=7026 maxobs=345044 _ERROR_=0 _N_=1 NOTE: There were 1 observations read from the data set WORK.MINMAXOBS. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.02 seconds GLOBAL DMRVAL NODMR GLOBAL PGM cnvtsf3us GLOBAL DMSFLAG NODMS GLOBAL MAXOBS 345044 GLOBAL FILESFX uf3 GLOBAL V8 0 GLOBAL V9 1 GLOBAL FIRSTOBS 7026 GLOBAL SYSODSPATH SASCTLGS.TEMPLAT(READ) SASHELP.TMPLMST(READ) GLOBAL CURPATH pubdatasf32000Tools GLOBAL UCSTAB US GLOBAL OSEDA oseda.missouri.edu GLOBAL _V9 v9 GLOBAL INPATH pubdatasf32000rawdata GLOBAL REVDATE 02/28/2006 7:40AM NOTE: The infile GEOS is: Pipe command="unzip -a -p /pub/data/sf32000/rawdata/usgeo_uf3" NOTE: The infile IN1 is: Pipe command="unzip -a -p us00001_uf3" NOTE: The infile IN2 is: 37 The SAS System 14:38 Wednesday, June 17, 2009 Pipe command="unzip -a -p us00002_uf3" NOTE: The infile IN3 is: Pipe command="unzip -a -p us00003_uf3" NOTE: The infile IN4 is: Pipe command="unzip -a -p us00004_uf3" NOTE: The infile IN5 is: Pipe command="unzip -a -p us00005_uf3" NOTE: The infile IN6 is: Pipe command="unzip -a -p us00006_uf3" NOTE: The infile IN7 is: Pipe command="unzip -a -p us00007_uf3" NOTE: The infile IN8 is: Pipe command="unzip -a -p us00008_uf3" NOTE: The infile IN9 is: Pipe command="unzip -a -p us00009_uf3" NOTE: The infile IN10 is: Pipe command="unzip -a -p us00010_uf3" NOTE: The infile IN11 is: Pipe command="unzip -a -p us00011_uf3" NOTE: The infile IN12 is: Pipe command="unzip -a -p us00012_uf3" NOTE: The infile IN13 is: Pipe command="unzip -a -p us00013_uf3" NOTE: The infile IN14 is: Pipe command="unzip -a -p us00014_uf3" NOTE: The infile IN15 is: Pipe command="unzip -a -p us00015_uf3" NOTE: The infile IN16 is: Pipe command="unzip -a -p us00016_uf3" NOTE: The infile IN17 is: Pipe command="unzip -a -p us00017_uf3" NOTE: The infile IN18 is: Pipe command="unzip -a -p us00018_uf3" NOTE: The infile IN19 is: Pipe command="unzip -a -p us00019_uf3" NOTE: The infile IN20 is: Pipe command="unzip -a -p us00020_uf3" 38 The SAS System 14:38 Wednesday, June 17, 2009 NOTE: The infile IN21 is: Pipe command="unzip -a -p us00021_uf3" NOTE: The infile IN22 is: Pipe command="unzip -a -p us00022_uf3" NOTE: The infile IN23 is: Pipe command="unzip -a -p us00023_uf3" NOTE: The infile IN24 is: Pipe command="unzip -a -p us00024_uf3" NOTE: The infile IN25 is: Pipe command="unzip -a -p us00025_uf3" NOTE: The infile IN26 is: Pipe command="unzip -a -p us00026_uf3" NOTE: The infile IN27 is: Pipe command="unzip -a -p us00027_uf3" NOTE: The infile IN28 is: Pipe command="unzip -a -p us00028_uf3" NOTE: The infile IN29 is: Pipe command="unzip -a -p us00029_uf3" NOTE: The infile IN30 is: Pipe command="unzip -a -p us00030_uf3" NOTE: The infile IN31 is: Pipe command="unzip -a -p us00031_uf3" NOTE: The infile IN32 is: Pipe command="unzip -a -p us00032_uf3" NOTE: The infile IN33 is: Pipe command="unzip -a -p us00033_uf3" NOTE: The infile IN34 is: Pipe command="unzip -a -p us00034_uf3" NOTE: The infile IN35 is: Pipe command="unzip -a -p us00035_uf3" NOTE: The infile IN36 is: Pipe command="unzip -a -p us00036_uf3" NOTE: The infile IN37 is: Pipe command="unzip -a -p us00037_uf3" NOTE: The infile IN38 is: Pipe command="unzip -a -p us00038_uf3" NOTE: The infile IN39 is: Pipe command="unzip -a -p us00039_uf3" 39 The SAS System 14:38 Wednesday, June 17, 2009 NOTE: The infile IN40 is: Pipe command="unzip -a -p us00040_uf3" NOTE: The infile IN41 is: Pipe command="unzip -a -p us00041_uf3" NOTE: The infile IN42 is: Pipe command="unzip -a -p us00042_uf3" NOTE: The infile IN43 is: Pipe command="unzip -a -p us00043_uf3" NOTE: The infile IN44 is: Pipe command="unzip -a -p us00044_uf3" NOTE: The infile IN45 is: Pipe command="unzip -a -p us00045_uf3" NOTE: The infile IN46 is: Pipe command="unzip -a -p us00046_uf3" NOTE: The infile IN47 is: Pipe command="unzip -a -p us00047_uf3" NOTE: The infile IN48 is: Pipe command="unzip -a -p us00048_uf3" NOTE: The infile IN49 is: Pipe command="unzip -a -p us00049_uf3" NOTE: The infile IN50 is: Pipe command="unzip -a -p us00050_uf3" NOTE: The infile IN51 is: Pipe command="unzip -a -p us00051_uf3" NOTE: The infile IN52 is: Pipe command="unzip -a -p us00052_uf3" NOTE: The infile IN53 is: Pipe command="unzip -a -p us00053_uf3" NOTE: The infile IN54 is: Pipe command="unzip -a -p us00054_uf3" NOTE: The infile IN55 is: Pipe command="unzip -a -p us00055_uf3" NOTE: The infile IN56 is: Pipe command="unzip -a -p us00056_uf3" NOTE: The infile IN57 is: Pipe command="unzip -a -p us00057_uf3" NOTE: The infile IN58 is: 40 The SAS System 14:38 Wednesday, June 17, 2009 Pipe command="unzip -a -p us00058_uf3" NOTE: The infile IN59 is: Pipe command="unzip -a -p us00059_uf3" NOTE: The infile IN60 is: Pipe command="unzip -a -p us00060_uf3" NOTE: The infile IN61 is: Pipe command="unzip -a -p us00061_uf3" NOTE: The infile IN62 is: Pipe command="unzip -a -p us00062_uf3" NOTE: The infile IN63 is: Pipe command="unzip -a -p us00063_uf3" NOTE: The infile IN64 is: Pipe command="unzip -a -p us00064_uf3" NOTE: The infile IN65 is: Pipe command="unzip -a -p us00065_uf3" NOTE: The infile IN66 is: Pipe command="unzip -a -p us00066_uf3" NOTE: The infile IN67 is: Pipe command="unzip -a -p us00067_uf3" NOTE: The infile IN68 is: Pipe command="unzip -a -p us00068_uf3" NOTE: The infile IN69 is: Pipe command="unzip -a -p us00069_uf3" NOTE: The infile IN70 is: Pipe command="unzip -a -p us00070_uf3" NOTE: The infile IN71 is: Pipe command="unzip -a -p us00071_uf3" NOTE: The infile IN72 is: Pipe command="unzip -a -p us00072_uf3" NOTE: The infile IN73 is: Pipe command="unzip -a -p us00073_uf3" NOTE: The infile IN74 is: Pipe command="unzip -a -p us00074_uf3" NOTE: The infile IN75 is: Pipe command="unzip -a -p us00075_uf3" NOTE: The infile IN76 is: Pipe command="unzip -a -p us00076_uf3" 41 The SAS System 14:38 Wednesday, June 17, 2009 NOTE: 338019 records were read from the infile GEOS. The minimum record length was 400. The maximum record length was 400. NOTE: 338019 records were read from the infile IN1. The minimum record length was 520. The maximum record length was 1849. NOTE: 338019 records were read from the infile IN2. The minimum record length was 458. The maximum record length was 1574. NOTE: 338019 records were read from the infile IN3. The minimum record length was 504. The maximum record length was 1763. NOTE: 338019 records were read from the infile IN4. The minimum record length was 476. The maximum record length was 1657. NOTE: 338019 records were read from the infile IN5. The minimum record length was 462. The maximum record length was 1540. NOTE: 338019 records were read from the infile IN6. The minimum record length was 522. The maximum record length was 1725. NOTE: 338019 records were read from the infile IN7. The minimum record length was 448. The maximum record length was 1650. NOTE: 338019 records were read from the infile IN8. The minimum record length was 512. The maximum record length was 1969. NOTE: 338019 records were read from the infile IN9. The minimum record length was 428. The maximum record length was 1313. NOTE: 338019 records were read from the infile IN10. The minimum record length was 512. The maximum record length was 1505. NOTE: 338019 records were read from the infile IN11. The minimum record length was 492. The maximum record length was 1453. NOTE: 338019 records were read from the infile IN12. The minimum record length was 514. The maximum record length was 1613. NOTE: 338019 records were read from the infile IN13. The minimum record length was 504. The maximum record length was 1487. NOTE: 338019 records were read from the infile IN14. The minimum record length was 512. The maximum record length was 1511. NOTE: 338019 records were read from the infile IN15. The minimum record length was 500. The maximum record length was 1547. NOTE: 338019 records were read from the infile IN16. The minimum record length was 502. The maximum record length was 1580. NOTE: 338019 records were read from the infile IN17. The minimum record length was 500. The maximum record length was 1405. NOTE: 338019 records were read from the infile IN18. The minimum record length was 350. 42 The SAS System 14:38 Wednesday, June 17, 2009 The maximum record length was 1041. NOTE: 338019 records were read from the infile IN19. The minimum record length was 516. The maximum record length was 1643. NOTE: 338019 records were read from the infile IN20. The minimum record length was 430. The maximum record length was 1383. NOTE: 338019 records were read from the infile IN21. The minimum record length was 466. The maximum record length was 1224. NOTE: 338019 records were read from the infile IN22. The minimum record length was 492. The maximum record length was 1418. NOTE: 338019 records were read from the infile IN23. The minimum record length was 488. The maximum record length was 1515. NOTE: 338019 records were read from the infile IN24. The minimum record length was 488. The maximum record length was 1621. NOTE: 338019 records were read from the infile IN25. The minimum record length was 464. The maximum record length was 1626. NOTE: 338019 records were read from the infile IN26. The minimum record length was 234. The maximum record length was 782. NOTE: 338019 records were read from the infile IN27. The minimum record length was 464. The maximum record length was 1649. NOTE: 338019 records were read from the infile IN28. The minimum record length was 346. The maximum record length was 1186. NOTE: 338019 records were read from the infile IN29. The minimum record length was 432. The maximum record length was 1455. NOTE: 338019 records were read from the infile IN30. The minimum record length was 470. The maximum record length was 1554. NOTE: 338019 records were read from the infile IN31. The minimum record length was 432. The maximum record length was 1393. NOTE: 338019 records were read from the infile IN32. The minimum record length was 508. The maximum record length was 1644. NOTE: 338019 records were read from the infile IN33. The minimum record length was 508. The maximum record length was 1607. NOTE: 338019 records were read from the infile IN34. The minimum record length was 490. The maximum record length was 1462. NOTE: 338019 records were read from the infile IN35. The minimum record length was 484. The maximum record length was 1405. NOTE: 338019 records were read from the infile IN36. The minimum record length was 488. The maximum record length was 1435. NOTE: 338019 records were read from the infile IN37. 43 The SAS System 14:38 Wednesday, June 17, 2009 The minimum record length was 468. The maximum record length was 1453. NOTE: 338019 records were read from the infile IN38. The minimum record length was 512. The maximum record length was 1552. NOTE: 338019 records were read from the infile IN39. The minimum record length was 516. The maximum record length was 1635. NOTE: 338019 records were read from the infile IN40. The minimum record length was 508. The maximum record length was 1535. NOTE: 338019 records were read from the infile IN41. The minimum record length was 512. The maximum record length was 1434. NOTE: 338019 records were read from the infile IN42. The minimum record length was 414. The maximum record length was 1283. NOTE: 338019 records were read from the infile IN43. The minimum record length was 502. The maximum record length was 1400. NOTE: 338019 records were read from the infile IN44. The minimum record length was 502. The maximum record length was 1203. NOTE: 338019 records were read from the infile IN45. The minimum record length was 502. The maximum record length was 1124. NOTE: 338019 records were read from the infile IN46. The minimum record length was 502. The maximum record length was 1302. NOTE: 338019 records were read from the infile IN47. The minimum record length was 452. The maximum record length was 1399. NOTE: 338019 records were read from the infile IN48. The minimum record length was 402. The maximum record length was 1022. NOTE: 338019 records were read from the infile IN49. The minimum record length was 402. The maximum record length was 1006. NOTE: 338019 records were read from the infile IN50. The minimum record length was 402. The maximum record length was 1110. NOTE: 338019 records were read from the infile IN51. The minimum record length was 402. The maximum record length was 1242. NOTE: 338019 records were read from the infile IN52. The minimum record length was 484. The maximum record length was 1419. NOTE: 338019 records were read from the infile IN53. The minimum record length was 494. The maximum record length was 1402. NOTE: 338019 records were read from the infile IN54. The minimum record length was 490. The maximum record length was 1499. NOTE: 338019 records were read from the infile IN55. The minimum record length was 312. The maximum record length was 907. 44 The SAS System 14:38 Wednesday, June 17, 2009 NOTE: 338019 records were read from the infile IN56. The minimum record length was 289. The maximum record length was 954. NOTE: 338019 records were read from the infile IN57. The minimum record length was 522. The maximum record length was 1700. NOTE: 338019 records were read from the infile IN58. The minimum record length was 460. The maximum record length was 1546. NOTE: 338019 records were read from the infile IN59. The minimum record length was 522. The maximum record length was 1734. NOTE: 338019 records were read from the infile IN60. The minimum record length was 520. The maximum record length was 1779. NOTE: 338019 records were read from the infile IN61. The minimum record length was 528. The maximum record length was 1643. NOTE: 338019 records were read from the infile IN62. The minimum record length was 140. The maximum record length was 484. NOTE: 338019 records were read from the infile IN63. The minimum record length was 364. The maximum record length was 1178. NOTE: 338019 records were read from the infile IN64. The minimum record length was 252. The maximum record length was 726. NOTE: 338019 records were read from the infile IN65. The minimum record length was 308. The maximum record length was 933. NOTE: 338019 records were read from the infile IN66. The minimum record length was 518. The maximum record length was 1542. NOTE: 338019 records were read from the infile IN67. The minimum record length was 460. The maximum record length was 1717. NOTE: 338019 records were read from the infile IN68. The minimum record length was 450. The maximum record length was 1873. NOTE: 338019 records were read from the infile IN69. The minimum record length was 462. The maximum record length was 1420. NOTE: 338019 records were read from the infile IN70. The minimum record length was 518. The maximum record length was 1684. NOTE: 338019 records were read from the infile IN71. The minimum record length was 514. The maximum record length was 1598. NOTE: 338019 records were read from the infile IN72. The minimum record length was 532. The maximum record length was 1495. NOTE: 338019 records were read from the infile IN73. The minimum record length was 508. The maximum record length was 1389. NOTE: 338019 records were read from the infile IN74. The minimum record length was 470. 45 The SAS System 14:38 Wednesday, June 17, 2009 The maximum record length was 1159. NOTE: 338019 records were read from the infile IN75. The minimum record length was 516. The maximum record length was 1498. NOTE: 338019 records were read from the infile IN76. The minimum record length was 268. The maximum record length was 565. NOTE: The data set SF32000.USCD106GEOS has 437 observations and 74 variables. NOTE: Compressing data set SF32000.USCD106GEOS decreased size by 37.50 percent. Compressed is 5 pages; un-compressed would require 8 pages. NOTE: The data set SF32000.USCD106PH has 437 observations and 5632 variables. NOTE: Compressing data set SF32000.USCD106PH decreased size by 0.00 percent. Compressed is 233 pages; un-compressed would require 233 pages. NOTE: The data set SF32000.USCD106PHCT has 437 observations and 4465 variables. NOTE: Compressing data set SF32000.USCD106PHCT decreased size by 31.44 percent. Compressed is 157 pages; un-compressed would require 229 pages. NOTE: The data set SF32000.USCD106PHCTR has 437 observations and 6643 variables. NOTE: Compressing data set SF32000.USCD106PHCTR decreased size by 48.01 percent. Compressed is 235 pages; un-compressed would require 452 pages. NOTE: DATA statement used (Total process time): real time 1:06:38.95 cpu time 1:07:43.53 NOTE: DATA STEP view saved on file WORK.SUMLEVS. NOTE: A stored DATA STEP view cannot run under a different operating system. NOTE: DATA statement used (Total process time): real time 0.31 seconds cpu time 0.04 seconds NOTE: View WORK.SUMLEVS.VIEW used (Total process time): real time 1.36 seconds cpu time 0.14 seconds NOTE: There were 437 observations read from the data set SF3.USCD106GEOS. NOTE: There were 437 observations read from the data set WORK.SUMLEVS. NOTE: The PROCEDURE TABULATE printed page 6. NOTE: PROCEDURE TABULATE used (Total process time): real time 1.76 seconds cpu time 0.14 seconds 64378 64379 %docnvt(set=geocomps,sumlevs=010 020 030 040 500,idvars=,indices=,geocomps=1); NOTE: PROCEDURE PRINTTO used (Total process time): real time 0.08 seconds cpu time 0.00 seconds NOTE: There were 5 observations read from the data set SF3.SUMLEV_MEANS. WHERE INDEX('010 020 030 040 500', sumlev); 46 The SAS System 14:38 Wednesday, June 17, 2009 NOTE: The data set WORK.MINMAXOBS has 1 observations and 6 variables. NOTE: The PROCEDURE MEANS printed page 7. NOTE: PROCEDURE MEANS used (Total process time): real time 0.53 seconds cpu time 0.10 seconds _TYPE_=0 _FREQ_=5 minobs=1 minlast=97 maxfirst=7026 maxobs=345044 _ERROR_=0 _N_=1 NOTE: There were 1 observations read from the data set WORK.MINMAXOBS. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds GLOBAL DMRVAL NODMR GLOBAL PGM cnvtsf3us GLOBAL DMSFLAG NODMS GLOBAL MAXOBS 345044 GLOBAL FILESFX uf3 GLOBAL V8 0 GLOBAL V9 1 GLOBAL FIRSTOBS 1 GLOBAL SYSODSPATH SASCTLGS.TEMPLAT(READ) SASHELP.TMPLMST(READ) GLOBAL CURPATH pubdatasf32000Tools GLOBAL UCSTAB US GLOBAL OSEDA oseda.missouri.edu GLOBAL _V9 v9 GLOBAL INPATH pubdatasf32000rawdata GLOBAL REVDATE 02/28/2006 7:40AM NOTE: The infile GEOS is: Pipe command="unzip -a -p /pub/data/sf32000/rawdata/usgeo_uf3" NOTE: The infile IN1 is: Pipe command="unzip -a -p us00001_uf3" NOTE: The infile IN2 is: Pipe command="unzip -a -p us00002_uf3" NOTE: The infile IN3 is: Pipe command="unzip -a -p us00003_uf3" NOTE: The infile IN4 is: Pipe command="unzip -a -p us00004_uf3" NOTE: The infile IN5 is: Pipe command="unzip -a -p us00005_uf3" NOTE: The infile IN6 is: Pipe command="unzip -a -p us00006_uf3" NOTE: The infile IN7 is: Pipe command="unzip -a -p us00007_uf3" NOTE: The infile IN8 is: 47 The SAS System 14:38 Wednesday, June 17, 2009 Pipe command="unzip -a -p us00008_uf3" NOTE: The infile IN9 is: Pipe command="unzip -a -p us00009_uf3" NOTE: The infile IN10 is: Pipe command="unzip -a -p us00010_uf3" NOTE: The infile IN11 is: Pipe command="unzip -a -p us00011_uf3" NOTE: The infile IN12 is: Pipe command="unzip -a -p us00012_uf3" NOTE: The infile IN13 is: Pipe command="unzip -a -p us00013_uf3" NOTE: The infile IN14 is: Pipe command="unzip -a -p us00014_uf3" NOTE: The infile IN15 is: Pipe command="unzip -a -p us00015_uf3" NOTE: The infile IN16 is: Pipe command="unzip -a -p us00016_uf3" NOTE: The infile IN17 is: Pipe command="unzip -a -p us00017_uf3" NOTE: The infile IN18 is: Pipe command="unzip -a -p us00018_uf3" NOTE: The infile IN19 is: Pipe command="unzip -a -p us00019_uf3" NOTE: The infile IN20 is: Pipe command="unzip -a -p us00020_uf3" NOTE: The infile IN21 is: Pipe command="unzip -a -p us00021_uf3" NOTE: The infile IN22 is: Pipe command="unzip -a -p us00022_uf3" NOTE: The infile IN23 is: Pipe command="unzip -a -p us00023_uf3" NOTE: The infile IN24 is: Pipe command="unzip -a -p us00024_uf3" NOTE: The infile IN25 is: Pipe command="unzip -a -p us00025_uf3" NOTE: The infile IN26 is: Pipe command="unzip -a -p us00026_uf3" 48 The SAS System 14:38 Wednesday, June 17, 2009 NOTE: The infile IN27 is: Pipe command="unzip -a -p us00027_uf3" NOTE: The infile IN28 is: Pipe command="unzip -a -p us00028_uf3" NOTE: The infile IN29 is: Pipe command="unzip -a -p us00029_uf3" NOTE: The infile IN30 is: Pipe command="unzip -a -p us00030_uf3" NOTE: The infile IN31 is: Pipe command="unzip -a -p us00031_uf3" NOTE: The infile IN32 is: Pipe command="unzip -a -p us00032_uf3" NOTE: The infile IN33 is: Pipe command="unzip -a -p us00033_uf3" NOTE: The infile IN34 is: Pipe command="unzip -a -p us00034_uf3" NOTE: The infile IN35 is: Pipe command="unzip -a -p us00035_uf3" NOTE: The infile IN36 is: Pipe command="unzip -a -p us00036_uf3" NOTE: The infile IN37 is: Pipe command="unzip -a -p us00037_uf3" NOTE: The infile IN38 is: Pipe command="unzip -a -p us00038_uf3" NOTE: The infile IN39 is: Pipe command="unzip -a -p us00039_uf3" NOTE: The infile IN40 is: Pipe command="unzip -a -p us00040_uf3" NOTE: The infile IN41 is: Pipe command="unzip -a -p us00041_uf3" NOTE: The infile IN42 is: Pipe command="unzip -a -p us00042_uf3" NOTE: The infile IN43 is: Pipe command="unzip -a -p us00043_uf3" NOTE: The infile IN44 is: Pipe command="unzip -a -p us00044_uf3" NOTE: The infile IN45 is: Pipe command="unzip -a -p us00045_uf3" 49 The SAS System 14:38 Wednesday, June 17, 2009 NOTE: The infile IN46 is: Pipe command="unzip -a -p us00046_uf3" NOTE: The infile IN47 is: Pipe command="unzip -a -p us00047_uf3" NOTE: The infile IN48 is: Pipe command="unzip -a -p us00048_uf3" NOTE: The infile IN49 is: Pipe command="unzip -a -p us00049_uf3" NOTE: The infile IN50 is: Pipe command="unzip -a -p us00050_uf3" NOTE: The infile IN51 is: Pipe command="unzip -a -p us00051_uf3" NOTE: The infile IN52 is: Pipe command="unzip -a -p us00052_uf3" NOTE: The infile IN53 is: Pipe command="unzip -a -p us00053_uf3" NOTE: The infile IN54 is: Pipe command="unzip -a -p us00054_uf3" NOTE: The infile IN55 is: Pipe command="unzip -a -p us00055_uf3" NOTE: The infile IN56 is: Pipe command="unzip -a -p us00056_uf3" NOTE: The infile IN57 is: Pipe command="unzip -a -p us00057_uf3" NOTE: The infile IN58 is: Pipe command="unzip -a -p us00058_uf3" NOTE: The infile IN59 is: Pipe command="unzip -a -p us00059_uf3" NOTE: The infile IN60 is: Pipe command="unzip -a -p us00060_uf3" NOTE: The infile IN61 is: Pipe command="unzip -a -p us00061_uf3" NOTE: The infile IN62 is: Pipe command="unzip -a -p us00062_uf3" NOTE: The infile IN63 is: Pipe command="unzip -a -p us00063_uf3" NOTE: The infile IN64 is: 50 The SAS System 14:38 Wednesday, June 17, 2009 Pipe command="unzip -a -p us00064_uf3" NOTE: The infile IN65 is: Pipe command="unzip -a -p us00065_uf3" NOTE: The infile IN66 is: Pipe command="unzip -a -p us00066_uf3" NOTE: The infile IN67 is: Pipe command="unzip -a -p us00067_uf3" NOTE: The infile IN68 is: Pipe command="unzip -a -p us00068_uf3" NOTE: The infile IN69 is: Pipe command="unzip -a -p us00069_uf3" NOTE: The infile IN70 is: Pipe command="unzip -a -p us00070_uf3" NOTE: The infile IN71 is: Pipe command="unzip -a -p us00071_uf3" NOTE: The infile IN72 is: Pipe command="unzip -a -p us00072_uf3" NOTE: The infile IN73 is: Pipe command="unzip -a -p us00073_uf3" NOTE: The infile IN74 is: Pipe command="unzip -a -p us00074_uf3" NOTE: The infile IN75 is: Pipe command="unzip -a -p us00075_uf3" NOTE: The infile IN76 is: Pipe command="unzip -a -p us00076_uf3" NOTE: 345044 records were read from the infile GEOS. The minimum record length was 400. The maximum record length was 400. NOTE: 345044 records were read from the infile IN1. The minimum record length was 520. The maximum record length was 2081. NOTE: 345044 records were read from the infile IN2. The minimum record length was 458. The maximum record length was 1759. NOTE: 345044 records were read from the infile IN3. The minimum record length was 504. The maximum record length was 1984. NOTE: 345044 records were read from the infile IN4. The minimum record length was 476. The maximum record length was 1860. NOTE: 345044 records were read from the infile IN5. The minimum record length was 462. The maximum record length was 1754. 51 The SAS System 14:38 Wednesday, June 17, 2009 NOTE: 345044 records were read from the infile IN6. The minimum record length was 522. The maximum record length was 1962. NOTE: 345044 records were read from the infile IN7. The minimum record length was 448. The maximum record length was 1848. NOTE: 345044 records were read from the infile IN8. The minimum record length was 512. The maximum record length was 2196. NOTE: 345044 records were read from the infile IN9. The minimum record length was 428. The maximum record length was 1515. NOTE: 345044 records were read from the infile IN10. The minimum record length was 512. The maximum record length was 1634. NOTE: 345044 records were read from the infile IN11. The minimum record length was 492. The maximum record length was 1645. NOTE: 345044 records were read from the infile IN12. The minimum record length was 514. The maximum record length was 1793. NOTE: 345044 records were read from the infile IN13. The minimum record length was 504. The maximum record length was 1679. NOTE: 345044 records were read from the infile IN14. The minimum record length was 512. The maximum record length was 1691. NOTE: 345044 records were read from the infile IN15. The minimum record length was 500. The maximum record length was 1722. NOTE: 345044 records were read from the infile IN16. The minimum record length was 502. The maximum record length was 1719. NOTE: 345044 records were read from the infile IN17. The minimum record length was 500. The maximum record length was 1613. NOTE: 345044 records were read from the infile IN18. The minimum record length was 350. The maximum record length was 1155. NOTE: 345044 records were read from the infile IN19. The minimum record length was 516. The maximum record length was 1857. NOTE: 345044 records were read from the infile IN20. The minimum record length was 430. The maximum record length was 1553. NOTE: 345044 records were read from the infile IN21. The minimum record length was 466. The maximum record length was 1437. NOTE: 345044 records were read from the infile IN22. The minimum record length was 492. The maximum record length was 1612. NOTE: 345044 records were read from the infile IN23. The minimum record length was 488. The maximum record length was 1697. NOTE: 345044 records were read from the infile IN24. The minimum record length was 488. 52 The SAS System 14:38 Wednesday, June 17, 2009 The maximum record length was 1837. NOTE: 345044 records were read from the infile IN25. The minimum record length was 464. The maximum record length was 1820. NOTE: 345044 records were read from the infile IN26. The minimum record length was 234. The maximum record length was 877. NOTE: 345044 records were read from the infile IN27. The minimum record length was 464. The maximum record length was 1849. NOTE: 345044 records were read from the infile IN28. The minimum record length was 346. The maximum record length was 1310. NOTE: 345044 records were read from the infile IN29. The minimum record length was 432. The maximum record length was 1626. NOTE: 345044 records were read from the infile IN30. The minimum record length was 470. The maximum record length was 1758. NOTE: 345044 records were read from the infile IN31. The minimum record length was 432. The maximum record length was 1580. NOTE: 345044 records were read from the infile IN32. The minimum record length was 508. The maximum record length was 1861. NOTE: 345044 records were read from the infile IN33. The minimum record length was 508. The maximum record length was 1792. NOTE: 345044 records were read from the infile IN34. The minimum record length was 490. The maximum record length was 1647. NOTE: 345044 records were read from the infile IN35. The minimum record length was 484. The maximum record length was 1600. NOTE: 345044 records were read from the infile IN36. The minimum record length was 488. The maximum record length was 1589. NOTE: 345044 records were read from the infile IN37. The minimum record length was 468. The maximum record length was 1654. NOTE: 345044 records were read from the infile IN38. The minimum record length was 512. The maximum record length was 1678. NOTE: 345044 records were read from the infile IN39. The minimum record length was 516. The maximum record length was 1834. NOTE: 345044 records were read from the infile IN40. The minimum record length was 508. The maximum record length was 1716. NOTE: 345044 records were read from the infile IN41. The minimum record length was 512. The maximum record length was 1623. NOTE: 345044 records were read from the infile IN42. The minimum record length was 414. The maximum record length was 1400. NOTE: 345044 records were read from the infile IN43. 53 The SAS System 14:38 Wednesday, June 17, 2009 The minimum record length was 502. The maximum record length was 1664. NOTE: 345044 records were read from the infile IN44. The minimum record length was 502. The maximum record length was 1348. NOTE: 345044 records were read from the infile IN45. The minimum record length was 502. The maximum record length was 1237. NOTE: 345044 records were read from the infile IN46. The minimum record length was 502. The maximum record length was 1453. NOTE: 345044 records were read from the infile IN47. The minimum record length was 452. The maximum record length was 1619. NOTE: 345044 records were read from the infile IN48. The minimum record length was 402. The maximum record length was 1209. NOTE: 345044 records were read from the infile IN49. The minimum record length was 402. The maximum record length was 1096. NOTE: 345044 records were read from the infile IN50. The minimum record length was 402. The maximum record length was 1212. NOTE: 345044 records were read from the infile IN51. The minimum record length was 402. The maximum record length was 1398. NOTE: 345044 records were read from the infile IN52. The minimum record length was 484. The maximum record length was 1596. NOTE: 345044 records were read from the infile IN53. The minimum record length was 494. The maximum record length was 1514. NOTE: 345044 records were read from the infile IN54. The minimum record length was 490. The maximum record length was 1710. NOTE: 345044 records were read from the infile IN55. The minimum record length was 312. The maximum record length was 998. NOTE: 345044 records were read from the infile IN56. The minimum record length was 289. The maximum record length was 1060. NOTE: 345044 records were read from the infile IN57. The minimum record length was 522. The maximum record length was 1912. NOTE: 345044 records were read from the infile IN58. The minimum record length was 460. The maximum record length was 1745. NOTE: 345044 records were read from the infile IN59. The minimum record length was 522. The maximum record length was 1967. NOTE: 345044 records were read from the infile IN60. The minimum record length was 520. The maximum record length was 1999. NOTE: 345044 records were read from the infile IN61. The minimum record length was 528. The maximum record length was 1898. 54 The SAS System 14:38 Wednesday, June 17, 2009 NOTE: 345044 records were read from the infile IN62. The minimum record length was 140. The maximum record length was 543. NOTE: 345044 records were read from the infile IN63. The minimum record length was 364. The maximum record length was 1336. NOTE: 345044 records were read from the infile IN64. The minimum record length was 252. The maximum record length was 835. NOTE: 345044 records were read from the infile IN65. The minimum record length was 308. The maximum record length was 1076. NOTE: 345044 records were read from the infile IN66. The minimum record length was 518. The maximum record length was 1775. NOTE: 345044 records were read from the infile IN67. The minimum record length was 460. The maximum record length was 1934. NOTE: 345044 records were read from the infile IN68. The minimum record length was 450. The maximum record length was 2104. NOTE: 345044 records were read from the infile IN69. The minimum record length was 462. The maximum record length was 1615. NOTE: 345044 records were read from the infile IN70. The minimum record length was 518. The maximum record length was 1900. NOTE: 345044 records were read from the infile IN71. The minimum record length was 514. The maximum record length was 1785. NOTE: 345044 records were read from the infile IN72. The minimum record length was 532. The maximum record length was 1654. NOTE: 345044 records were read from the infile IN73. The minimum record length was 508. The maximum record length was 1601. NOTE: 345044 records were read from the infile IN74. The minimum record length was 470. The maximum record length was 1354. NOTE: 345044 records were read from the infile IN75. The minimum record length was 516. The maximum record length was 1691. NOTE: 345044 records were read from the infile IN76. The minimum record length was 268. The maximum record length was 621. NOTE: The data set SF32000.USGEOCOMPSGEOS has 6141 observations and 74 variables. NOTE: Compressing data set SF32000.USGEOCOMPSGEOS decreased size by 69.16 percent. Compressed is 33 pages; un-compressed would require 107 pages. NOTE: The data set SF32000.USGEOCOMPSPH has 6141 observations and 5632 variables. NOTE: Compressing data set SF32000.USGEOCOMPSPH decreased size by 29.30 percent. Compressed is 2181 pages; un-compressed would require 3085 pages. NOTE: The data set SF32000.USGEOCOMPSPHCT has 6141 observations and 4465 variables. NOTE: Compressing data set SF32000.USGEOCOMPSPHCT decreased size by 50.86 percent. Compressed is 1514 pages; un-compressed would require 3081 pages. NOTE: The data set SF32000.USGEOCOMPSPHCTR has 6141 observations and 6643 variables. NOTE: Compressing data set SF32000.USGEOCOMPSPHCTR decreased size by 66.99 percent. 55 The SAS System 14:38 Wednesday, June 17, 2009 Compressed is 2032 pages; un-compressed would require 6156 pages. NOTE: DATA statement used (Total process time): real time 1:08:49.80 cpu time 1:08:17.86 NOTE: DATA STEP view saved on file WORK.SUMLEVS. NOTE: A stored DATA STEP view cannot run under a different operating system. NOTE: DATA statement used (Total process time): real time 0.28 seconds cpu time 0.01 seconds NOTE: No observations in data set WORK.SUMLEVS. NOTE: View WORK.SUMLEVS.VIEW used (Total process time): real time 1.22 seconds cpu time 0.15 seconds NOTE: There were 6141 observations read from the data set SF3.USGEOCOMPSGEOS. NOTE: There were 0 observations read from the data set WORK.SUMLEVS. NOTE: PROCEDURE TABULATE used (Total process time): real time 1.54 seconds cpu time 0.17 seconds 85567 %docnvt(set=cousubs,sumlevs=060,indices=,geocomps=0) NOTE: PROCEDURE PRINTTO used (Total process time): real time 0.04 seconds cpu time 0.01 seconds NOTE: There were 1 observations read from the data set SF3.SUMLEV_MEANS. WHERE INDEX('060', sumlev); NOTE: The data set WORK.MINMAXOBS has 1 observations and 6 variables. NOTE: The PROCEDURE MEANS printed page 8. NOTE: PROCEDURE MEANS used (Total process time): real time 0.75 seconds cpu time 0.10 seconds _TYPE_=0 _FREQ_=1 minobs=1417 minlast=343665 maxfirst=1417 maxobs=343665 _ERROR_=0 _N_=1 NOTE: There were 1 observations read from the data set WORK.MINMAXOBS. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds GLOBAL DMRVAL NODMR GLOBAL PGM cnvtsf3us GLOBAL DMSFLAG NODMS GLOBAL MAXOBS 343665 56 The SAS System 14:38 Wednesday, June 17, 2009 GLOBAL FILESFX uf3 GLOBAL V8 0 GLOBAL V9 1 GLOBAL FIRSTOBS 1417 GLOBAL SYSODSPATH SASCTLGS.TEMPLAT(READ) SASHELP.TMPLMST(READ) GLOBAL CURPATH pubdatasf32000Tools GLOBAL UCSTAB US GLOBAL OSEDA oseda.missouri.edu GLOBAL _V9 v9 GLOBAL INPATH pubdatasf32000rawdata GLOBAL REVDATE 02/28/2006 7:40AM NOTE: The infile GEOS is: Pipe command="unzip -a -p /pub/data/sf32000/rawdata/usgeo_uf3" NOTE: The infile IN1 is: Pipe command="unzip -a -p us00001_uf3" NOTE: The infile IN2 is: Pipe command="unzip -a -p us00002_uf3" NOTE: The infile IN3 is: Pipe command="unzip -a -p us00003_uf3" NOTE: The infile IN4 is: Pipe command="unzip -a -p us00004_uf3" NOTE: The infile IN5 is: Pipe command="unzip -a -p us00005_uf3" NOTE: The infile IN6 is: Pipe command="unzip -a -p us00006_uf3" NOTE: The infile IN7 is: Pipe command="unzip -a -p us00007_uf3" NOTE: The infile IN8 is: Pipe command="unzip -a -p us00008_uf3" NOTE: The infile IN9 is: Pipe command="unzip -a -p us00009_uf3" NOTE: The infile IN10 is: Pipe command="unzip -a -p us00010_uf3" NOTE: The infile IN11 is: Pipe command="unzip -a -p us00011_uf3" NOTE: The infile IN12 is: Pipe command="unzip -a -p us00012_uf3" NOTE: The infile IN13 is: Pipe command="unzip -a -p us00013_uf3" NOTE: The infile IN14 is: Pipe command="unzip -a -p us00014_uf3" 57 The SAS System 14:38 Wednesday, June 17, 2009 NOTE: The infile IN15 is: Pipe command="unzip -a -p us00015_uf3" NOTE: The infile IN16 is: Pipe command="unzip -a -p us00016_uf3" NOTE: The infile IN17 is: Pipe command="unzip -a -p us00017_uf3" NOTE: The infile IN18 is: Pipe command="unzip -a -p us00018_uf3" NOTE: The infile IN19 is: Pipe command="unzip -a -p us00019_uf3" NOTE: The infile IN20 is: Pipe command="unzip -a -p us00020_uf3" NOTE: The infile IN21 is: Pipe command="unzip -a -p us00021_uf3" NOTE: The infile IN22 is: Pipe command="unzip -a -p us00022_uf3" NOTE: The infile IN23 is: Pipe command="unzip -a -p us00023_uf3" NOTE: The infile IN24 is: Pipe command="unzip -a -p us00024_uf3" NOTE: The infile IN25 is: Pipe command="unzip -a -p us00025_uf3" NOTE: The infile IN26 is: Pipe command="unzip -a -p us00026_uf3" NOTE: The infile IN27 is: Pipe command="unzip -a -p us00027_uf3" NOTE: The infile IN28 is: Pipe command="unzip -a -p us00028_uf3" NOTE: The infile IN29 is: Pipe command="unzip -a -p us00029_uf3" NOTE: The infile IN30 is: Pipe command="unzip -a -p us00030_uf3" NOTE: The infile IN31 is: Pipe command="unzip -a -p us00031_uf3" NOTE: The infile IN32 is: Pipe command="unzip -a -p us00032_uf3" NOTE: The infile IN33 is: 58 The SAS System 14:38 Wednesday, June 17, 2009 Pipe command="unzip -a -p us00033_uf3" NOTE: The infile IN34 is: Pipe command="unzip -a -p us00034_uf3" NOTE: The infile IN35 is: Pipe command="unzip -a -p us00035_uf3" NOTE: The infile IN36 is: Pipe command="unzip -a -p us00036_uf3" NOTE: The infile IN37 is: Pipe command="unzip -a -p us00037_uf3" NOTE: The infile IN38 is: Pipe command="unzip -a -p us00038_uf3" NOTE: The infile IN39 is: Pipe command="unzip -a -p us00039_uf3" NOTE: The infile IN40 is: Pipe command="unzip -a -p us00040_uf3" NOTE: The infile IN41 is: Pipe command="unzip -a -p us00041_uf3" NOTE: The infile IN42 is: Pipe command="unzip -a -p us00042_uf3" NOTE: The infile IN43 is: Pipe command="unzip -a -p us00043_uf3" NOTE: The infile IN44 is: Pipe command="unzip -a -p us00044_uf3" NOTE: The infile IN45 is: Pipe command="unzip -a -p us00045_uf3" NOTE: The infile IN46 is: Pipe command="unzip -a -p us00046_uf3" NOTE: The infile IN47 is: Pipe command="unzip -a -p us00047_uf3" NOTE: The infile IN48 is: Pipe command="unzip -a -p us00048_uf3" NOTE: The infile IN49 is: Pipe command="unzip -a -p us00049_uf3" NOTE: The infile IN50 is: Pipe command="unzip -a -p us00050_uf3" NOTE: The infile IN51 is: Pipe command="unzip -a -p us00051_uf3" 59 The SAS System 14:38 Wednesday, June 17, 2009 NOTE: The infile IN52 is: Pipe command="unzip -a -p us00052_uf3" NOTE: The infile IN53 is: Pipe command="unzip -a -p us00053_uf3" NOTE: The infile IN54 is: Pipe command="unzip -a -p us00054_uf3" NOTE: The infile IN55 is: Pipe command="unzip -a -p us00055_uf3" NOTE: The infile IN56 is: Pipe command="unzip -a -p us00056_uf3" NOTE: The infile IN57 is: Pipe command="unzip -a -p us00057_uf3" NOTE: The infile IN58 is: Pipe command="unzip -a -p us00058_uf3" NOTE: The infile IN59 is: Pipe command="unzip -a -p us00059_uf3" NOTE: The infile IN60 is: Pipe command="unzip -a -p us00060_uf3" NOTE: The infile IN61 is: Pipe command="unzip -a -p us00061_uf3" NOTE: The infile IN62 is: Pipe command="unzip -a -p us00062_uf3" NOTE: The infile IN63 is: Pipe command="unzip -a -p us00063_uf3" NOTE: The infile IN64 is: Pipe command="unzip -a -p us00064_uf3" NOTE: The infile IN65 is: Pipe command="unzip -a -p us00065_uf3" NOTE: The infile IN66 is: Pipe command="unzip -a -p us00066_uf3" NOTE: The infile IN67 is: Pipe command="unzip -a -p us00067_uf3" NOTE: The infile IN68 is: Pipe command="unzip -a -p us00068_uf3" NOTE: The infile IN69 is: Pipe command="unzip -a -p us00069_uf3" NOTE: The infile IN70 is: Pipe command="unzip -a -p us00070_uf3" 60 The SAS System 14:38 Wednesday, June 17, 2009 NOTE: The infile IN71 is: Pipe command="unzip -a -p us00071_uf3" NOTE: The infile IN72 is: Pipe command="unzip -a -p us00072_uf3" NOTE: The infile IN73 is: Pipe command="unzip -a -p us00073_uf3" NOTE: The infile IN74 is: Pipe command="unzip -a -p us00074_uf3" NOTE: The infile IN75 is: Pipe command="unzip -a -p us00075_uf3" NOTE: The infile IN76 is: Pipe command="unzip -a -p us00076_uf3" NOTE: 342249 records were read from the infile GEOS. The minimum record length was 400. The maximum record length was 400. NOTE: 342249 records were read from the infile IN1. The minimum record length was 520. The maximum record length was 1849. NOTE: 342249 records were read from the infile IN2. The minimum record length was 458. The maximum record length was 1574. NOTE: 342249 records were read from the infile IN3. The minimum record length was 504. The maximum record length was 1763. NOTE: 342249 records were read from the infile IN4. The minimum record length was 476. The maximum record length was 1657. NOTE: 342249 records were read from the infile IN5. The minimum record length was 462. The maximum record length was 1540. NOTE: 342249 records were read from the infile IN6. The minimum record length was 522. The maximum record length was 1725. NOTE: 342249 records were read from the infile IN7. The minimum record length was 448. The maximum record length was 1650. NOTE: 342249 records were read from the infile IN8. The minimum record length was 512. The maximum record length was 1969. NOTE: 342249 records were read from the infile IN9. The minimum record length was 428. The maximum record length was 1313. NOTE: 342249 records were read from the infile IN10. The minimum record length was 512. The maximum record length was 1505. NOTE: 342249 records were read from the infile IN11. The minimum record length was 492. The maximum record length was 1453. NOTE: 342249 records were read from the infile IN12. 61 The SAS System 14:38 Wednesday, June 17, 2009 The minimum record length was 514. The maximum record length was 1613. NOTE: 342249 records were read from the infile IN13. The minimum record length was 504. The maximum record length was 1487. NOTE: 342249 records were read from the infile IN14. The minimum record length was 512. The maximum record length was 1511. NOTE: 342249 records were read from the infile IN15. The minimum record length was 500. The maximum record length was 1547. NOTE: 342249 records were read from the infile IN16. The minimum record length was 502. The maximum record length was 1580. NOTE: 342249 records were read from the infile IN17. The minimum record length was 500. The maximum record length was 1405. NOTE: 342249 records were read from the infile IN18. The minimum record length was 350. The maximum record length was 1041. NOTE: 342249 records were read from the infile IN19. The minimum record length was 516. The maximum record length was 1643. NOTE: 342249 records were read from the infile IN20. The minimum record length was 430. The maximum record length was 1383. NOTE: 342249 records were read from the infile IN21. The minimum record length was 466. The maximum record length was 1224. NOTE: 342249 records were read from the infile IN22. The minimum record length was 492. The maximum record length was 1418. NOTE: 342249 records were read from the infile IN23. The minimum record length was 488. The maximum record length was 1515. NOTE: 342249 records were read from the infile IN24. The minimum record length was 488. The maximum record length was 1621. NOTE: 342249 records were read from the infile IN25. The minimum record length was 464. The maximum record length was 1626. NOTE: 342249 records were read from the infile IN26. The minimum record length was 234. The maximum record length was 782. NOTE: 342249 records were read from the infile IN27. The minimum record length was 464. The maximum record length was 1649. NOTE: 342249 records were read from the infile IN28. The minimum record length was 346. The maximum record length was 1186. NOTE: 342249 records were read from the infile IN29. The minimum record length was 432. The maximum record length was 1455. NOTE: 342249 records were read from the infile IN30. The minimum record length was 470. The maximum record length was 1554. 62 The SAS System 14:38 Wednesday, June 17, 2009 NOTE: 342249 records were read from the infile IN31. The minimum record length was 432. The maximum record length was 1393. NOTE: 342249 records were read from the infile IN32. The minimum record length was 508. The maximum record length was 1644. NOTE: 342249 records were read from the infile IN33. The minimum record length was 508. The maximum record length was 1607. NOTE: 342249 records were read from the infile IN34. The minimum record length was 490. The maximum record length was 1462. NOTE: 342249 records were read from the infile IN35. The minimum record length was 484. The maximum record length was 1405. NOTE: 342249 records were read from the infile IN36. The minimum record length was 488. The maximum record length was 1435. NOTE: 342249 records were read from the infile IN37. The minimum record length was 468. The maximum record length was 1453. NOTE: 342249 records were read from the infile IN38. The minimum record length was 512. The maximum record length was 1552. NOTE: 342249 records were read from the infile IN39. The minimum record length was 516. The maximum record length was 1635. NOTE: 342249 records were read from the infile IN40. The minimum record length was 508. The maximum record length was 1535. NOTE: 342249 records were read from the infile IN41. The minimum record length was 512. The maximum record length was 1434. NOTE: 342249 records were read from the infile IN42. The minimum record length was 414. The maximum record length was 1283. NOTE: 342249 records were read from the infile IN43. The minimum record length was 502. The maximum record length was 1400. NOTE: 342249 records were read from the infile IN44. The minimum record length was 502. The maximum record length was 1203. NOTE: 342249 records were read from the infile IN45. The minimum record length was 502. The maximum record length was 1124. NOTE: 342249 records were read from the infile IN46. The minimum record length was 502. The maximum record length was 1302. NOTE: 342249 records were read from the infile IN47. The minimum record length was 452. The maximum record length was 1399. NOTE: 342249 records were read from the infile IN48. The minimum record length was 402. The maximum record length was 1022. NOTE: 342249 records were read from the infile IN49. The minimum record length was 402. 63 The SAS System 14:38 Wednesday, June 17, 2009 The maximum record length was 1006. NOTE: 342249 records were read from the infile IN50. The minimum record length was 402. The maximum record length was 1110. NOTE: 342249 records were read from the infile IN51. The minimum record length was 402. The maximum record length was 1242. NOTE: 342249 records were read from the infile IN52. The minimum record length was 484. The maximum record length was 1419. NOTE: 342249 records were read from the infile IN53. The minimum record length was 494. The maximum record length was 1402. NOTE: 342249 records were read from the infile IN54. The minimum record length was 490. The maximum record length was 1499. NOTE: 342249 records were read from the infile IN55. The minimum record length was 312. The maximum record length was 907. NOTE: 342249 records were read from the infile IN56. The minimum record length was 289. The maximum record length was 954. NOTE: 342249 records were read from the infile IN57. The minimum record length was 522. The maximum record length was 1700. NOTE: 342249 records were read from the infile IN58. The minimum record length was 460. The maximum record length was 1546. NOTE: 342249 records were read from the infile IN59. The minimum record length was 522. The maximum record length was 1734. NOTE: 342249 records were read from the infile IN60. The minimum record length was 520. The maximum record length was 1779. NOTE: 342249 records were read from the infile IN61. The minimum record length was 528. The maximum record length was 1643. NOTE: 342249 records were read from the infile IN62. The minimum record length was 140. The maximum record length was 484. NOTE: 342249 records were read from the infile IN63. The minimum record length was 364. The maximum record length was 1178. NOTE: 342249 records were read from the infile IN64. The minimum record length was 252. The maximum record length was 726. NOTE: 342249 records were read from the infile IN65. The minimum record length was 308. The maximum record length was 933. NOTE: 342249 records were read from the infile IN66. The minimum record length was 518. The maximum record length was 1542. NOTE: 342249 records were read from the infile IN67. The minimum record length was 460. The maximum record length was 1717. NOTE: 342249 records were read from the infile IN68. 64 The SAS System 14:38 Wednesday, June 17, 2009 The minimum record length was 450. The maximum record length was 1873. NOTE: 342249 records were read from the infile IN69. The minimum record length was 462. The maximum record length was 1420. NOTE: 342249 records were read from the infile IN70. The minimum record length was 518. The maximum record length was 1684. NOTE: 342249 records were read from the infile IN71. The minimum record length was 514. The maximum record length was 1598. NOTE: 342249 records were read from the infile IN72. The minimum record length was 532. The maximum record length was 1495. NOTE: 342249 records were read from the infile IN73. The minimum record length was 508. The maximum record length was 1389. NOTE: 342249 records were read from the infile IN74. The minimum record length was 470. The maximum record length was 1159. NOTE: 342249 records were read from the infile IN75. The minimum record length was 516. The maximum record length was 1498. NOTE: 342249 records were read from the infile IN76. The minimum record length was 268. The maximum record length was 565. NOTE: The data set SF32000.USCOUSUBSGEOS has 36351 observations and 74 variables. NOTE: Compressing data set SF32000.USCOUSUBSGEOS decreased size by 58.12 percent. Compressed is 263 pages; un-compressed would require 628 pages. NOTE: The data set SF32000.USCOUSUBSPH has 36351 observations and 5632 variables. NOTE: Compressing data set SF32000.USCOUSUBSPH decreased size by 56.33 percent. Compressed is 7944 pages; un-compressed would require 18190 pages. NOTE: The data set SF32000.USCOUSUBSPHCT has 36351 observations and 4465 variables. NOTE: Compressing data set SF32000.USCOUSUBSPHCT decreased size by 65.81 percent. Compressed is 6217 pages; un-compressed would require 18186 pages. NOTE: The data set SF32000.USCOUSUBSPHCTR has 36351 observations and 6643 variables. NOTE: Compressing data set SF32000.USCOUSUBSPHCTR decreased size by 88.18 percent. Compressed is 4299 pages; un-compressed would require 36366 pages. NOTE: DATA statement used (Total process time): real time 1:20:31.67 cpu time 1:19:53.26 NOTE: DATA STEP view saved on file WORK.SUMLEVS. NOTE: A stored DATA STEP view cannot run under a different operating system. NOTE: DATA statement used (Total process time): real time 0.32 seconds cpu time 0.00 seconds NOTE: View WORK.SUMLEVS.VIEW used (Total process time): real time 2.48 seconds cpu time 0.56 seconds 65 The SAS System 14:38 Wednesday, June 17, 2009 NOTE: There were 36351 observations read from the data set SF3.USCOUSUBSGEOS. NOTE: There were 36351 observations read from the data set WORK.SUMLEVS. NOTE: The PROCEDURE TABULATE printed page 9. NOTE: PROCEDURE TABULATE used (Total process time): real time 2.91 seconds cpu time 0.56 seconds 106755 106756 106757 %include sascode(notify); *<==========Missouri only, delete everywhere else!!!=====; 0 **** cnvtsf3us (270384) has completed 17JUN09 20:47:40 syserr=0 sysrc= 0 ***** NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414 NOTE: The SAS System used: real time 6:08:58.55 cpu time 6:05:18.14