HDTenEightyP/NetNews huggingface dataset:
Newsgroups: bit.listserv.sas-l
Date:         Wed, 4 Nov 1992 16:56:49 EST
Reply-To:     Chris <NY922195@PACEVM.BITNET>
From:         Chris <NY922195@PACEVM.BITNET>
Subject:      Data Reshaping ?

Hi ! I've got a data reshaping problem, compounded by the fact some
of the data is stored in permanent SAS datasets and the rest is con-
tained in raw datasets. In both cases, the data looks like this:

   DEPNO    DEPT    YR    V1    V2    V3    V4    V5
   121      MIS     80    10    11    12    13    14
   121      MIS     81    15    16    17    18    19
   121      MIS     82    20    21    22    23    24
   144      COMM    80    41    42    43    44    45
   144      COMM    81    46    47    48    49    50
   144      COMM    82    51    52    53    54    55

The actual datasets have 15 records per DEPNO and 40 variables per
record. The data originally came from SQL tables (IBM's SQL/DS dbms)
before being dumped to flat files and then converted (in some cases)
to permanent SAS datasets.

What I want is to fold the individual rows back into one record, with
the data values (V1 thru V5 in the above example) forming a 3 x 5 array
(15 x 40 for the real data) for each record, such as the following:

   121 MIS  10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
   144 COMM 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55

I was told that SAS is really great for these kinds of manipulations,
however, I'm a SAS neophite (about 2 months).

I've looked at the SAS Language Reference, the SAS Language And
Procedures Guide, the Proc SQL manual and the Aronson book 'SAS for
Programmers'. In addition to eye strain, I've become more confused,
particularly in the differences in handling raw data (Input stmt)
and permanent SAS data (Set stmt). I ran into a very nasty situa-
tion involving a '@' sign; I'll spare you the details !

There are plenty of examples of 'going the other way', taking a
single record with an array and creating multiple records (ob-
servations as the manuals say), but none going the other way (I
can't be the only one that has ever faced this problem). I thought
one of the examples in the proc transpose chapter would perform
what I want, but alas, either I was wrong or didn't fully under-
stand the explanation (or both?).

The datasets/files are fairly large: 10,000 to 25,000 records.
We are running SAS 6.07 under VM/ESA. Any solutions, examples,
references would be mightily appreciated. I have no real pre-
ference to method: programming in the data step, proc sql or
any other proc; all would be welcome, and useful in learning
SAS (I'm a computer science student, background in pascal, no
classes in SAS). Also, any references for text books on SAS
would be helpful (data processing topics, not really statis-
tics).  Thank you !
                                  Sincerely,

                                  Chris
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
X-Mailer: ELM [version 2.2 PL16]
Newsgroups: bit.listserv.sas-l
Date:         Fri, 6 Nov 1992 11:00:17 CST
Reply-To:     "(R. Snyder)" <rsnyder@LOBBY.TI.COM>
From:         "(R. Snyder)" <rsnyder@LOBBY.TI.COM>
Subject:      Re: EMITS registration question
Comments: To: PFEIFER_G@gold.colorado.edu
Comments: cc: sas-l@uga.cc.uga.edu
              Research & Information,              492-6743" at Nov 6,
              92 8:18 am

> ----------------------------------------------------------------------
> CONTENT:  query
> SUMMARY:  Can users who are not SAS site reps use EMITS?
> REL/PLTF: all
> E-ADDR:   pfeifer_g@cubldr.colorado.edu
> NAME:     Gary Pfeifer
> PH/ADDR:  303/492-6743   Univ of Colorado   CB 108   Boulder CO 80302
> ----------------------------------------------------------------------
>
< Stuff deleted >
>
> "The second" list he talks of is EMITS.  It was my understanding when it
> first became available that it is only for SAS Site Representatives.  Is
> that no longer true?
>
> Gary
>
Gary,

My understanding is that one must be a Site Rep OR SAS Consultant to use
EMITS.

Regards,
Bob
From: ADROSEN@PITTVMS.BITNET (Allan D. Rosen (412)624-0418)
Newsgroups: bit.listserv.sas-l
Subject: Re: reshaping raw data ...
Date: 8 Nov 92 22:27:00 GMT
Reply-To: "Allan D. Rosen (412)624-0418" <ADROSEN@PITTVMS.BITNET>
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
X-Envelope-to: SAS-L@OHSTVMA.BITNET
X-VMS-To: IN%"SAS-L@OHSTVMA.BITNET"
X-VMS-Cc: ADROSEN

Sanjay K. Pandey  (SKPWORK@SUVM.BITNET) wants to "reshape" data as follows:

    Data=ORIG                        Data=TRANSF
    ID    X1  X2 X3 X4 X5      \     ID  X1 X2 X3  X4 X5
    1     1   .  2  .  .   ----- \   1   1   3  2   4  .
    1     .   3  .  4  .   ----- /   2   1   2  3   .  4
    1     .   .  .  .  .       /     3   1   .  .   .  .
    2     1   2  3  .  .
    2     .   .  .  .  4
    3     1   .  .  .  .

The update statement will do the trick:

data transf;
update orig(obs=0)
       orig;
by id;
run;

Allan Rosen
University of Pittsburgh
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.sas-l
Date:         Wed, 4 Nov 1992 13:33:00 CDT
Reply-To:     IMAD.GHANDOUR@MAIL.ADMIN.WISC.EDU
From:         IMAD.GHANDOUR@MAIL.ADMIN.WISC.EDU
Subject:      Important Question
Comments: To: sas-l@ohstvma.acs.ohio-state.edu

to: sas-l@ohstvma.acs.ohio-state.edu


Can anybody tell me why the SAS-L emails do have subject titles
anymore (instead we now have NETWORK MAIL)?

Imad Ghandour
University of Wisconsin - Madison
email: imad.ghandour@mail.admin.wisc.edu
Tel: 608/265-2390
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.sas-l
Date:         Mon, 9 Nov 1992 09:27:00 EST
Reply-To:     SUMA@CLEMSON.BITNET
From:         SUMA@CLEMSON.BITNET
Subject:      help needed on division by zero

Could someone tell me what SAS does when you specify a
statement such as
A = B/C
 and the values of variable C could be either 0 or missing.
I know SAS gives an  error message but does it set the values
of A to missing or do you have to ensure this by specifying a
preceding statement such as
if C= 0 or C=. then A = .; else A=B/C ;
I know the second will work but I am curious to know what would
happen if one just specified A=B/C without providing for the case
when C=0 or missing.
ALSO what would happen if you say
If C=0 or . then A=.; else A=B/C;
Any suggestion will be appreciated.
Uma
SUMA@CLEMSON
Newsgroups: bit.listserv.sas-l
Date:         Tue, 10 Nov 1992 10:17:19 PST
Reply-To:     TWB2%RatesRDS%FAR@CTS27.CS.PGE.COM
From:         TWB2%RatesRDS%FAR@CTS27.CS.PGE.COM
Subject:      Truncated Dataset

>> Recently, SUMA @ CLEMSON asked about what happens when SAS encounters
>> a division by zero.  This problem cropped up here about a year or so ago,
>> and I think I mentioned it to the list at that time.  I set up
>> a small program to create a 10 item data set, with a division by
>> zero about halfway through ... What happens (under VM/ESA) depends
>> upon which version of SAS one is using.
>> Under Rel. 6.06 the log contains the message "Note : the data step has
>> been abnormally terminated", AND ONLY 3 OBS ARE IN THE DATA SET (the
>> division by zero occurs in obs number 4).
>> So, if you are using SAS 6.06 under VM/ESA, be very careful of division
>> by zero.  It can truncate your data set without an obvious error message.

>I tried his test-run, using Release 6.06 under VM/XA and CMS Release 5.6,
>and I did not see the "abnormally terminated" message,
>i.e., for me, SAS created 10 observations.
>
>So, is anybody else using SAS Release 6.06 under VM/XA or VM/ESA?
>What results do you get when **you** run the same test-program?

I suspect we are seeing the effects of either the ERRORABEND option.  This
options forces SAS to terminate the job when an error occurs.  For multistep
jobs (data and proc steps, not JCL steps), ERRORABEND can save a great deal of
processing time and debugging time.  I suspect that the original (3 obs)
tester had OPTION ERRORABEND, and the later (10 obs) tester had OPTION
NOERRORABEND.

Just for the record, division by zero or a missing value returns a missing
value.  Some people code IF BOTTOM NE . AND BOTTOM NE 0 THEN FRACTION = TOP /
BOTTOM ; to avoid the 'missing as a result of missing' or division by zero
messages.

Tim Berryhill
Pacific Gas & Electric Co.
I'd tell you my Internet address, except our gateway (from in-house net) keeps
moving around.
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.sas-l
Date:         Sat, 7 Nov 1992 17:36:56 -0600
Reply-To:     "(Kernon Gibes)" <gibes@SWIRL.MONSANTO.COM>
From:         "(Kernon Gibes)" <gibes@SWIRL.MONSANTO.COM>
Subject:      RE: WHERE statement in PROC PLOT?
Comments: To: SAS-L@uga.cc.uga.edu@tin.monsanto.com
Comments: cc: GIBES@tin.monsanto.com

 CONTENT:   f/u on WHERE statement in PROC PLOT run groups
 SUMMARY:   opps! it works under VMS 6.06 and VMS 6.07 TS301
 REL/PLTF:  6.06+/VMS
 E-ADDR:    gibes@swirl.monsanto.com
 NAME:      Kernon Gibes
 DATE:      7 November 1992

Well, I spoke (wrote) too soon AGAIN!

I thought WHEREs didn't work in run groups because I tested it with PROC
REG and got exactly the same problem that Paul OldenKamp reported.  But
why did I do that instead of PROC PLOT?  I don't know.  Anyway, under
VMS, WHERE statements *do* work in PLOT run groups but not in REG run
groups.

Hey, Paul... do you want to trade?  (maybe neither works for you though)
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
X-VMS-To: RCCW21::IN%"ISSGXW@VM.BYU.EDU"
X-VMS-Cc: BITNET::"SAS-L@VTVM2.BITNET"
MIME-version: 1.0
Content-type: TEXT/PLAIN; CHARSET=US-ASCII
Content-transfer-encoding: 7BIT
Newsgroups: bit.listserv.sas-l
Date:         Wed, 11 Nov 1992 18:00:05 -0500
Reply-To:     "Harlene C. Gogan: RTI's PC-SAS Technical Consultant"
              <RTIHCG@RTI.BITNET>
From:         "Harlene C. Gogan: RTI's PC-SAS Technical Consultant"
              <RTIHCG@RTI.BITNET>
Subject:      Re: Window License Fee Schedule
Comments: To: ISSGXW@VM.BYU.EDU

>Looks like the pricing for SAS Windows has been decided and will the
>same as OS/2.  I just received a 1993 SAS License Fee Schedule
>(Academic Computing Customers) for "The SAS System for Personal
>Computers under OS/2 or Windows".  Too bad ............

>The fees look the same as the 1992 OS/2 fees.

You may want to check with your SAS-rep.  There may be some sort of
"conversion" rate for the first year for DOS licenses that are
upgrading to SAS Windows (like paying the difference between DOS
renewal and Windows renewal rates for the number of licenses
upgraded).  This takes the added STING out of first year costs.
From: FLICKER@FORDMULC.BITNET
Newsgroups: bit.listserv.sas-l
Subject: Disregard previous
Date: 11 Nov 92 03:07:00 GMT
Reply-To: FLICKER@FORDMULC.BITNET
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Original_To:  BITNET%"spss-l@uga", BITNET%"sas-l@uga"

Please disregard my postings to SAS-L and SPSS-L earlier this evening,
which should have been sent to the LISTSERV instead. Sorry folks ...
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.sas-l
Date:         Fri, 6 Nov 1992 10:22:07 CST
Reply-To:     David Nasser <NASSER@UMSLVMA.BITNET>
From:         David Nasser <NASSER@UMSLVMA.BITNET>
Subject:      **MVS Transport Lib running 6.07

Content   : Response to solution
Summary   : Need DISP=MOD for trans data lib
System(s) : MVS SAS6.07
Name      : David Nasser

Pete Rikard responded:
>The key is the DISP=OLD processing that SAS is doing. SAS writes
>each new transport dataset at the beginning of the file. Change
>either the DISP= to DISP=MOD or add the MOD  parameter to the
>libname statement. Then SAS will write each new dataset at the
>end of the current file.

DISP=MOD in the JCL works. Pete is correct (much thanx).

Lest someone else should stub their toe, the easiest way to handle
this silliness (that I know of) is to pre-allocate the transport
library (FB/80/8000), then specify DISP=MOD in the 6.07 step that
writes the transport data library.

Mea Culpa! I assumed that the routine for creating/writing the transport
library was the same (except for DCBz) as for a _native_ SAS library.
Knew I was guilty of something.

  Regards,
  David

David Nasser                              NASSER@UMSLVMA
St. Louis, Mo                             NASSER@UMSLVMA.UMSL.EDU

"All thru the shadows
 they come and they go
 with only one thing in common,
 they got the Fire Down Below."
     - Bob Seger
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Subject: (no subject given)
Newsgroups: bit.listserv.sas-l
Date:         Mon, 9 Nov 1992 09:08:17 EST
Reply-To:     RICHETIN@FRNSAE11.BITNET
From:         RICHETIN@FRNSAE11.BITNET

======================================================================== 8

Hi,
apologies for my english.
my question is: could somebody told me is SAS could be run in AIX/ESA mode ?
-----------------------------------------------------------------------
Jean-Luc RICHETIN                                   TELEX INSEE 632 867
E.N.S.A.E.                                     FAX. (33)(1) 41 17 64 80
3 avenue Pierre Larousse                       TEL. (33)(1) 41 17 65 04
92241 Malakoff Cedex                        N BITNET RICHETIN@FRNSAE11
-----------------------------------------------------------------------
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.sas-l
Date:         Wed, 11 Nov 1992 13:36:38 EDT
Reply-To:     Ekeho <V1354G@TEMPLEVM.BITNET>
From:         Ekeho <V1354G@TEMPLEVM.BITNET>
Subject:      statlib

======================================================================== 22
Date:         Wed, 11 Nov 92 11:29:28 EDT
From:         Ekeho <V1354G@TEMPLEVM>
Subject:      statlib
To:           sas-l <sas-l@ohstvms>


Hi folks;
Could I ftp software from statlib@temper.stat.cmu.edu?

===============================================================

Ekeho Oh

Internet: V1354G@VM.TEMPLE.EDU     Home: 223 W. Mentor St.
Bitnet:   V1354G@TEMPLEVM                Philadelhpia, PA 19120
Dep't of Statistics                      215-329-6345
Temple University
Philadelphia, PA 19122
USA

===============================================================
From: oldenkmp@ESPRESSO.BOEING.COM ((P. Oldenkamp 5-4481))
Newsgroups: bit.listserv.sas-l
Subject: Re: WHERE statement in PROC PLOT?
Date: 10 Nov 92 00:48:37 GMT
Reply-To: "(P. Oldenkamp 5-4481)" <oldenkmp@ESPRESSO.BOEING.COM>
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Comments: To: sas-l@uga.cc.uga.edu

----------------------------------------------------------------------
CONTENT:  UPDATE--WHERE statement in PROC PLOT doesn't work right
REL/PLTF: 6.07TS302--MVS/ESA
E-ADDR:   oldenkmp@ESPRESSO.boeing.com
NAME:     Paul OldenKamp
PHONE:    206-865-4481
----------------------------------------------------------------------
Here is what I have learned about the use of where statments in run
groups of interactive procs.  I have encountered an incorrect result
when I used a where statement in the second or subsequent run groups of
a PROC PLOT with 6.07TS302 on MVS.  I did not get this error on SunOS,
6.07TS203, and Kernon did not get it when he tried VMS.  So far no one
has sent me a report of what happens for them on MVS.

It seems that this use of the where statment never works in PROC REG since
both Kernon on VMS and I on MVS and SunOS got an error, but a different
error message that I got with PROC PLOT.

This use of the where statement works fine for me with PROC GPLOT on
both MVS and SunOS.
----------------------------------------------------------------------
	       //  Paul OldenKamp
	      //   BCS Research and Technology          .
	     //    P. O. Box 24346, MS 7L-21            |\
	    //     Seattle, WA   98124-0346             | \____oo_
	   //==========================================((__|  /___>
	  //       ___ ___ ___ ___     __                  | //
	 //       /__//  //__  /  /\ //  _                 |//
	//       /__//__//__ _/_ /  //__/                  ''
       /
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.sas-l
Date:         Mon, 9 Nov 1992 18:00:00 PST
Reply-To:     Melvin Klassen <KLASSEN@UVVM.BITNET>
Comments:     Warning -- original Sender: tag was NETNEWS@UVVM.UVIC.CA
From:         Melvin Klassen <KLASSEN@UVVM.BITNET>
Subject:      Re: Division by zero

Barry Walton <BWALTON@MILLERSV> writes:
>
> Recently, SUMA @ CLEMSON asked about what happens when SAS encounters
> a division by zero.  This problem cropped up here about a year or so ago,
> and I think I mentioned it to the list at that time.  I set up
> a small program to create a 10 item data set, with a division by
> zero about halfway through ... What happens (under VM/ESA) depends
> upon which version of SAS one is using.
> Under Rel. 6.06 the log contains the message "Note : the data step has
> been abnormally terminated", AND ONLY 3 OBS ARE IN THE DATA SET (the
> division by zero occurs in obs number 4).
> So, if you are using SAS 6.06 under VM/ESA, be very careful of division
> by zero.  It can truncate your data set without an obvious error message.

