topic Re: How to parse numbers from names? in SAS Programming

How to parse numbers from names?

lu_king — Fri, 09 Dec 2022 21:47:30 GMT

Any advice on how to parse a complicated variable?

For example.

People:

John

Tim K

00234 jorge

209384colleen

j lopez 0897111

I just need the numbers in the beginning and the end of the names either gone or in another variable. Since they're not exactly uniform, I am unsure on how to approach this. Any advice would be greatly appreciated!

Re: How to parse numbers from names?

PaigeMiller — Fri, 09 Dec 2022 22:47:04 GMT

data want;
    set have;
    numbers_wanted = compress(people,,'kd');
run;

Re: How to parse numbers from names?

tejarongli21 — Sat, 10 Dec 2022 10:27:05 GMT

use compress function with KD (keep Digits)

data example1;
set example;
num=compress(people,,'KD');
run;

Re: How to parse numbers from names?

PeterClemmensen — Sat, 10 Dec 2022 11:29:18 GMT

You want all numbers from your variable gone or you want only the ones at the beginning or end gone?

Re: How to parse numbers from names?

lu_king — Sat, 10 Dec 2022 23:30:25 GMT

Hi Peter,

Thanks for asking! I just need the numbers in the beginning and end gone!