1 The SAS System 09:26 Tuesday, May 19, 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.25 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 19MAY09 at 09:26 PID=164026 NOTE: AUTOEXEC processing completed. 1 x cd /pub/data/sf32000/Tools 1 ! ; %let pgm=agg_moregns; filename pgm "&pgm..sas"; 2 The SAS System 09:26 Tuesday, May 19, 2009 2 *---5-19-09: Aggregate to various Mo county-based regions (rpcs, modot, umx, etc.---; 3 4 ***libname xxsl090 server=mcdc3.mcdcshr3; **this libname is defined in the above included module--; 5 libname sf32000 '/pub/data/sf32000'; NOTE: Libref SF32000 was successfully assigned as follows: Engine: V9 Physical Name: /pub/data/sf32000 6 libname sf3 (sf32000); NOTE: Libref SF3 was successfully assigned as follows: Levels: 1 Engine(1): V9 Physical Name(1): /pub/data/sf32000 7 %libname(georef); NOTE: Libref GEOREF was successfully assigned as follows: Levels: 1 Engine(1): V9 Physical Name(1): /pub/data/georef 8 libname user '/tmp/scratch/user'; NOTE: Libref USER was successfully assigned as follows: Engine: V9 Physical Name: /tmp/scratch/user 9 10 %macro addgeos(set); 11 data aggin&set; 12 length geocode $8; 13 merge sf3.mo&set(where=(sumlev='050' and geocomp='00') in=indata) 14 georef.mocogeos(keep=state county rpc umx umx2 dot ded_region cbsa aaa Sumlev in=ingeos); 15 by county; 16 if indata and ingeos; 17 if cbsa=' ' then cbsa='99999'; 18 sumlev='311'; geocode=cbsa||'-'||state; output; 19 sumlev='aaa'; geocode=aaa; output; 20 sumlev='ded'; geocode=ded_region; output; 21 sumlev='dot'; geocode=dot; output; 22 sumlev='rpc'; geocode=rpc; output; 23 sumlev='umx'; geocode=umx2; output; 24 drop county geocomp; 25 run; 26 proc sort; by sumlev geocode; run; 27 %mend addgeos; 28 29 %addgeos(ph) NOTE: There were 115 observations read from the data set SF3.MOPH. WHERE (sumlev='050') and (geocomp='00'); NOTE: There were 115 observations read from the data set GEOREF.MOCOGEOS. NOTE: The data set USER.AGGINPH has 690 observations and 5637 variables. NOTE: DATA statement used (Total process time): real time 30.60 seconds cpu time 22.33 seconds NOTE: There were 690 observations read from the data set USER.AGGINPH. NOTE: The data set USER.AGGINPH has 690 observations and 5637 variables. NOTE: PROCEDURE SORT used (Total process time): 3 The SAS System 09:26 Tuesday, May 19, 2009 real time 1.59 seconds cpu time 0.80 seconds 30 %addgeos(phct) NOTE: There were 115 observations read from the data set SF3.MOPHCT. WHERE (sumlev='050') and (geocomp='00'); NOTE: There were 115 observations read from the data set GEOREF.MOCOGEOS. NOTE: The data set USER.AGGINPHCT has 690 observations and 4471 variables. NOTE: DATA statement used (Total process time): real time 19.03 seconds cpu time 13.60 seconds NOTE: There were 690 observations read from the data set USER.AGGINPHCT. NOTE: The data set USER.AGGINPHCT has 690 observations and 4471 variables. NOTE: PROCEDURE SORT used (Total process time): real time 1.26 seconds cpu time 0.63 seconds 31 %addgeos(phctr) NOTE: There were 115 observations read from the data set SF3.MOPHCTR. WHERE (sumlev='050') and (geocomp='00'); NOTE: There were 115 observations read from the data set GEOREF.MOCOGEOS. NOTE: The data set USER.AGGINPHCTR has 690 observations and 6649 variables. NOTE: DATA statement used (Total process time): real time 13.19 seconds cpu time 10.29 seconds NOTE: There were 690 observations read from the data set USER.AGGINPHCTR. NOTE: The data set USER.AGGINPHCTR has 690 observations and 6649 variables. NOTE: PROCEDURE SORT used (Total process time): real time 1.96 seconds cpu time 1.03 seconds 32 33 34 %Macro preexit; %mend; 35 36 %Macro postexit; 37 select (sumlev); 38 when('311') Areaname=trim(put(cbsa,$cbsa.)); 39 when('aaa') Areaname=put(aaa,$aaa.); 40 when('ded') Areaname=put(ded_region,$dedrgn.); 41 when('dot') Areaname=put(dot,$modot.); 42 when('rpc') Areaname=put(rpc,$rpcname.); 43 when('umx') Areaname=put(umx,$umxname.); 44 otherwise do; put '****Otherwise clause reached -- logic error ****' sumlev= ; 45 abort abend; 4 The SAS System 09:26 Tuesday, May 19, 2009 46 end; 47 end; 48 if sumlev ne '311' then cbsa=' '; if sumlev ne 'aaa' then aaa=' '; if sumlev ne 'ded' then ded_region=' '; 49 if sumlev ne 'dot' then dot=' '; if sumlev ne 'rpc' then rpc=' '; if sumlev ne 'umx' then do; umx=' '; umx2=' '; end 49 ! ; 50 51 %mend postexit; 52 53 %aggsf3(settypes=ph phct phctr,setinlib=user, 54 setin=aggin,setoutlib=sf3,setout=moregns06, 55 aggby=sumlev geocode,idvs=umx umx2 cbsa aaa ded_region dot rpc state, 56 idlens=%str(SumLev $3 geocode $8 AreaName $64), 57 templib=user, 58 report=0) *** aggsf3 macro, revised 3/3/2009 10:29:40 AM , Begin execution with: setin:aggin setout:moregns06 settypes:ph phct phctr aggby:sumlev geocode ***Begin processing of set type PH *** NOTE: There were 690 observations read from the data set USER.AGGINPH. NOTE: The data set USER.AGGINPH has 690 observations and 5579 variables. NOTE: DATA statement used (Total process time): real time 5.50 seconds cpu time 2.54 seconds NOTE: Composite index aggby has been defined. NOTE: MODIFY was successful for USER.AGGINPH.DATA. NOTE: PROCEDURE DATASETS used (Total process time): real time 0.28 seconds cpu time 0.10 seconds *************************************************************** * AGG Macro Rev. 28Oct02 Begin Execution * * Missouri Census Data Center * *************************************************************** *****PARAMETERS SPECIFIED***** (NAMES IN PARENTHESES ARE ALIASES) SETIN(AGGIN)= agginph (INPUT DATA SET) SETOUT(AGGOUT)= aggoutph (OUTPUT DATA SET) AGGBY(BYVARS)= sumlev geocode (AGGREGATION BY VARIABLES) AGGLVL(AGGLVLS)= 1 (NUMBER OF LEVELS OF AGGREGATION) AGGVARS(VARS)= POP100 HU100 INTPTLAT INTPTLON LANDSQMI AREASQMI P1I1 -- H121I7 H3I2 H3I3 (VARIABLES ON SETIN TO AGGREGATE) NUMS= (NUMERATOR VARIABLES) DENOMS(DENS)= (LIST OF DENOMINATORS) MEANS(MEDIANS)= IntPtLat IntPtLon P4i1 P82i1 P157ai1 p157bi1 p157ci1 p157di1 p157ei1 p157fi1 p157gi1 p157hi1 p157Ii1 H4i1 H4i2 H18i1-H18i3 H82i1 (MEAN/MEDIAN VARS TO BE AGGREGATED) MWEIGHTS= Landsqmi Landsqmi P3i1 P1i1 P6i2-P6i8 P7i10 P7i3 H3i2 H3i3 5 The SAS System 09:26 Tuesday, May 19, 2009 H7i1-H7i3 H32i11 (LIST OF WEIGHT VARIABLES FOR MEANS) SLCTEDIT(FILTER)= (SELECT/EDIT USER-EXIT MACRO NAME) IDVARS(IDS)= umx umx2 cbsa aaa ded_region dot rpc state (ID VARIABLES TO KEEP ON AGGOUT) GRAND= 0 (GRAND TOTALS OPTION) FILLBY= (FILLER CHARACTER FOR AGGBY VARIABLES) NODUPS= 0 (OPTION TO OMIT REDUNDANT HIGHER LEVEL SUMS) ***END PARM LIST*** ***DATA STEP WILL BE USED TO COUNT NUMBER OF AGGVARS*** NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 58:30 NAGGVARS=5566 NOTE: There were 1 observations read from the data set USER.AGGINPH. NOTE: DATA statement used (Total process time): real time 0.52 seconds cpu time 0.29 seconds **VALUE FOR NAGGVARS DETERMINED BY DATA STEP IS 5566 AGGBY1= geocode AGGBY2= sumlev ****PARM VERIFICATION PHASE COMPLETE**** ****WARNING: VARIABLES APPEARING IN NUMS, DENOMS OR MWEIGHTS LISTS WILL NOT BE AGGREGATED UNLESS THEY ALSO APPEAR IN THE AGGVARS LIST. USE THE DROPVARS PARM TO OMIT THEM FROM THE OUTPUT DATA SET. NOTE: There were 690 observations read from the data set USER.AGGINPH. NOTE: The data set USER.AGGOUTPH has 89 observations and 5578 variables. NOTE: DATA statement used (Total process time): real time 4.51 seconds cpu time 3.90 seconds NOTE: Missing values were generated as a result of performing an operation on missing values. Each place is given by: (Number of times) at (Line):(Column). 109 at 58:87 NOTE: There were 89 observations read from the data set USER.AGGOUTPH. NOTE: The data set SF3.MOREGNS06PH has 89 observations and 5577 variables. NOTE: Compressing data set SF3.MOREGNS06PH decreased size by 5.08 percent. Compressed is 56 pages; un-compressed would require 59 pages. NOTE: DATA statement used (Total process time): real time 2.80 seconds cpu time 1.70 seconds ***Begin processing of set type PHCT *** NOTE: There were 690 observations read from the data set USER.AGGINPHCT. NOTE: The data set USER.AGGINPHCT has 690 observations and 4412 variables. NOTE: DATA statement used (Total process time): real time 2.64 seconds cpu time 1.78 seconds 6 The SAS System 09:26 Tuesday, May 19, 2009 NOTE: Composite index aggby has been defined. NOTE: MODIFY was successful for USER.AGGINPHCT.DATA. NOTE: PROCEDURE DATASETS used (Total process time): real time 0.27 seconds cpu time 0.09 seconds *************************************************************** * AGG Macro Rev. 28Oct02 Begin Execution * * Missouri Census Data Center * *************************************************************** *****PARAMETERS SPECIFIED***** (NAMES IN PARENTHESES ARE ALIASES) SETIN(AGGIN)= agginphct (INPUT DATA SET) SETOUT(AGGOUT)= aggoutphct (OUTPUT DATA SET) AGGBY(BYVARS)= sumlev geocode (AGGREGATION BY VARIABLES) AGGLVL(AGGLVLS)= 1 (NUMBER OF LEVELS OF AGGREGATION) AGGVARS(VARS)= PCT1I1 -- HCT28I13 (VARIABLES ON SETIN TO AGGREGATE) NUMS= (NUMERATOR VARIABLES) DENOMS(DENS)= (LIST OF DENOMINATORS) MEANS(MEDIANS)= Pct42i1-Pct42i15 (MEAN/MEDIAN VARS TO BE AGGREGATED) MWEIGHTS= Pct2i1-Pct2i15 (LIST OF WEIGHT VARIABLES FOR MEANS) SLCTEDIT(FILTER)= (SELECT/EDIT USER-EXIT MACRO NAME) IDVARS(IDS)= umx umx2 cbsa aaa ded_region dot rpc state (ID VARIABLES TO KEEP ON AGGOUT) GRAND= 0 (GRAND TOTALS OPTION) FILLBY= (FILLER CHARACTER FOR AGGBY VARIABLES) NODUPS= 0 (OPTION TO OMIT REDUNDANT HIGHER LEVEL SUMS) ***END PARM LIST*** ***DATA STEP WILL BE USED TO COUNT NUMBER OF AGGVARS*** NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 58:30 NAGGVARS=4392 NOTE: There were 1 observations read from the data set USER.AGGINPHCT. NOTE: DATA statement used (Total process time): real time 0.51 seconds cpu time 0.21 seconds **VALUE FOR NAGGVARS DETERMINED BY DATA STEP IS 4392 AGGBY1= geocode AGGBY2= sumlev ****PARM VERIFICATION PHASE COMPLETE**** ****WARNING: VARIABLES APPEARING IN NUMS, DENOMS OR MWEIGHTS LISTS WILL NOT BE AGGREGATED UNLESS THEY ALSO APPEAR IN THE AGGVARS LIST. USE THE DROPVARS PARM TO OMIT THEM FROM THE OUTPUT DATA SET. NOTE: There were 690 observations read from the data set USER.AGGINPHCT. 7 The SAS System 09:26 Tuesday, May 19, 2009 NOTE: The data set USER.AGGOUTPHCT has 89 observations and 4404 variables. NOTE: DATA statement used (Total process time): real time 3.85 seconds cpu time 3.02 seconds WARNING: The variable _age in the DROP, KEEP, or RENAME list has never been referenced. WARNING: The variable _q1 in the DROP, KEEP, or RENAME list has never been referenced. WARNING: The variable _q3 in the DROP, KEEP, or RENAME list has never been referenced. NOTE: There were 89 observations read from the data set USER.AGGOUTPHCT. NOTE: The data set SF3.MOREGNS06PHCT has 89 observations and 4403 variables. NOTE: Compressing data set SF3.MOREGNS06PHCT decreased size by 25.45 percent. Compressed is 41 pages; un-compressed would require 55 pages. NOTE: DATA statement used (Total process time): real time 3.37 seconds cpu time 1.17 seconds ***Begin processing of set type PHCTR *** NOTE: There were 690 observations read from the data set USER.AGGINPHCTR. NOTE: The data set USER.AGGINPHCTR has 690 observations and 6590 variables. NOTE: DATA statement used (Total process time): real time 4.20 seconds cpu time 2.89 seconds NOTE: Composite index aggby has been defined. NOTE: MODIFY was successful for USER.AGGINPHCTR.DATA. NOTE: PROCEDURE DATASETS used (Total process time): real time 0.35 seconds cpu time 0.14 seconds *************************************************************** * AGG Macro Rev. 28Oct02 Begin Execution * * Missouri Census Data Center * *************************************************************** *****PARAMETERS SPECIFIED***** (NAMES IN PARENTHESES ARE ALIASES) SETIN(AGGIN)= agginphctr (INPUT DATA SET) SETOUT(AGGOUT)= aggoutphctr (OUTPUT DATA SET) AGGBY(BYVARS)= sumlev geocode (AGGREGATION BY VARIABLES) AGGLVL(AGGLVLS)= 1 (NUMBER OF LEVELS OF AGGREGATION) AGGVARS(VARS)= PCT62AI1--HCT48II3 (VARIABLES ON SETIN TO AGGREGATE) NUMS= (NUMERATOR VARIABLES) DENOMS(DENS)= (LIST OF DENOMINATORS) MEANS(MEDIANS)= (MEAN/MEDIAN VARS TO BE AGGREGATED) MWEIGHTS= (LIST OF WEIGHT VARIABLES FOR MEANS) SLCTEDIT(FILTER)= (SELECT/EDIT USER-EXIT MACRO NAME) 8 The SAS System 09:26 Tuesday, May 19, 2009 IDVARS(IDS)= umx umx2 cbsa aaa ded_region dot rpc state (ID VARIABLES TO KEEP ON AGGOUT) GRAND= 0 (GRAND TOTALS OPTION) FILLBY= (FILLER CHARACTER FOR AGGBY VARIABLES) NODUPS= 0 (OPTION TO OMIT REDUNDANT HIGHER LEVEL SUMS) ***END PARM LIST*** ***DATA STEP WILL BE USED TO COUNT NUMBER OF AGGVARS*** NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 58:30 NAGGVARS=6570 NOTE: There were 1 observations read from the data set USER.AGGINPHCTR. NOTE: DATA statement used (Total process time): real time 0.73 seconds cpu time 0.33 seconds **VALUE FOR NAGGVARS DETERMINED BY DATA STEP IS 6570 AGGBY1= geocode AGGBY2= sumlev ****PARM VERIFICATION PHASE COMPLETE**** NOTE: There were 690 observations read from the data set USER.AGGINPHCTR. NOTE: The data set USER.AGGOUTPHCTR has 89 observations and 6582 variables. NOTE: DATA statement used (Total process time): real time 4.86 seconds cpu time 3.86 seconds WARNING: The variable _age in the DROP, KEEP, or RENAME list has never been referenced. WARNING: The variable _q1 in the DROP, KEEP, or RENAME list has never been referenced. WARNING: The variable _q3 in the DROP, KEEP, or RENAME list has never been referenced. NOTE: Missing values were generated as a result of performing an operation on missing values. Each place is given by: (Number of times) at (Line):(Column). 265 at 58:128 439 at 58:83 NOTE: There were 89 observations read from the data set USER.AGGOUTPHCTR. NOTE: The data set SF3.MOREGNS06PHCTR has 89 observations and 6581 variables. NOTE: Compressing data set SF3.MOREGNS06PHCTR decreased size by 50.48 percent. Compressed is 52 pages; un-compressed would require 105 pages. NOTE: DATA statement used (Total process time): real time 3.83 seconds cpu time 2.68 seconds 59 60 data sf3.moregns06(compress=yes label='Mo county-based regions as defined circa 2006' index=(sumlev)); 61 merge sf3.moregns06ph sf3.moregns06phct sf3.moregns06phctr; 62 by sumlev geocode; 63 run; NOTE: There were 89 observations read from the data set SF3.MOREGNS06PH. NOTE: There were 89 observations read from the data set SF3.MOREGNS06PHCT. NOTE: There were 89 observations read from the data set SF3.MOREGNS06PHCTR. NOTE: The data set SF3.MOREGNS06 has 89 observations and 16539 variables. NOTE: Compressing data set SF3.MOREGNS06 decreased size by 0.00 percent. 9 The SAS System 09:26 Tuesday, May 19, 2009 Compressed is 121 pages; un-compressed would require 121 pages. NOTE: DATA statement used (Total process time): real time 11.32 seconds cpu time 7.97 seconds 64 65 proc freq data=sf3.moregns06; 66 table sumlev cbsa aaa ded_region dot rpc; 67 table umx2*umx/list; 68 run; NOTE: There were 89 observations read from the data set SF3.MOREGNS06. NOTE: The PROCEDURE FREQ printed pages 1-4. NOTE: PROCEDURE FREQ used (Total process time): real time 0.43 seconds cpu time 0.27 seconds 69 70 71 72 %include sascode(notify); 0 **** agg_moregns (164026) has completed 19MAY09 9:28:51 syserr=0 sysrc= 0 ***** NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414 NOTE: The SAS System used: real time 1:59.15 cpu time 1:22.65