Date:         Fri, 22 Oct 1999 16:22:05 +0000
Reply-To:     kmself@ix.netcom.com
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Karsten M. Self" <kmself@IX.NETCOM.COM>
Organization: Self Analysis
Subject:      Sorting large data sas data sets: Help !!
Comments: To: Kattamuri.Sarma@RESPONSEINSURANCE.COM
Content-Type: text/plain; charset=us-ascii

> Date:    Fri, 22 Oct 1999 13:01:29 GMT
> From:    Kattamuri.Sarma@RESPONSEINSURANCE.COM
> Subject: Sorting large data sas data sets: Help !!
>
> Dear SAS-lers :
>    I have been getting this message, no matter how much I increase the work
> files (sortwk001,...sortwk008).
>    This is done on the main frame. (MVS)
>     proc sort data=temp ;
>       by    pno masterkey ;
>    run ;
>     temp is a temporary sas data set.  The way SAS is configured at this
> installation, SYNCSORT ( or something
>     similar) is used .  Temp has 1.7 million records, and 90 variables.

While this dataset may be sorted and several suggestions for increasing
available MVS resources have been posted, I'd like to suggest you
revisit your algorithm if possible.  Often subsetting records,
summarizing (with the NOTSORTED option) along the existing sort order,
and dropping variables can reduce the size of a dataset considerably to
the point that a sort is no longer a major undertaking.

--
Karsten M. Self (kmself@ix.netcom.com)
    What part of "Gestalt" don't you understand?

SAS for Linux: http://www.netcom.com/~kmself/SAS/SAS4Linux.html
Mailing list:  "subscribe sas-linux" to
mailto:majordomo@cranfield.ac.uk
  9:17am  up 21:35,  2 users,  load average: 0.11, 0.19, 0.12