topic Re: pick the numeric only in SAS Programming

pick the numeric only

ursula — Mon, 17 Oct 2016 20:11:42 GMT

Hi there,

I tried to clean the ID column in my dataset.

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:

10111111

1022222143

1033333845

1044444644

Any codes to share will be very appreciate.

Thanks in advance.

ursula

Astounding — Mon, 17 Oct 2016 20:18:10 GMT

SAS makes this easy:

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

"kd" means "keep the digits".

ursula — Mon, 17 Oct 2016 20:30:10 GMT

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, CODE

CODE

ID CODE

Thanks again.

Astounding — Mon, 17 Oct 2016 20:33:28 GMT

Many variations are possible. Take a look here:

ursula — Mon, 17 Oct 2016 20:41:12 GMT

Thanks for the useful info.

I appreciate your time and the prompt response.