How to get the desired output ?

[Aayushi_17]

Hi i have got a column xy where the values are stored as shown.

XY

(Drug A)-(Drug-BB)-(Drug-CCC)

(Drug-BB)-(Drug A)-(Drug-CCC)

(Drug-CCC)-(Drug-BB)-(Drug A)

I wanted the output like this.The values to be stored in separate column under a b and c. Please help me if anyone knows the answer for this. 

A	B	C
Drug A	Drug-BB	Drug-CCC
Drug-BB	Drug A	Drug-CCC
Drug-CCC	Drug-BB	Drug A

Thanks in advance.

[novinosrin · Accepted solution]

data have;
input xy $50.;
cards;
(Drug A)-(Drug-BB)-(Drug-CCC) 
(Drug-BB)-(Drug A)-(Drug-CCC)
(Drug-CCC)-(Drug-BB)-(Drug A)
;


data want;
set have;
t=compress(tranwrd(xy,')-(' ,','),'()');
a=scan(t,1,',');
b=scan(t,2,',');
c=scan(t,3,',');
drop t;
run;

[Aayushi_17]

thank you