topic Re: how to splite the word before cama in SAS Programming

how to splite the word before cama

teja5959 — Mon, 23 Dec 2019 09:12:43 GMT

data have ;

a b

001 NEW OTC OR RX DRUG ADDED, HOSPITALIZATION (INCLUDES ER VISITS)

002 NEW OTC OR RX DRUG ADDED, Non-drug therapy, HOSPITALIZATION (INCLUDES ER VISITS)

003 STUDY TREATMENT DISCONTINUED PERMANENTLY, Non-drug therapy, HOSPITALIZATION (INCLUDES ER VISITS)

i want

001 NEW OTC OR RX DRUG ADDED

002 NEW OTC OR RX DRUG ADDED

003 STUDY TREATMENT DISCONTINUED PERMANENTLY

Re: how to splite the word before cama

Kurt_Bremser — Mon, 23 Dec 2019 09:19:40 GMT

Use

scan(b,1,',')

Re: how to splite the word before cama

ed_sas_member — Mon, 23 Dec 2019 09:23:30 GMT

Hi @teja5959

You can use the scan function:

data want;
	set have;
	b2 = scan(b,1,",");
	drop b;
	rename b2 = b;
run;

or the prxchange function:

data want;
	set have;
	b2 = prxchange('s/,.+//',1,b);
	drop b;
	rename b2 = b;
run;

Re: how to splite the word before cama

Kalind_Patel — Mon, 23 Dec 2019 09:22:53 GMT

Try this SAS Code:

data have;
input number texts $80.;
datalines;
001                NEW OTC OR RX DRUG ADDED, HOSPITALIZATION (INCLUDES ER VISITS)
002               NEW OTC OR RX DRUG ADDED, Non-drug therapy, HOSPITALIZATION (INCLUDES ER VISITS)
003              STUDY TREATMENT DISCONTINUED PERMANENTLY, Non-drug therapy, HOSPITALIZATION (INCLUDES ER VISITS)
;;;;
run;

data want;
set have;
texts=scan(texts,1,',');
run;