1 The SAS System 09:43 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.17 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 Monday 20APR09 at 09:43 PID=557142 NOTE: AUTOEXEC processing completed. 1 x cd /pub/data/sf32000/Tools 1 ! ; %let pgm=usgeos_reports; filename pgm "&pgm..sas"; 2 The SAS System 09:43 Monday, April 20, 2009 2 *---Genrate reports based on the sf3.usgeos data set.----; 3 libname sf32000 '/pub/data/sf32000'; NOTE: Libref SF32000 was successfully assigned as follows: Engine: V9 Physical Name: /pub/data/sf32000 4 libname sf3 (sf32000); NOTE: Libref SF3 was successfully assigned as follows: Levels: 1 Engine(1): V9 Physical Name(1): /pub/data/sf32000 5 6 proc sort data=sf3.usgeos(keep=sumlev geoid state county geocode areaname where=(state ne '72')) out=usgeos; by geoid; 6 ! run; NOTE: There were 275066 observations read from the data set SF3.USGEOS. WHERE state not = '72'; NOTE: The data set WORK.USGEOS has 275066 observations and 6 variables. NOTE: PROCEDURE SORT used (Total process time): real time 3.78 seconds cpu time 4.72 seconds 7 data sf3.usgeos_sumlev_summary; 8 set usgeos; 9 by sumlev; 10 if first.sumlev then n=1; else n+1; 11 if last.sumlev then do; 12 geoidlen=length(geoid); 13 sumlev_label=put(sumlev,$sumlev.); 14 output; 15 end; 16 run; NOTE: There were 275066 observations read from the data set WORK.USGEOS. NOTE: The data set SF3.USGEOS_SUMLEV_SUMMARY has 63 observations and 9 variables. NOTE: DATA statement used (Total process time): real time 1.24 seconds cpu time 0.78 seconds 17 ods html file="&pgm..html"; NOTE: Writing HTML Body file: usgeos_reports.html 18 footnote .h=1 "From setup in usgeos_reports.sas"; 19 20 proc print data=sf3.usgeos_sumlev_summary; 21 id sumlev; 22 format sumlev_label $40.; 23 title 'sf3.usgeos: SumLev Values with Typical geoid and geocode Values'; 24 title2 '(sumlev_label has been truncated to 40 chars)'; 25 var sumlev_label N geoid geocode areaname state geoidlen; 26 format n comma7.; 27 run; NOTE: There were 63 observations read from the data set SF3.USGEOS_SUMLEV_SUMMARY. NOTE: The PROCEDURE PRINT printed pages 1-3. NOTE: PROCEDURE PRINT used (Total process time): 3 The SAS System 09:43 Monday, April 20, 2009 real time 0.14 seconds cpu time 0.13 seconds 28 29 ods html close; 30 %include sascode(notify); 0 **** usgeos_reports (557142) has completed 20APR09 9:43:22 syserr=0 sysrc= 0 ***** NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414 NOTE: The SAS System used: real time 5.66 seconds cpu time 5.95 seconds