topic How to get the desired output ? in SAS Programming

How to get the desired output ?

Aayushi_17 — Sun, 14 Apr 2019 04:29:15 GMT

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

(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.

Re: How to get the desired output ?

novinosrin — Sun, 14 Apr 2019 05:27:11 GMT

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;

Re: How to get the desired output ?

Aayushi_17 — Sun, 14 Apr 2019 06:02:33 GMT

thank you