Date:         Thu, 30 Sep 2010 12:07:46 -0400
Reply-To:     Gerhard Hellriegel <gerhard.hellriegel@T-ONLINE.DE>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Gerhard Hellriegel <gerhard.hellriegel@T-ONLINE.DE>
Subject:      Re: data management problem : conditional sort of observations
              (2nd attempt at posting)
Content-Type: text/plain; charset=ISO-8859-1

I can't see a table at all! No top and no below one... I think a table is
something with any structure. What I see is a bit of unstrucured data and
I cannot see what's given and what's wanted and I cannot see the data-
structure.

Gerhard





On Thu, 30 Sep 2010 16:57:50 +0100, Eamonn O'Brien
<eamonnjobrien@GMAIL.COM> wrote:

>Hi
>
>Sent this earlier and the tables weren�t clear, hopefully this is clearer.
>
>I am looking for help with a problem I am faced with. I have the structure
>in the top table and I want the structure below. I want the observation in
>col1 to match with the link variable after the �_�. The order of the
>unmatching _NAME_ and Col1 within teh variabel ref do not matter.
>
>Any help will be appreciated.
>
>
>
>
>
>ref                    link
>_NAME_
>COL1
>
>270263            xxxR586_UB18307/91            Path_No1        UB18322/91
>
>270263
>Path_No2
>UB18307/91
>
>314776            xxxR208_UB743/05                Path_No1        UB323/05
>
>314776
>Path_No2
>UB743/05
>
>386811            xxxR521_UB1399/03              Path_No1
UB26379/02
>
>386811
>Path_No2
>UB1399/03
>
>386811
>Path_No4
>UB15479/06
>
>
>
>ref                    link
>_NAME_
>COL1
>
>270263            xxxR586_UB18307/91            Path_No2        UB18307/91
>
>270263
>Path_No1
>UB18322/91
>
>314776            xxxR208_UB743/05                Path_No2        UB743/05
>
>314776
>Path_No1
>UB323/05
>
>386811            xxxR521_UB1399/03              Path_No2        UB1399/03
>
>386811
>Path_No1
>UB26379/02
>
>386811
>Path_No4
>UB15479/06