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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.