1 The SAS System                                        07:47 Wednesday, January 31, 2001

NOTE: Copyright (c) 1989-1996 by SAS Institute Inc., Cary, NC, USA. 
NOTE: SAS (r) Proprietary Software Release 6.12  TS060
      Licensed to NIH/NATIONAL CANCER INSTITUTE, Site 0032848079.




Welcome to SAS 6.12 TS060 on guava.  Please contact Rusty Shields
or Scott Depuy of IMS, Inc. (301 680-9770) with questions.



NOTE: AUTOEXEC processing beginning; file is /opt/sas612/autoexec.sas.

NOTE: USING LARGE FILE IMPLEMENTATION.
NOTE: SAS initialization used:
      real time           0.100 seconds
      cpu time            0.067 seconds
      

NOTE: AUTOEXEC processing completed.

1          filename in pipe 'gunzip -c example1.txt.gz';
2          filename out '../example1.bin';
3          
4          data in;
5            infile in delimiter='09'X;
6            length stattype reg site year age race sex 3;
7            input reg site year age race sex rate se lci uci;
8            stattype=0; /* Crude Rate */
9            stat=rate;
10           if stat^=. then output;
11           stattype=1; /* Lower CI */
12           stat=lci;
13           if stat^=. then output;
14           stattype=2; /* Upper CI */
15           stat=uci;
16           if stat^=. then output;
17           keep stattype reg site year age race sex stat;
18         run;

NOTE: The infile IN is:
      Pipe command="gunzip -c example1.txt.gz"

NOTE: 108927 records were read from the infile IN.
      The minimum record length was 42.
      The maximum record length was 65.
NOTE: The data set WORK.IN has 326781 observations and 8 variables.
NOTE: DATA statement used:
      real time           2.500 seconds
      cpu time            2.248 seconds
      

19         
20         data in;
21           set in;
22           stat=stat*10000;
23           if stat<0 then sign=1; else sign=0;
24           num=abs(stat);
25           num=round(num, 1);
26           byte1=int(num/2**24);
27           num=round(num - byte1*2**24, 1);
2 The SAS System                                        07:47 Wednesday, January 31, 2001

28           byte1=byte1 + 2**7*sign;
29           byte2=int(num/2**16);
30           num=round(num - byte2*2**16, 1);
31           byte3=int(num/2**8);
32           num=round(num - byte3*2**8, 1);
33           byte4=round(num, 1);
34         run;

NOTE: The data set WORK.IN has 326781 observations and 14 variables.
NOTE: DATA statement used:
      real time           4.070 seconds
      cpu time            4.035 seconds
      

35         
36         proc sort data=in;
37           by stattype reg site year race sex age;
38         run;

NOTE: The data set WORK.IN has 326781 observations and 14 variables.
NOTE: PROCEDURE SORT used:
      real time           4.020 seconds
      cpu time            3.898 seconds
      

39         
40         data _null_;
41           set in;
42           file out recfm=n;
43           filelen=11;
44           col=(_n_-1)*filelen+1; put @ col stattype pib1. @;
45           col=(_n_-1)*filelen+2; put @ col reg pib1. @;
46           col=(_n_-1)*filelen+3; put @ col site pib1. @;
47           col=(_n_-1)*filelen+4; put @ col year pib1. @;
48           col=(_n_-1)*filelen+5; put @ col race pib1. @;
49           col=(_n_-1)*filelen+6; put @ col sex pib1. @;
50           col=(_n_-1)*filelen+7; put @ col age pib1. @;
51           col=(_n_-1)*filelen+8; put @ col byte1 pib1. @;
52           col=(_n_-1)*filelen+9; put @ col byte2 pib1. @;
53           col=(_n_-1)*filelen+10; put @ col byte3 pib1. @;
54           col=(_n_-1)*filelen+11; put @ col byte4 pib1. @;
55         run;

NOTE: UNBUFFERED is the default with RECFM=N.
NOTE: The file OUT is:
      File Name=/prj/web/www38/htdocs/example/example1.bin,
      Owner Name=depuy,Group Name=ims,
      Access Permission=rw-rw-r--

NOTE: DATA statement used:
      real time           1:12.020
      cpu time            1:11.895
      

NOTE: The SAS System used:
      real time           1:22.720
      cpu time            1:22.152
      
NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414