Date:         Fri, 22 Oct 1999 19:52:16 GMT
Reply-To:     lpogoda@AOL.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         lpogoda@AOL.COM
Organization: Deja.com - Before you buy.
Subject:      Re: Sorting large data sas data sets: Help !!

Presumably, you've examined the data and determined that you really do
need all 90 of those variables, so I guess I'd start with finding out
why the host sort cannot be used.  After that, if the job keeps going
down every time you do a direct sort, maybe it's time to try something
else.

The easiest (to code) alternative that comes to mind is to use the
"tagsort" option of proc sort.  That'll cut way down on the necessary
resources - but be warned, it'll take a lot longer.

Another possible angle of attack is to split the file up into two or
five or ten pieces, sort each of them, and then interleave the sorted
pieces to build the final result.

In article <OF7C10BE29.7216E7C9-
ON85256812.0047EAA7@responseinsurance.com>,
  Kattamuri.Sarma@RESPONSEINSURANCE.COM wrote:
> ---------------------- Forwarded by Kattamuri S Sarma/HR/NY/DRC on
10/22/99
> 09:05 AM ---------------------------
>
> Kattamuri.Sarma@RESPONSEINSURANCE.COM@LISTSERV.UGA.EDU> on 10/22/99
> 09:01:29 AM
>
> Please respond to Kattamuri.Sarma@RESPONSEINSURANCE.COM
>
> Sent by:  "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
>
> To:   SAS-L@LISTSERV.UGA.EDU
> cc:
>
> Subject:  Sorting large data sas data sets: More 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.
>
> Sort did not complete successfully. See messages on the Job Console
Log o
> ERROR: Sort did not complete successfully. See messages on the Job
Console
> Log o
> ERROR: Sort did not complete successfully. See messages on the Job
Console
> Log o
> ERROR: Host sort cannot be used.
>
> ERROR: Host sort cannot be used.
>
> ERROR: Host sort cannot be used.
>
> When I reduce the number of work fikles Sortwk001-sortwk005, and
reduce
> the number of cylenders requested, I get the following message :
>
> DFSORT TERMINATED WITH U0318 ABEND DURING PHASE S 3
> JOB STAKSSPE         STEP SAS69           TIME 090347   DATE 99295
>
>   I would appreciate any suggestions
>
> TIA
> Kattamuri Sarma
>


Sent via Deja.com http://www.deja.com/
Before you buy.