topic Re: Remove different types of characters together from numeric values in SAS Programming

Remove different types of characters together from numeric values

Barkat — Fri, 18 Jun 2021 20:42:33 GMT

How can I remove different types of characters including blank spaces from the numeric values in a column.

I have

a= " 12345 *duplicate ID/Name "

I want

b=12345

Please see below what I tried.

data test;
a= " 12345 *duplicate ID/Name ";
b= input(strip(compress(a, 'abcdefghijklmnopqrstuvwxyz/*' )), 10.);
run;

tarheel13 — Fri, 18 Jun 2021 20:56:13 GMT

data test;
a= " 12345 *duplicate ID/Name  ";
B=compress(compress(a,"`~!@#$%^&*()-_=+\|[]{};:',.<>?/"),'','A');
put a= b=;
run;

Oligolas — Fri, 18 Jun 2021 21:11:23 GMT

data test;
a= " 12345 *duplicate ID/Name ";
b= input(compress(a,,'kd'),best.);
run;

Barkat — Fri, 18 Jun 2021 21:45:42 GMT

Thanks all