1 The SAS System 16:40 Monday, April 20, 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.27 seconds cpu time 0.12 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 Monday 20APR09 at 16:40 PID=565346 NOTE: AUTOEXEC processing completed. 1 x cd /pub/data/sf32000/Tools 1 ! ; %let pgm=cnvtsf3_usdata2; filename pgm "&pgm..sas"; *<====mo only===; 2 The SAS System 16:40 Monday, April 20, 2009 2 3 /*--Followup to cnv tsf3_usdata module. Here we do some merging of the 3 data sets (ph, phct and phctr) to create 4 usstcnty, usregdiv and usuas data sets (the originals have been downloaded to mcdc3 server and will be deleted). 5 We also define some logrecno indices. 6 jgb, march, 2009. 7 (after the recovery). 8 */ 9 libname sf32000 "/pub/data/sf32000"; NOTE: Libref SF32000 was successfully assigned as follows: Engine: V9 Physical Name: /pub/data/sf32000 9 ! *--we read from the rawdata directory but write to sf32000 so we cannot use 9 ! &inpath to 10 define this libref now.----; 11 12 libname sf3 (sf32000); NOTE: Libref SF3 was successfully assigned as follows: Levels: 1 Engine(1): V9 Physical Name(1): /pub/data/sf32000 12 ! *---alias name--; 13 title "Conversion of 2000 Summary File 3 Data for us"; 14 /* =======================Begin comment================ 15 data sf3.usstcnty(compress=binary index=(Logrecno)); 16 merge sf3.usstcntygeos sf3.usstcntyph sf3.usstcntyphct sf3.usstcntyphctr; 17 by Logrecno; 18 run; 19 20 data sf3.usregdiv(compress=binary index=(Logrecno)); 21 merge sf3.usregdivgeos sf3.usregdivph sf3.usregdivphct sf3.usregdivphctr; 22 by Logrecno; 23 run; 24 25 data sf3.usuas(label='US data for Urbanized Areas & Urban Clusters' compress=binary index=(Logrecno)); 26 merge sf3.usuasgeos sf3.usuasph sf3.usuasphct sf3.usuasphctr; 27 by Logrecno; 28 run; 29 ======================End comment================== */ 30 31 data sf3.usgeocomps(label='US data for all Geographic Component summaries' compress=binary index=(Logrecno)); 32 merge sf3.usgeocompsgeos sf3.usgeocompsph sf3.usgeocompsphct sf3.usgeocompsphctr; 33 by Logrecno; 34 run; ERROR: Write to SF3.USGEOCOMPS.DATA failed. File is full and may be damaged. 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: There were 108392 observations read from the data set SF3.USGEOCOMPSGEOS. NOTE: There were 108392 observations read from the data set SF3.USGEOCOMPSPH. NOTE: There were 108392 observations read from the data set SF3.USGEOCOMPSPHCT. NOTE: There were 108392 observations read from the data set SF3.USGEOCOMPSPHCTR. WARNING: The data set SF3.USGEOCOMPS may be incomplete. When this step was stopped there were 108390 observations and 16594 variables. NOTE: Compressing data set SF3.USGEOCOMPS decreased size by 84.86 percent. Compressed is 16416 pages; un-compressed would require 108421 pages. ERROR: Data set SF3.USGEOCOMPS was not replaced because ERROR: File SF3.USGEOCOMPS.DATA is damaged. 3 The SAS System 16:40 Monday, April 20, 2009 NOTE: DATA statement used (Total process time): real time 49:44.05 cpu time 47:51.57 35 36 proc dataset library=sf3 nolist; ERROR: Procedure DATASET not found. 37 modify usplacesph; 38 index create Logrecno; 39 modify usplacesphct; 40 index create Logrecno; 41 modify usplacesphctr; 42 index create Logrecno; 43 44 modify uszipsph; 45 index create Logrecno; 46 modify uszipsphct; 47 index create Logrecno; 48 modify uszipsphctr; 49 index create Logrecno; 50 51 quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE DATASET used (Total process time): real time 0.03 seconds cpu time 0.00 seconds 52 53 %include sascode(notify); 3000 **** cnvtsf3_usdata2 (565346) has completed 20APR09 17:29:54 syserr=0 sysrc= 0 ***** ERROR: Undetermined I/O failure. FATAL: Unrecoverable I/O error detected in the execution of the data step program. Aborted during the EXECUTION phase. 73 odify uszipsphct; _____ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 74 index create Logrecno; _____ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 75 modify uszipsphctr; ______ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 76 index create Logrecno; _____ 180 4 The SAS System 16:40 Monday, April 20, 2009 ERROR 180-322: Statement is not valid or it is used out of proper order. 77 78 quit; 79 80 %include sascode(notify); 1020 **** cnvtsf3_usdata2 (565346) has completed 20APR09 17:29:54 syserr=0 sysrc= 0 ***** ERROR: Undetermined I/O failure. FATAL: Unrecoverable I/O error detected in the execution of the data step program. Aborted during the EXECUTION phase. ERROR: Errors printed on pages 2,3,4. NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414 NOTE: The SAS System used: real time 49:45.27 cpu time 47:51.85