topic remove the string in the text ? in SAS Programming

remove the string in the text ?

ybz12003 — Fri, 13 Mar 2020 15:48:12 GMT

Hello,

I would like to remove the 'CAR|ID|IL|PA|KK' in the ID column. The result is shown in the 'Result' column. Please advice.

data TEST;
      infile datalines dsd;
  input ID : $300.  Result : $200.;
datalines;
	CAR ID  MA,  MA
	ILH, H
	PAUL  VN, UL VN
	KKK GGGG, K GGGG
	Card ID BMA, d BMA
	Care ID FMA, e FMA
;

run;

Re: remove the string in the text ?

novinosrin — Fri, 13 Mar 2020 15:53:56 GMT

data TEST;
      infile datalines dsd;
  input ID : $300.  Result : $200.;
datalines;
	CAR ID  MA,  MA
	ILH, H
	PAUL  VN, UL VN
	KKK GGGG, K GGGG
	Card ID BMA, d BMA
	Care ID FMA, e FMA
;

run;
%let list=CAR|ID|IL|PA|KK;
data want;
 set test;
 id=strip(prxchange("s/(&list)//i", -1, id));
run;

ID	Result
MA	MA
H	H
UL VN	UL VN
K GGGG	K GGGG
d BMA	d BMA
e FMA	e FMA