Separate the words with '/' in the column

Sathish_jammy — Mon, 05 Oct 2020 10:18:03 GMT

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

Re: Separate the words with '/' in the column

PaigeMiller — Mon, 05 Oct 2020 10:46:16 GMT

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;

topic Re: Separate the words with '/' in the column in SAS Programming

Separate the words with '/' in the column

Re: Separate the words with '/' in the column