Date:         Mon, 16 Dec 2002 17:09:13 -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

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
news:200212161658.gBGGw5D12239@listserv.cc.uga.edu...
> Hello everybody,
>
> I have created a sorted (ascii) transport data set on the mainframe, which
> 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 sorted
> by ID.  I had created a variable called counter=_n_, and the sorted
dataset
> 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 size
> 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