I tried his test-run, using Release 6.06 under VM/XA and CMS Release 5.6,
and I did not see the "abnormally terminated" message,
i.e., for me, SAS created 10 observations.

So, is anybody else using SAS Release 6.06 under VM/XA or VM/ESA?
What results do you get when **you** run the same test-program?
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.sas-l
Date:         Sat, 7 Nov 1992 16:16:16 PST
Reply-To:     Melvin Klassen <KLASSEN@UVVM.BITNET>
Comments:     Warning -- original Sender: tag was NETNEWS@UVVM.UVIC.CA
From:         Melvin Klassen <KLASSEN@UVVM.BITNET>
Subject:      Re: macro error message

Ekeho <V1354G@TEMPLEVM> writes:
>I am trying to concatenate about 100 data sets. Therefore I am testing
>macro program. In the last part of sas log I generate data set names.
>When I don't use macro, it works fine. Instead of "set" I use "proc append"
>in another program. It is OK. There are error messages in the screen.
>It says "invalid device". May be %cms makes a trouble.

Your're right, the '%CMS' command is the problem.
> 1          %MACRO MANI(R);
> 2          %DO I=1 %TO &R;
> 3          %CMS FI      OUT&I      OUT&I DATA A;
Try:         %CMS FILEDEF OUT&I DISK OUT&I DATA A;
or use the 'FILENAME' statement in SAS.
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.sas-l
Date:         Mon, 9 Nov 1992 12:00:00 PST
Reply-To:     Melvin Klassen <KLASSEN@UVVM.BITNET>
From:         Melvin Klassen <KLASSEN@UVVM.BITNET>
Subject:      Re: follow up question
Comments: To: Uma S <SUMA@CLEMSON.BITNET>

