topic How to convert the character string including percentage and numbers into numeric data? in SAS Programming

How to convert the character string including percentage and numbers into numeric data?

daisy6 — Sat, 17 Jun 2017 01:43:35 GMT

Hello

I have character strings which including percentage and numbers. how do I convert them into numeric data?

my data is

var

45.5%

23.64%

44.56%

798

I use the code:

data a;

set a;

if var=:"%" then var1=input(var,percent8.);

else var1=input(var,best8.);

run;

But it does not work.

Thanks a lot!

Re: How to convert the character string including percentage and numbers into numeric data?

Jagadishkatam — Sat, 17 Jun 2017 01:49:12 GMT

I tried as below and it works

data have;
input var$10.;;
cards;
45.5%
34
23.64%
23
44.56%
798
;

data want;
set have;
if index(var,'%') then new=input(var,percent.);
else new=input(var,best.);
run;

Re: How to convert the character string including percentage and numbers into numeric data?

daisy6 — Sat, 17 Jun 2017 01:51:00 GMT

Thank you very much!

Re: How to convert the character string including percentage and numbers into numeric data?

Reeza — Sat, 17 Jun 2017 03:04:01 GMT

The =: only checks if the variables start with that character string, not contains. ie does it start with a percentage sign. To check if hte variable contains a % sign you would use FIND or INDEX.