Convert a multiple length character price variable to numeric

[Mathis1]

Hello,

I have a character variable under this form :

61.39€

47.32€

124.45€

12.3€

and i'd like to convert it into a numeric variable under that form :

61.39

47.32

124.45

12.3

I tried this code : 

Data WANT;
Set HAVE;
NEW=input(strip(scan(VAR,-1,"€")), 5);
run;

but i don't get what i want. I only get the price with three digits before the comma. Moreover those prices are only displayed with one decimal instead of 2. 

thank you for your help 🙂

[ed_sas_member · Accepted solution]

Hi @Mathis1 

Please try the NLMNLEURw.d informat:

data WANT;
	set HAVE;
	NEW=input(var,NLMNLEUR8.2);
run;

Best,

[Kurt_Bremser]

Try

NEW = input(compress(VAR,"€"),10.);

Increase the informat width as needed.