On Mon, 09 Nov 92 14:48 EST, Uma <SUMA@CLEMSON> wrote:
> My remaining problem is just this.
> I used SAS to read a (1st) dataset which has some missing values.

See page 546 ("Special missing values") of "SAS(r) User's Guide: Basics,
Version 5 Edition" and page 548 ("Magnitudes of missing values")
to see how SAS stores missing values inside a SAS dataset.

> I then used SAS to write a 2nd data set in real binary format.

See page 524 of the same manual for the "RBw.d" format.  It states:

  Real binary is the most-efficient format for representing numeric values,
  since SAS already represents numbers this way, and no conversion is needed.

Therefore, the bits in the external file will match-up, one-for-one,
with the internal values in the SAS dataset.

> I then used SAS once again to read the 2nd dataset in real binary format,
> and then performed some ratio calculations such as a=b/c.  I am wondering
> if when SAS reads the 2nd dataset, it will correctly recognize the missing
> values for what they are represented in real binary.

Since "no conversion is needed",
there is no possibility for SAS to do the "wrong" thing.

So, my guess is that it will work.

Why not try a small program, and a small dataset,
and see if SAS does what you expect?
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.sas-l
Date:         Wed, 11 Nov 1992 08:41:00 PT
Reply-To:     jack.hamilton@AMAIL.AMDAHL.COM
From:         jack.hamilton@AMAIL.AMDAHL.COM
Subject:      re: FTP Transport
Comments: To: apple!ohstvma.bitnet!sas-l@juts.ccc.amdahl.com

