1 The SAS System 08:55 Thursday, April 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.25 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 Thursday 23APR09 at 08:55 PID=114860 NOTE: AUTOEXEC processing completed. 1 x cd /pub/data/sf32000/Tools 1 ! ; %let pgm=access_trbgs; filename pgm "&pgm..sas"; 2 The SAS System 08:55 Thursday, April 23, 2009 2 *---Access the xxtrbgs data sets stored on Windows server in 626 Clark----; 3 %include sascode(mcdcshr3); 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 PL9490 was successfully assigned as follows: Engine: REMOTE Physical Name: C:\MCDC\DATA\PL9490 7 8 libname xxtrbgs server=mcdc3.mcdcshr3; NOTE: Libref XXTRBGS was successfully assigned as follows: Engine: REMOTE Physical Name: C:\MCDC\DATA\SF32000\XXTRBGS 9 title 'Extract sf32000 tract and bg level data using SAS/Share server to access'; 10 11 *---We have 1 data set per state with just the P and H tables at the 140 and 150 (tract and bg) levels--; 12 proc sql; 13 *---Boone county census tracts---; 14 select geocode, county, tract, p1i1 15 from xxtrbgs.motrbgsph 16 where county='29019' and sumlev='140'; 17 *----All tract and bgs in Kent county, Delaware---; 18 select sumlev, county, tract, bg , p1i1 19 from xxtrbgs.detrbgsph 20 where county='10001'; 21 quit; NOTE: The PROCEDURE SQL printed pages 1-3. NOTE: PROCEDURE SQL used (Total process time): real time 4.66 seconds cpu time 0.51 seconds 22 23 %include sascode(notify); 0 **** access_trbgs (114860) has completed 23APR09 8:55:37 syserr=0 sysrc= 0 ***** NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414 NOTE: The SAS System used: real time 5.37 seconds cpu time 0.84 seconds