1 The SAS System 08:39 Tuesday, June 23, 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.24 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 Tuesday 23JUN09 at 08:39 PID=626818 NOTE: AUTOEXEC processing completed. 1 x cd /pub/data/sf32000/Tools 1 ! ; %let pgm=agg_uspumas; filename pgm "&pgm..sas"; 2 The SAS System 08:39 Tuesday, June 23, 2009 2 *---3-2-09 (do-over): Allocate split BG data to 5% PUMAs for entire US.---; 3 *----6-23-09: Rerunning to add Logrecno variable with value = obs #. This is for consistency with sf32000x.uspumas 3 ! which has 4 such a value and which is used as a key by the sf3tabgen websas pgm. ----; 5 %include '/pub/sascode/mcdc3.sas'; NOTE: Unable to open SASUSER.PROFILE. WORK.PROFILE will be opened instead. NOTE: All profile changes will be lost at the end of the session. NOTE: Libref XXSL090 was successfully assigned as follows: Engine: REMOTE Physical Name: C:\MCDC\DATA\SF32000\XXSL090 NOTE: Libref XXTRBGS was successfully assigned as follows: Engine: REMOTE Physical Name: C:\MCDC\DATA\SF32000\XXTRBGS 9 ***libname xxsl090 server=mcdc3.mcdcshr3; **this libname is defined in the above included module--; 10 libname sf32000 '/pub/data/sf32000'; NOTE: Libref SF32000 was successfully assigned as follows: Engine: V9 Physical Name: /pub/data/sf32000 11 libname temp '/pub/data/sf32000/temp'; NOTE: Libref TEMP was successfully assigned as follows: Engine: V9 Physical Name: /pub/data/sf32000/temp 12 %libname (corrlst); NOTE: Libref CORRLST was successfully assigned as follows: Levels: 1 Engine(1): V9 Physical Name(1): /pub/data/corrlst 13 %let statenm=Delaware; 14 15 %let bgkeys=county cousubfp placefp tract urbanrur bg; 16 17 %Macro preexit; %mend; 18 19 %Macro postexit; 20 SumLev='795'; 21 if state='29' then areaname=put(puma5,$mopuma.); else areaname="&statenm PUMA "||puma5; 22 geocode=state||puma5; 23 drop afact; 24 %mend postexit; 25 26 27 28 %macro doit(state,stab); 29 /*proc means data=xxsl090.&stab.ph(keep=county pop100) sum; class county; var pop100; run; 30 proc means data=corrlst.sbg2k_puma_&stab(keep=county pop2k) sum ; class county; var pop2k; run; */ 31 32 data agginph; 33 merge xxsl090.&stab.ph(in=insf3 where=(pop100)) corrlst.sbg2k_puma_&stab(in=inclist where=(pop2k)); 34 by &bgkeys ; 35 36 if not (insf3 and inclist) then do; 37 _nbad+1; if _nbad le 20 then put insf3= inclist= pop2k= pop100= afact= +1 &bgkeys; 38 if _nbad ge 100 then abort abend; 39 if insf3; 40 end; 41 *--Calculate 2 new universe variables needed for aggregating. These are the 100 pct counts for occupied and vacant 3 The SAS System 08:39 Tuesday, June 23, 2009 41 ! hus-; 42 if H4i1 then H3i2=100*(H2i2/H4i1); *--100% count of occ units is occ units sampled divided by pct occ units 42 ! sampled-; 43 if H4i2 then H3i3=100*(H2i3/H4i2); *--100% count of vac units is vac units sampled divided by pct vac units 43 ! sampled-; 44 label H3i2='100% Count of Occupied hus (derived)' H3i3='100% Count of Vacant units (derived)'; 45 drop PCT; *--this was a little flag var we set which is irrelevant after aggregation-; 46 keep SumLev State county puma5 areaname _numeric_; 47 run; 48 proc datasets library=work; 49 modify agginph; 50 index create puma5; 51 quit; 52 53 proc means data=agginph sum ; class state county; var pop100; run cancel; *<---just a test for early run to make 53 ! sure...--; 54 55 56 options nomprint; 57 58 %aggsf3( 59 settypes=ph, 60 steps=agg post, 61 setinlib=work, 62 setin=aggin&stab, 63 setoutlib=temp, 64 setout=&stab.pumas, 65 aggby=puma5, 66 idlens=SumLev $3 geocode $7 AreaName $64, 67 idvs=state, 68 afact=afact, 69 compress=no, 70 report=0); 71 72 %mend doit; 73 options mprint; 74 75 %*doit(10,de) ; 76 %*dostates(n=51,names=1,msgs=1) ; 77 78 %macro doit(state,stab); 79 temp.&stab.pumasph 80 %mend doit; 81 82 *---concatenate the 51 state datasets to create the uspumasph data set---; 83 data sf32000.uspumasph(label='P & H table data for all 5% PUMA areas in U.S.' index=(state)); 84 retain Logrecno 0; 85 set 86 %dostates(n=51) MPRINT(DOIT): temp.alpumasph MPRINT(DOIT): temp.akpumasph MPRINT(DOIT): temp.azpumasph MPRINT(DOIT): temp.arpumasph MPRINT(DOIT): temp.capumasph MPRINT(DOIT): temp.copumasph MPRINT(DOIT): temp.ctpumasph 4 The SAS System 08:39 Tuesday, June 23, 2009 MPRINT(DOIT): temp.depumasph MPRINT(DOIT): temp.dcpumasph MPRINT(DOIT): temp.flpumasph MPRINT(DOIT): temp.gapumasph MPRINT(DOIT): temp.hipumasph MPRINT(DOIT): temp.idpumasph MPRINT(DOIT): temp.ilpumasph MPRINT(DOIT): temp.inpumasph MPRINT(DOIT): temp.iapumasph MPRINT(DOIT): temp.kspumasph MPRINT(DOIT): temp.kypumasph MPRINT(DOIT): temp.lapumasph MPRINT(DOIT): temp.mepumasph MPRINT(DOIT): temp.mdpumasph MPRINT(DOIT): temp.mapumasph MPRINT(DOIT): temp.mipumasph MPRINT(DOIT): temp.mnpumasph MPRINT(DOIT): temp.mspumasph MPRINT(DOIT): temp.mopumasph MPRINT(DOIT): temp.mtpumasph MPRINT(DOIT): temp.nepumasph MPRINT(DOIT): temp.nvpumasph MPRINT(DOIT): temp.nhpumasph MPRINT(DOIT): temp.njpumasph MPRINT(DOIT): temp.nmpumasph MPRINT(DOIT): temp.nypumasph MPRINT(DOIT): temp.ncpumasph MPRINT(DOIT): temp.ndpumasph MPRINT(DOIT): temp.ohpumasph MPRINT(DOIT): temp.okpumasph MPRINT(DOIT): temp.orpumasph MPRINT(DOIT): temp.papumasph MPRINT(DOIT): temp.ripumasph MPRINT(DOIT): temp.scpumasph MPRINT(DOIT): temp.sdpumasph MPRINT(DOIT): temp.tnpumasph MPRINT(DOIT): temp.txpumasph MPRINT(DOIT): temp.utpumasph MPRINT(DOIT): temp.vtpumasph MPRINT(DOIT): temp.vapumasph MPRINT(DOIT): temp.wapumasph MPRINT(DOIT): temp.wvpumasph MPRINT(DOIT): temp.wipumasph MPRINT(DOIT): temp.wypumasph 87 open=defer 88 ; 89 LogRecNo+1; 90 run; NOTE: There were 30 observations read from the data set TEMP.ALPUMASPH. NOTE: There were 5 observations read from the data set TEMP.AKPUMASPH. NOTE: There were 36 observations read from the data set TEMP.AZPUMASPH. NOTE: There were 19 observations read from the data set TEMP.ARPUMASPH. NOTE: There were 233 observations read from the data set TEMP.CAPUMASPH. NOTE: There were 38 observations read from the data set TEMP.COPUMASPH. NOTE: There were 25 observations read from the data set TEMP.CTPUMASPH. 5 The SAS System 08:39 Tuesday, June 23, 2009 NOTE: There were 6 observations read from the data set TEMP.DEPUMASPH. NOTE: There were 5 observations read from the data set TEMP.DCPUMASPH. NOTE: There were 127 observations read from the data set TEMP.FLPUMASPH. NOTE: There were 63 observations read from the data set TEMP.GAPUMASPH. NOTE: There were 9 observations read from the data set TEMP.HIPUMASPH. NOTE: There were 9 observations read from the data set TEMP.IDPUMASPH. NOTE: There were 87 observations read from the data set TEMP.ILPUMASPH. NOTE: There were 48 observations read from the data set TEMP.INPUMASPH. NOTE: There were 19 observations read from the data set TEMP.IAPUMASPH. NOTE: There were 21 observations read from the data set TEMP.KSPUMASPH. NOTE: There were 30 observations read from the data set TEMP.KYPUMASPH. NOTE: There were 36 observations read from the data set TEMP.LAPUMASPH. NOTE: There were 10 observations read from the data set TEMP.MEPUMASPH. NOTE: There were 44 observations read from the data set TEMP.MDPUMASPH. NOTE: There were 52 observations read from the data set TEMP.MAPUMASPH. NOTE: There were 68 observations read from the data set TEMP.MIPUMASPH. NOTE: There were 37 observations read from the data set TEMP.MNPUMASPH. NOTE: There were 23 observations read from the data set TEMP.MSPUMASPH. NOTE: There were 41 observations read from the data set TEMP.MOPUMASPH. NOTE: There were 7 observations read from the data set TEMP.MTPUMASPH. NOTE: There were 14 observations read from the data set TEMP.NEPUMASPH. NOTE: There were 15 observations read from the data set TEMP.NVPUMASPH. NOTE: There were 11 observations read from the data set TEMP.NHPUMASPH. NOTE: There were 61 observations read from the data set TEMP.NJPUMASPH. NOTE: There were 15 observations read from the data set TEMP.NMPUMASPH. NOTE: There were 143 observations read from the data set TEMP.NYPUMASPH. NOTE: There were 58 observations read from the data set TEMP.NCPUMASPH. NOTE: There were 5 observations read from the data set TEMP.NDPUMASPH. NOTE: There were 91 observations read from the data set TEMP.OHPUMASPH. NOTE: There were 18 observations read from the data set TEMP.OKPUMASPH. NOTE: There were 27 observations read from the data set TEMP.ORPUMASPH. NOTE: There were 92 observations read from the data set TEMP.PAPUMASPH. NOTE: There were 7 observations read from the data set TEMP.RIPUMASPH. NOTE: There were 27 observations read from the data set TEMP.SCPUMASPH. NOTE: There were 7 observations read from the data set TEMP.SDPUMASPH. NOTE: There were 44 observations read from the data set TEMP.TNPUMASPH. NOTE: There were 153 observations read from the data set TEMP.TXPUMASPH. NOTE: There were 16 observations read from the data set TEMP.UTPUMASPH. NOTE: There were 4 observations read from the data set TEMP.VTPUMASPH. NOTE: There were 42 observations read from the data set TEMP.VAPUMASPH. NOTE: There were 46 observations read from the data set TEMP.WAPUMASPH. NOTE: There were 12 observations read from the data set TEMP.WVPUMASPH. NOTE: There were 31 observations read from the data set TEMP.WIPUMASPH. NOTE: There were 4 observations read from the data set TEMP.WYPUMASPH. NOTE: The data set SF32000.USPUMASPH has 2071 observations and 5572 variables. NOTE: DATA statement used (Total process time): real time 42.54 seconds cpu time 25.73 seconds 91 92 proc datasets library=sf32000 nolist; 93 index create logrecno; ERROR: There is no data set to modify. 94 quit; 6 The SAS System 08:39 Tuesday, June 23, 2009 NOTE: Statements not processed because of errors noted above. NOTE: The SAS System stopped processing this step because of errors. NOTE: SAS set option OBS=0 and will continue to check statements. This may cause NOTE: No observations in data set. NOTE: PROCEDURE DATASETS used (Total process time): real time 0.06 seconds cpu time 0.02 seconds 95 96 %include sascode(notify); 2000 **** agg_uspumas (626818) has completed 23JUN09 8:40:27 syserr=0 sysrc= 0 ***** ERROR: Errors printed on page 5. NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414 NOTE: The SAS System used: real time 43.34 seconds cpu time 26.09 seconds