BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Ronein
Onyx | Level 15

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;

 

1 ACCEPTED SOLUTION

Accepted Solutions
PeterClemmensen
Tourmaline | Level 20

Seems like this is what you want?

 

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

View solution in original post

7 REPLIES 7
PeterClemmensen
Tourmaline | Level 20

Seems like this is what you want?

 

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

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

 

Sathish_jammy
Lapis Lazuli | Level 10

 

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.

Emma_at_SAS
Lapis Lazuli | Level 10
Thank you Sathish_Jammy! It was very easy to use your code!
PeterClemmensen
Tourmaline | Level 20

Alternatively

 

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

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;

 

 

 

 

Thanks,
Jag
BrahmanandaRao
Lapis Lazuli | Level 10

Hi Jagadeesh

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

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 7 replies
  • 38094 views
  • 9 likes
  • 7 in conversation