topic Re: Extract Number from a character variable in SAS Programming

Extract Number from a character variable

Nadra999 — Wed, 30 Nov 2016 20:04:51 GMT

I imported data from CSV files and one of the variables is character (should be numeric).

The variables has numbers like "1000" and "2000" but some look like "1000..." or "2000...." - they have there extra "..." that vary in lenght at the end. How can I extract just the numbers?

Nadra

Re: Extract Number from a character variable

snoopy369 — Wed, 30 Nov 2016 20:19:46 GMT

num_val = input(compress(char_val,,'kd'),best32.);

Now, I assume you have only positive integer here. If decimal or negative are possible, then you may need much more complicated code to deal with that possibility (as you have . and such in your examples and can't just keep all . )...

Re: Extract Number from a character variable

Nadra999 — Wed, 30 Nov 2016 20:22:10 GMT

Worked! Thanks!!