topic Re: Removing quoted text from value in SAS Programming

Removing quoted text from value

kalbo — Fri, 05 Nov 2021 13:16:22 GMT

Hi all

I have some values containing text which can be in single or double quote marks. I would like to remove the quote marks plus the text inside

e.g.

have:

VAR1

hello "dog" is my pet

just text

hi 'people' how are you

want:

VAR1

hello is my pet

just text

hi how are you

thanks for your help

Re: Removing quoted text from value

PeterClemmensen — Fri, 05 Nov 2021 13:26:15 GMT

One way

data have;
input var1 $ 1 - 25;
datalines;
hello "dog" is my pet   
just text               
hi 'people' how are you 
;

data want;
   set have;
   var1 = compbl(prxchange('s/".*"//', -1, prxchange("s/'.*'//", -1, var1)));
run;

Re: Removing quoted text from value

kalbo — Fri, 05 Nov 2021 13:42:59 GMT

Thanks for helping..it works perfectly

Re: Removing quoted text from value

PeterClemmensen — Fri, 05 Nov 2021 13:46:28 GMT

Anytime 🙂

Re: Removing quoted text from value

Ksharp — Sat, 06 Nov 2021 11:04:04 GMT

Peter.C

If there were multiple quote characters, your code would get wrong result.

Like this sort of data.

data have;
input var1 $ 1 - 40;
datalines;
hello "dog" is my pet "dog" xxx 
just text 
hi 'people' how are you 'people' 
;

data want;
   set have;
   var1 =prxchange("s/'.*?'|"".*?""//", -1, var1);
run;

Re: Removing quoted text from value

Ksharp — Sat, 06 Nov 2021 11:02:44 GMT

data have;
input var1 $ 1 - 40;
datalines;
hello "dog" is my pet "dog" xxx 
just text               
hi 'people' how are you 'people'  
;