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

[daisy6]

Hello

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

my data is 

var

45.5%

34

23.64%

23

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!

[Jagadishkatam · Accepted solution]

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;

[daisy6]

Thank you very much!

[Reeza]

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.