X-Original-To:  sas-l@uga.bitnet, X_S_CONSULT
Newsgroups: bit.listserv.sas-l
Date:         Thu, 20 Aug 1992 19:26:00 EDT
Reply-To:     X_S_CONS@CUTCV2.BITNET
From:         X_S_CONS@CUTCV2.BITNET
Subject:      my thanks and some results/ 118 lines

Many thanks to people on the SAS-L regarding my last posting about space
problem on SAS 6.06 and 6.07. Valuable suggestions came from:

        Howard Schreier         Deb Cannon              Pete Rikard
        Qin Wang                Melvin Klassen          Richard Wright


Please let me add to last posting that the platform is MVS, :-).

Here is what I have done today(using different ways):

           'work=' option when invoking SAS
           '//work dd' statement in JCL
           'libname USER' statement to store temp data set in USER other
                    than WORK
by first looking at the WORK default setting in SAS cataloged procedure.
Here, the WORK space=(6144,(800,400),,,round) is for version 6.07 while
space=(CYL,(500,100)) for version 6.06!!  All the vars were defined by $CHARw.
so, LENGTH statement was not tried this time.

To make a simple COMPARISON of the two versions, I used USER to get
away with different units of the two default WORK.

The following are two log files(hope what I keep is still informative :-) of
the program using same USER space on 6.07 and 6.06 for interested people.
What I see is the significant difference in I/O counts.  6.07 is less.
Moreover, if the USER space primary # is 2000(half of the following),
6.07 runs and 6.06 fails for the program.

 ************************ 6.07 SAS LOG ***************************
 2          LIBNAME USER '&DTEMP' SPACE=(6144,(4000,500),,,ROUND);
 NOTE: Libref USER was successfully assigned as follows:
       Engine:        V607
       Physical Name: SYS92233.T153024.RA000.$ZSYM.DTEMP
 2
 3          DATA MAT;
 4            INFILE MAT92;
 5            INPUT
                 ... $CHARw.
 15         RUN;

 NOTE: The infile MAT92 is:
       Dsname=SYS92233.T152727.RA000.$ZSYM.TEST1,
       Unit=3390,Volume=XXX1CF,Disp=OLD,Blksize=27650,
       Lrecl=350,Recfm=FB

 NOTE: 171020 records were read from the infile MAT92.
 NOTE: The data set USER.MAT has 171020 observations and 119 variables.
 NOTE: The DATA statement used the following resources:
       CPU     time -         00:00:41.68
       Elapsed time -         00:01:15.70
       Vector affinity time - 00:00:00.00
       Vector usage    time - 00:00:00.00
       RSM Hiperspace  time - 00:00:00.00
       EXCP count   - 2877
       Task  memory - 893K (136K data, 757K program)
       Total memory - 2813K (1308K data, 1505K program)

 19         DATA MAT;
 20          SET MAT;
 21         BY ID;
 22         IF FIRST.ID THEN S=0; S+1;
 23         RUN;

 NOTE: The data set USER.MAT has 171020 observations and 120 variables.
 NOTE: The DATA statement used the following resources:
       CPU     time -         00:00:05.48
       Elapsed time -         00:01:06.14
       Vector affinity time - 00:00:00.00
       Vector usage    time - 00:00:00.00
       RSM Hiperspace  time - 00:00:00.00
       EXCP count   - 1338
       Task  memory - 811K (36K data, 775K program)
       Total memory - 2892K (1352K data, 1540K program)

 ************************ 6.07 SAS LOG ***************************
 2          LIBNAME USER '&DTEMP' SPACE=(6144,(4000,500),,,ROUND);
 NOTE: Libref USER was successfully assigned as follows:
       Engine:        V606
       Physical Name: SYS92233.T152432.RA000.$ZSYM.DTEMP
 2
 3          DATA MAT;
 4            INFILE MAT92;
 5            INPUT
                ....   $CHARw.
 15         RUN;

 NOTE: The infile MAT92 is:
       Dsname=SYS92233.T152055.RA000.$ZSYM.TEST1,
       Unit=3390,Volume=XXX191,Disp=OLD,Blksize=27650,
       Lrecl=350,Recfm=FB
 NOTE: 171020 records were read from the infile MAT92.
 NOTE: The data set USER.MAT has 171020 observations and 119 variables.

 NOTE: The DATA statement used the following resources:
       CPU time     - 00:00:39.96
       Elapsed time - 00:01:31.42
       EXCP count   - 4157
       Task  memory - 748K (136K data, 612K program)
       Total memory - 2447K (1220K data, 1227K program)

 19         DATA MAT;
 20          SET MAT;
 21         BY ID;
 22         IF FIRST.ID THEN S=0; S+1;
 23         RUN;

 NOTE: The data set USER.MAT has 171020 observations and 120 variables.
 NOTE: The DATA statement used the following resources:
       CPU time     - 00:00:08.25
       Elapsed time - 00:01:21.87
       EXCP count   - 3987
       Task  memory - 755K (129K data, 626K program)
       Total memory - 2495K (1248K data, 1247K program)

_________
end.