1 The SAS System 12:34 Tuesday, October 14, 2003 NOTE: Copyright (c) 1999-2001 by SAS Institute Inc., Cary, NC, USA. NOTE: SAS (r) Proprietary Software Release 8.2 (TS2M0) Licensed to HARVARD SCHOOL OF PUBLIC HEALTH-INSTRUCTIONAL COMP, Site 0001177014. NOTE: This session is executing on the SunOS 5.8 platform. This message is contained in the SAS news file, and is presented upon initialization. Edit the files "news" in the "misc/base" directory to display site-specific news and information in the program log. The command line option "-nonews" will prevent this display. NOTE: SAS initialization used: real time 0.15 seconds cpu time 0.05 seconds 1 2 /*------------------------------------------------------------------------------------*/ 3 /*by Jean Roth Wed Mar 28 14:51:28 EST 2001 4 Please report errors to jroth@nber.org 5 Make two changes: 6 (1) specify the output file location in the 'libname' statement 7 (2) specify the input file name/location & year in the 'filename' statement 8 Other changes may be user and platform specific. */ 9 /*------------------------------------------------------------------------------------*/ 10 11 12 *options obs=100; 13 *options compress=yes; 14 *change compress=no if using a conversion package such as stat/transfer; 15 options nocenter; 16 options formdlim = " "; 17 18 libname out '/tmp/'; NOTE: Libref OUT was successfully assigned as follows: Engine: V8 Physical Name: /tmp 19 20 filename raw pipe "zcat /home/data/mare_winship/cpsmw[678]?.Z "; 21 data temp; 22 infile raw lrecl = 386 missover ; 23 24 INPUT 25 26 @13 year 2. 27 @238 famawgt 5. 28 @243 fampwgt 5. 29 @248 famwgtb 12. 30 @260 hhwgt 11. 31 @271 perawgt 5. 32 @276 perpwgt 5. 33 @281 suppwgt 12. 34 @293 baswgt 11. 35 ; 36 2 The SAS System 12:34 Tuesday, October 14, 2003 37 LABEL 38 famawgt = "Family A Weight" 39 fampwgt = "Family P Weight" 40 famwgtb = "Family Weight Basic" 41 hhwgt = "Household Weight" 42 perawgt = "Person A Weight" 43 perpwgt = "Person P Weight" 44 suppwgt = "Person Supplemental Weight" 45 baswgt = "Basic CPS Weight" 46 ; 47 NOTE: The infile RAW is: Pipe command="zcat /home/data/mare_winship/cpsmw[678]?.Z " NOTE: Invalid data for baswgt in line 2374300 293-303. RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0 2374300 07374700100181140000000000000000014120106+000014000109203906511000106040202019392+000014000204320126 101 69912017000001+0000001101480101010000011+000000000001+0014000+001400010000000210011026+0140000000000 201 000052070000000000+1099721016690912000000000000+00000071450+00000714500000000000+0000007 10 10 1 301 82110000000000000000014120102+000034050101400196911000102010000031119+0000340502034201 year=81 famawgt=0 fampwgt=0 famwgtb=71450 hhwgt=71450 perawgt=0 perpwgt=0 suppwgt=7 baswgt=. _ERROR_=1 _N_=2374300 NOTE: 3635888 records were read from the infile RAW. The minimum record length was 386. The maximum record length was 386. One or more lines were truncated. NOTE: The data set WORK.TEMP has 3635888 observations and 9 variables. NOTE: DATA statement used: real time 3:30.46 cpu time 1:56.04 48 proc means data=temp; 49 by year; NOTE: There were 3635888 observations read from the data set WORK.TEMP. NOTE: The PROCEDURE MEANS printed pages 1-8. NOTE: PROCEDURE MEANS used: real time 13.71 seconds cpu time 13.43 seconds NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414 NOTE: The SAS System used: real time 3:44.41 cpu time 2:09.52