Separate the words with '/' in the column

[Sathish_jammy]

Hi,

I have a drug dataset for a research study. I need to separate the values by '/' in the column.

Kindly go through the sample set for the reference.

data have;
input Drug$80.;
cards;
metformin/Glicipage
Glibenclimide/glicipage
Alphaglid/glucose/SGLT2
Metformin/Glucose
;

Expected Output:

Drug1

Metformin

Glicipage

Glibenclimide

Alphaglid

Glucose

SGLT2

[PaigeMiller · Accepted solution]

data want;
    set have;
	length drug1 $ 24;
	do i=1 to countw(drug,'/');
	    drug1=scan(drug,i,'/');
		output;
	end;
	drop i;
run;
proc sql;
	create table want2 as select distinct upcase(drug1) as drug1 from want;
quit;