DATA Step, Macro, Functions and more

pick the numeric only

Accepted Solution Solved
Reply
Contributor
Posts: 67
Accepted Solution

pick the numeric only

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


Accepted Solutions
Solution
‎10-17-2016 04:39 PM
Super User
Posts: 5,496

Re: pick the numeric only

SAS makes this easy:

 

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

 

"kd" means "keep the digits".

View solution in original post


All Replies
Solution
‎10-17-2016 04:39 PM
Super User
Posts: 5,496

Re: pick the numeric only

SAS makes this easy:

 

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

 

"kd" means "keep the digits".

Contributor
Posts: 67

Re: pick the numeric only

Posted in reply to Astounding

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.

Super User
Posts: 5,496

Re: pick the numeric only

Contributor
Posts: 67

Re: pick the numeric only

Posted in reply to Astounding

Thanks for the useful info.

I appreciate your time and the prompt response.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 315 views
  • 1 like
  • 2 in conversation