Date: Thu, 30 Sep 2010 16:17:19 +0100
Reply-To: Eamonn O'Brien <eamonnjobrien@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Eamonn O'Brien <eamonnjobrien@GMAIL.COM>
Subject: data management problem : conditional sort of observations:
Content-Type: text/plain; charset=windows-1252
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
Hi
I am looking for help with a problem I am faced with. I have the above
structure 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 do not matter.
Any help will be appreciated.
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
| 
