pick the numeric only

[ursula]

Hi there,

I tried to clean the ID column in my dataset.

ID

ID, CODE 101-1111-1

ID, 102-2222-143

CODE 103-3333-8(45)

ID CODE, 104-4444-644

I want to keep the numeric only, as follow:

ID

10111111

1022222143

1033333845

1044444644

Any codes to share will be very appreciate.

Thanks in advance.

ursula

[Astounding · Accepted solution]

SAS makes this easy:

id = compress(id,,'kd');

"kd" means "keep the digits".

[ursula]

Thank you very much Astounding!

It works!! I'm so happy.

just curious, if I want to keep the Character only, how does the code look like?

want to keep:

ID

ID, CODE

ID

CODE

ID CODE

Thanks again.

[Astounding]

Many variations are possible.  Take a look here:

http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000212246.htm

[ursula]

Thanks for the useful info.

I appreciate your time and the prompt response.