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;
Seems like this is what you want?
data _null_;
x='/a/s/vvv122!!@#jfjfjf2222/-';
y=compress(x,'','kad');
put y;
run;
Seems like this is what you want?
data _null_;
x='/a/s/vvv122!!@#jfjfjf2222/-';
y=compress(x,'','kad');
put y;
run;
i've read ur code and then i have a doubt what if we only keep special char thanks in advance
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.
Alternatively
data _null_;
x='/a/s/vvv122!!@#jfjfjf2222/-';
y=prxchange('s/\W//', -1, x);
put y;
run;
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;
Hi Jagadeesh
Your regular expressions solutions are very impressive please give any videos on regx
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.