David Nasser wrote:

> Didn't I hear that its *not really practical* to connect (so much as)
> a CD-ROM to the Big Box? What about 4mm, 8mm DAT? I don't expect to
> see sny of this anytime soon. But you were pulling my leg, eh? eh?

Well, no.  I do think it would be useful.  That's not the same as practical.

I don't know what kind of equipment is available to do that kind of thing.
If there is such a thing as an automatic duplicator/labeler, it would probably
be less complicated and less expensive to attach it to a PC, and have files
automatically downloaded to the PC, which would handle them.


> >> The _not-so-good_ news is that it was sloooooooooow. Transfer rate
> >> averaged about 1 kb/sec. Terminal session on (dialed-in) PC was
> >> dedicated to FTP for perhaps 5 hours. Anybody ever heard of running
> >> FTP in MVS batch??
> >
> >Yes.  IBM's ftp for MVS supports it.  It's documented in "IBM TCP/IP V2R2 f
> >MVS: User's Guide", SC31-6088-01.  Basically, you have a batch step PGM=FTP
> >withan INPUT DD pointing to the commands and an OUTPUT DD pointer to a prin
> >or print file.
> >
>
> I had difficulty getting info on this from the local *data center* folk.
> They recommend: //  EXEC IKJEFT01 , and, so long as it works, I'm
> agonna run it!

