Date: Mon, 16 Dec 2002 17:10:23 -0000
Reply-To: Roland <roland@RASHLEIGH-BERRY.FSNET.CO.UK>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Roland <roland@RASHLEIGH-BERRY.FSNET.CO.UK>
Subject: Re: Proc cimport and sortinfo
What you should do is assume the dataset is sorted in the order you want.
That way you will not have to sort it again.
"Roland" <firstname.lastname@example.org> wrote in message
> When you create a new dataset from a sorted dataset then the sort
> information is always lost.
> "Shukla Kshirsagar" <shuklak@HOTMAIL.COM> wrote in message
> > Hello everybody,
> > I have created a sorted (ascii) transport data set on the mainframe,
> > I download to the PC.
> > proc sort data=sastemp.temp1 ascii;
> > by id;run;
> > When the SAS data set is created on the PC, if I look at the properties,
> > the 'sorted by' info is blank. If I use proc sort on this data set, SAS
> > sorts it over again, but not really, since the data set was already
> > by ID. I had created a variable called counter=_n_, and the sorted
> > has the same order for counter as the unsorted data set.
> > On the mainframe side, my code looks like this:
> > proc cport data=sastemp.temp1 file=xout sortinfo=yes;
> > run;
> > The log gives
> > Warning:The Sortinfo option is obsolete.
> > I am using SAS version 8.1 on the PC and 8.2 on mainframe. Given the
> > of our data, it would be optimal for us to sort on the mainframe and
> > download to the PC.
> > Thanks for all your help,
> > Shukla