|
After you put have put them back together again (proc append ? ),
use proc datasets to set the data set option SortedBy=
proc datasets library=<yours>;
modify <combined>( sortedby = var1 var2 var3 );
run;
quit;
Datum: 04/04/2001 16:08
An: SAS-L@listserv.uga.edu
Antwort an: DZENGER@klune.com
Betreff: Re: SORT PROBLEM
Nachrichtentext:
I've got that same problem with a file about 10 million. I'm on Win98 (With
SAS 8.1) and was going to attempt to figure out why. If I do I'll let you
know, meantime, anyone out here gave a suggestion would be greatly
appreciated too!
Darran Zenger
Klune Industries, INC
Spanish Fork Division
dzenger@klune.com
-----Original Message-----
From: Kevin F. Spratt [mailto:kevin-spratt@UIOWA.EDU]
Sent: Wednesday, April 04, 2001 8:05 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: SORT PROBLEM
Using SAS 8.1 under Windows 2000 (millenium) on a Pentium III machine
with 5 gigs of free hard drive and 256 MB RAM, the following message
results from an attempt to sort this temporary file that has 14,201,120
records.
If I can't sort a file this large, and I break it up by year, is there
a way to convince SAS that, once I take these smaller files that
have been sorted by period and cusip within each year, and put them
back into a single file, that this new file is sorted by year period
and cusip?
53 PROC SORT DATA=WORK.TRE ;BY YEAR PERIOD CUSIP;
ERROR: User does not have appropriate authorization level for file
WORK._tf0010.UTILITY.
ERROR: File WORK._tf0010.UTILITY is damaged. I/O processing did not
complete.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: There were 14210120 observations read from the data set WORK.TRE.
NOTE: PROCEDURE SORT used:
real time 18:59.43
________________________________________________________________
_____________
Kevin F. Spratt, Ph.D. | |
Iowa Testing Programs (ITP) ( )
University of Iowa Back Care (UIBC) \ \_ University
Iowa Spine Research Center (ISRC) \ * \ of Iowa
224-D Lindquist Center \ / Hawkeyes
The University of Iowa |____________ )
Iowa City, Iowa 52242 V
(319) 335-5572 (voice)
(319) 335-6399 (fax)
Kevin-Spratt@Uiowa.edu (e-mail)
________________________________________________________________
--
Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet.
This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorised copying, disclosure or distribution of the material in this e-mail is strictly forbidden.
| 
