topic Re: remove all special characters in SAS Programming

remove all special characters

Ronein — Wed, 04 Sep 2019 06:05:48 GMT

Hello

What is the way to remove all special characters

The current value is /a/s/vvv122!!@#jfjfjf2222/-

and desired value is asvvv122jfjfjf2222

data aaa;
x='/a/s/vvv122!!@#jfjfjf2222/-';
w1=compress(x, '/');/*remove / */
w2=compress(x,'','kd');/*Keeps only digits*/
w3=compress(x,"","ka");/*Keep only alphanumeric characters*/
w4=compress(x, ' ', 'A');/*Keeps only digits and special characters*/
Run;

Re: remove all special characters

PeterClemmensen — Wed, 04 Sep 2019 06:14:31 GMT

Seems like this is what you want?

data _null_;
    x='/a/s/vvv122!!@#jfjfjf2222/-';
    y=compress(x,'','kad');
    put y;
run;

Re: remove all special characters

Sathish_jammy — Wed, 04 Sep 2019 06:23:27 GMT

w5=compress(x,"abcdefghijklmnopqrstuvwxyz1234567890","k");/*Keeps only digits and characters*/

If you are sure about the variable listed only character and numeric then use the given code.

Re: remove all special characters

PeterClemmensen — Wed, 04 Sep 2019 10:46:27 GMT

Alternatively

data _null_;
    x='/a/s/vvv122!!@#jfjfjf2222/-';
    y=prxchange('s/\W//', -1, x); 
    put y;
run;

Re: remove all special characters

Jagadishkatam — Wed, 04 Sep 2019 11:41:51 GMT

Alternatively with perl regular expression to perform the below 4 actions

data aaa;
x='/a/s/vvv122!!@#jfjfjf2222/-';
w1=prxchange('s#/##',-1,x); /*remove / */
w2=prxchange('s#\D*##',-1,x);/*Keeps only digits*/
w3=prxchange('s#(\W)##i',-1,x);/*Keeps only digits*/
w4=prxchange('s#[[:alpha:]]##i',-1,x);/*Keeps only digits and special characters*/
Run;

Re: remove all special characters

Emma_at_SAS — Wed, 07 Apr 2021 16:51:51 GMT

Thank you Sathish_Jammy! It was very easy to use your code!

Re: then how to keep only special char

saidatta — Sun, 30 May 2021 12:36:56 GMT

i've read ur code and then i have a doubt what if we only keep special char thanks in advance

Re: remove all special characters

BrahmanandaRao — Wed, 18 Aug 2021 07:07:03 GMT

Hi Jagadeesh

Your regular expressions solutions are very impressive please give any videos on regx