Date:         Mon, 3 Mar 2003 14:09:44 -0500
Reply-To:     "Richard A. DeVenezia" <radevenz@IX.NETCOM.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Richard A. DeVenezia" <radevenz@IX.NETCOM.COM>
Subject:      Re: [Tabulate] Can I order class values in case insensitive order
              ?

"Richard A. DeVenezia" <radevenz@ix.netcom.com> wrote in message
news:b3vd9j$1psemt$1@ID-168040.news.dfncis.de...
> I want to tabulate some data that has a class variable with values such as
>
> AAA#2
> ZZZ#2
> aaa#1
> zzz#1
>
> Is there an easy way to order the values irrespective of case ?
>
> aaa#1
> AAA#2
> zzz#1
> ZZZ#2
>
> --

It looks like I have to either

Transform class variable values to different values satisfying my ordering
criteria, create and use an appropriate custom format to map transformed
values back to original values and use tabulate option ORDER=INTERNAL.

or

Sort my data by class variable uppercased (either SQL w/ sort by
upcase(classvar), or Proc SORT on a dummy var) and use tabulate option
ORDER=DATA

Thanks for all the help