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
SAS makes this easy:
id = compress(id,,'kd');
"kd" means "keep the digits".
SAS makes this easy:
id = compress(id,,'kd');
"kd" means "keep the digits".
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.
Many variations are possible. Take a look here:
http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000212246.htm
Thanks for the useful info.
I appreciate your time and the prompt response.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.