Date:         Thu, 30 Oct 2008 17:11:53 -0400
Reply-To:     Dave Smith <daveyboysmith_123@YAHOO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Dave Smith <daveyboysmith_123@YAHOO.COM>
Subject:      data issue?

Hello all,

I am a newbie to SAS and have a problem which I am trying to work! if
someone can give me some help or direction,thanks in advance

i have 4 alpha numeric columns

case number part number case_dt  route
a  a1 1/1/2008 a1
a  a1 1/1/2008 a1
a  a1 1/1/2008 b1
.
b               a1      6/10/2008       a4.. etc

and so on..

now for each unique combination of case number part number and date I want
to first identify unique routes, i.e. I just compare a route value to
previous route value and if they are same then I delete the newer one else
I consider them as unique,

and then I want to list for all the combinations the route in a row that
is transpose them from columns to rows, so in this I want the output as

a a1 1/12008 a1,b1

Can anyone please help,

Thanks

Dave