problem from data cleansing

[harrylui]

hi everyone,

i want to REMOVE the words connect to _ABCD and also _ABCD itself.

can anyone tell me how to do? and is it possible not to remove the word before it when it is one string like my example row 4?

Name

THE CLIFTON_ABCD
THE FOODIE BA_ABCD
THE HOME UBON_ABCD

MAKRONO_ABCD

thanks you so much for Helping me!

[novinosrin · Accepted solution]

data have;
input var $30.;
cards;
THE CLIFTON_ABCD
THE FOODIE BA_ABCD
THE HOME UBON_ABCD
MAKRONO_ABCD 
;

data want;
set have;
length want $50;
if countw(var,' ')>1 then want=substr(var,1,prxmatch('/\b[a-z]+_ABCD\b/i', var)-1);
else want=var;
run;

[ed_sas_member]

Hi @harrylui 

Another approach, also using a pearl regular expression:

data have;
	input name $50.;
	cards;
THE CLIFTON_ABCD
THE FOODIE BA_ABCD
THE HOME UBON_ABCD
MAKRONO_ABCD 
;

data want;
	set have;
	length name2 $30;
	name2 = prxchange('s/(.+)\b.+_ABCD/$1/',-1,name);
run;

[harrylui]

thank you