Date: Thu, 6 Sep 2001 00:57:28 -0700
Reply-To: Wei-heng Lin <cycuwlin@HOTMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Wei-heng Lin <cycuwlin@HOTMAIL.COM>
Subject: Re: Subsetting data by usig FIRST.xx,
I cann't sort xx by DESCENDING?
Content-Type: text/plain; charset=ISO-8859-1
c-Jeff.Voeller@wcom.com (Jeff Voeller) wrote in message news:<email@example.com>...
> On Wednesday, September 5, 2001 at 3:29 PM, Qiang Ling wrote:
> > ERROR: BY variables are not properly sorted on data set WORK.GRE.
> > After I changed to sort by using BY WORD, it works file.
> > I got confused.
> Your BY statements need to be identical in the SORT and DATA steps. In this
> case, if you just use BY DESCENDING WORD in your DATA step, you'll be fine.
I will use:
proc sort; by word;
data gre2; set gre; by word; if last.word;
Department of Accounting
CYCU, Taoyuan, Taiwan