IKJEFT01 is batch TSO?  That should work too.  What about return codes?  Does
either method give you adequate notification if the transfer fails?
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.sas-l
Date:         Mon, 9 Nov 1992 08:38:00 EST
Reply-To:     Sally Muller <UNCSM1@UNC.BITNET>
From:         Sally Muller <UNCSM1@UNC.BITNET>
Subject:      SAS 3270 Emulator that runs under UNIX!

----------------------------------------------------------------------
SUMMARY:  Correction to my message regarding SAS 3270 Emulator
          running under UNIX.
REL/PLTF: 6.07 UNIX boxes
E-ADDR:   uncsm1@unc.bitnet
NAME:     Sally Muller
PH/ADDR:  919-962-6501  OIT CB#3455, UNC, Chapel Hill NC 27514
----------------------------------------------------------------------
Sorry folks!  In my message regarding SI's new 3270 emulator, my
subject line was misleading and so was some of the text.  I'm
hoping to clear up any confusion now.........SI's new emulator
emulates a 3270-type terminal and it runs under UNIX.  OK just
for certain......SI's soon-to-be-released new product is a 3270
emulator and currently runs *only* under UNIX.  The experimental
version will be available 01dec92.  If you would like to be an
experimental site just contact Phil Herold at SAS:
__________________________________________________
 Phil Herold                     SAS Institute Inc.
 saspjh@unx.sas.com              SAS Campus Drive
 (919)677-8000 x7784    J234     Cary, NC 27513
__________________________________________________
PS  -- the target date for shipping production version is 2Q93.
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
From: U32472@uicvm.uic.edu (Alan Hinds)
Newsgroups: bit.listserv.sas-l
Subject: CPU cost of COMPRESS=YES in CMS SAS 6.07
Date: 6 Nov 92 22:05:23 GMT
Organization: University of Illinois at Chicago

I find that data compression (COMPRESS=YES) is very expensive in CPU
time in SAS 6.07 for CMS.  Individual SAS steps take from 2 to 9 times
as much CPU time with COMPRESS=YES as they do with COMPRESS=NO.  The
average for complete SAS jobs seems to be about a factor of 3 in CPU use
with compression.  Often, the compressed file is larger than if
compression had not been done!  Some files do compress dramatically.

As the large CPU cost of compressing temporary SAS datasets results in
no permanent disk space savings, I would welcome a SAS option to
compress permanent SAS datasets only.  There are few instances in which
our temporary disk space is tight enough to require compression, but
permanent disk space is another matter.  Most of my clients will not be
bothered to specify compression on a dataset basis.  They simply take
the installation default, which here is COMPRESS=YES.  Therefore, I
urge the addition of a COMPRESS=PERM option to compress permanent
datasets only.
                   - Alan Hinds
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU