topic Re: Convert a multiple length character price variable to numeric in SAS Data Management

Convert a multiple length character price variable to numeric

Mathis1 — Wed, 20 May 2020 09:19:26 GMT

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 🙂

Re: Convert a multiple length character price variable to numeric

ed_sas_member — Wed, 20 May 2020 09:27:40 GMT

Hi @Mathis1

Please try the NLMNLEURw.d informat:

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

Best,

Re: Convert a multiple length character price variable to numeric

Kurt_Bremser — Wed, 20 May 2020 12:22:23 GMT

Try

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

Increase the informat width as needed.