string operation problem

[Mike_Davis]

Hello everyone,

How to deal with string to keep only numeric and comma?

such as %let a=asd1,2,ggg3,678,thy%@#@;

I just need b=1,2,3,678

Thanks;

data one;

a="asd1,2,ggg3,678,thy%@#@;";

b=somefunction(a,'0123456789,');

run;

[Reeza]

Try Compress, keep an eye on the modifiers, specifically k and d.

http://support.sas.com/documentation/cdl/en/syntaxidx/64656/HTML/default/index.htm#/documentation/cd...

[Linlin]

data one;

a="asd1,2,ggg3,678,thy%@#@;";

b=compress(a,',','dk');

run;

proc print;run;