remove the string in the text ?

[ybz12003]

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;

[novinosrin · Accepted solution]

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