topic Re: problem from data cleansing in New SAS User

problem from data cleansing

harrylui — Mon, 10 Feb 2020 02:22:27 GMT

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!

Re: problem from data cleansing

novinosrin — Mon, 10 Feb 2020 03:01:28 GMT

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;

Re: problem from data cleansing

ed_sas_member — Mon, 10 Feb 2020 12:05:52 GMT

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;

Re: problem from data cleansing

harrylui — Wed, 12 Feb 2020 09:33:19 GMT

thank you