topic string operation problem in SAS Procedures

string operation problem

Mike_Davis — Tue, 17 Jul 2012 20:43:52 GMT

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 — Tue, 17 Jul 2012 21:11:57 GMT

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

Linlin — Tue, 17 Jul 2012 23:46:27 GMT

data one;

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

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

run;

proc print;run;