1 The SAS System 16:53 Wednesday, May 9, 2001 NOTE: Copyright (c) 1999-2000 by SAS Institute Inc., Cary, NC, USA. NOTE: SAS (r) Proprietary Software Release 8.1 (TS1M0) Licensed to UNIVERSITY OF MISSOURI AT COLUMBIA-CAMPUSWIDE-T&R, Site 0001242001. NOTE: This session is executing on the AIX 3 platform. NOTE: SAS initialization used: real time 0.14 seconds cpu time 0.05 seconds NOTE: AUTOEXEC processing beginning; file is /home/john/autoexec.sas. v8= 1 ***** ****** MSCDC autoexec rev for V8 01-21-2000 - begin execution ******* Standard filerefs and librefs assigned ***** ****Finished with generic autoexec **** *** ****Excuting my private autoexec.sas file, rev. 10Apr2001 WARNING: Libname LIBRARY is not assigned. NOTE: Libname LIBRARY refers to the same physical library as SASCTLGS. NOTE: Libref LIBRARY was successfully assigned as follows: Engine: V8 Physical Name: /pub/sasctlgs WARNING: No logical assign for filename RLINK. ***** dmsflag= NODMS dmchk execution begins *** **Begin execution on Wednesday 09MAY01 at 16:53 PID=22682 NOTE: Libref PL942000 was successfully assigned as follows: Engine: V8 Physical Name: /pub/data/pl942000 NOTE: AUTOEXEC processing completed. 1 x cd /pub/data/pl942000/Tools 1 ! ; %let pgm=school_trends; filename pgm "&pgm..sas"; 2 /* ----This report examine trends in population change at the school level for MO. 3 For Bill Elder, OSEDA 4 John Blodgett, OSEDA, U. of Missouri Outreach & Extension. May, 2001. 5 ---- */ 6 7 options nodate linesize=132 pagesize=120 formdlim='=' noovp; 8 libname user '/tmp/scratch/user'; NOTE: Libref USER was successfully assigned as follows: Engine: V8 Physical Name: /tmp/scratch/user 9 libname corrlst '/pub/data/corrlst'; NOTE: Libref CORRLST was successfully assigned as follows: Engine: V8 Physical Name: /pub/data/corrlst 10 11 %libname(pl942000,opts=); NOTE: Libref PL942000 was successfully assigned as follows: Engine: V8 Physical Name: /pub/data/pl942000 12 %libname(pl9490,subdir=pl9490tx); NOTE: Directory for library PL9490TX contains files of mixed engine types. NOTE: Libref PL9490TX was successfully assigned as follows: Engine: V8 Physical Name: /pub/data/pl9490/pl9490tx 13 filename dlmout 'dlmout.csv'; 14 15 title 'School District Trends: Look at School Districts With Greatest Change over Decade of the 90''s'; 16 options nodate; 17 18 19 data togo; 20 merge pl9490tx.moschl00(in=in90 rename=(totpop=totpop90 black1=black90 hisppop=hisppop90 white1=white90 20 ! asianpi=asianpi90)) 21 pl942000.moschls(in=in00); 22 by desedist; 23 if desedist=:'9999' then delete; ***; 24 sumlevel=upcase(sumlev); 25 if sumlev='SDU' then schtyp='Uni'; else if sumlev='SDE' then schtyp='Ele'; 26 if in00 then asianpi00=asian1 + hawnpi1; 27 array counts00(*) totpop white1 black1 asian1 hisppop; 28 array counts90(*) totpop90 white90 black90 asianpi90 hisppop90; 29 array change(*) changepop changewhite changeblack changeasian changehisp; 30 array pctchange(*) pctchangepop pctchangewhite pctchangeblack pctchangeasian pctchangehisp; 31 format pctchangepop--pctchangehisp 7.1; 32 if in90 and in00 then do i=1 to dim(counts90); 33 counts90(i)=round (counts90(i)); *--estimate, allocated counts rounded to integers--; 34 change(i) = counts00(i) - counts90(i); 35 if counts90(i) then pctchange(i)=round( 100*change(i)/counts90(i) , .1); 36 end; 37 38 39 label asianpi00='Asian & Pac Islndr 2000'; 40 keep desedist areaname schtyp totpop totpop90 changepop pctchangepop 41 hisppop hisppop90 changehisp pctchangehisp 42 white1 white90 changewhite pctchangewhite 43 black1 black90 changeblack pctchangeblack 44 asianpi00 asianpi90 changeasian pctchangeasian 45 ; 46 rename white1=white00 black1=black00 ; 47 run; NOTE: MERGE statement has more than one data set with repeats of BY values. NOTE: There were 524 observations read from the data set PL9490TX.MOSCHL00. NOTE: There were 525 observations read from the data set PL942000.MOSCHLS. NOTE: The data set USER.TOGO has 522 observations and 23 variables. NOTE: DATA statement used: real time 0.15 seconds cpu time 0.06 seconds 48 49 proc print data=togo(obs=50); 50 id desedist; 51 run; NOTE: There were 50 observations read from the data set USER.TOGO. NOTE: The PROCEDURE PRINT printed pages 1-2. NOTE: PROCEDURE PRINT used: real time 0.01 seconds 2 The SAS System cpu time 0.01 seconds 52 53 %cnvtdlm(setin=togo,names=1,round=.1,lrecl=512) ************************************************************** * CNVTDLM MACRO REV 05Oct00 BEGIN EXECUTION * * MISSOURI STATE CENSUS DATA CENTER * ************************************************************** Usage note about "stopover" condition can usually be ignored ***MISSVAL PARM ASSIGNED VALUE OF NULL BECAUSE GENLABS=1*** NOTE: PROCEDURE SQL used: real time 0.00 seconds cpu time 0.01 seconds WARNING: END-OF-RECORD option STOPOVER in effect for file DLMOUT. WARNING: END-OF-RECORD option STOPOVER in effect for file DLMOUT. WARNING: END-OF-RECORD option STOPOVER in effect for file DLMOUT. **** TOTAL SIZE OF OUTPUT FILE(S) IS 57581 BYTES 54 run; 55 56 %include sascode(notify); **** school_trends (22682) has completed Wednesday 09MAY01 16:53 syserr=0 ***** NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414 NOTE: The SAS System used: real time 1.22 seconds cpu time 0.38 seconds