How to convert character with € symbol format to numeric format?

[mgrd]

Hello,

I need to transform a variable character with € symbol to numeric formal. Like this:

Outstanding_Old             Outstanding_New

110,817.70€                      110,817.70

 46,273.19€                         46,273.19

 61,234.99€                         61,234.99

 88,841.87€                         88,841.87

Thanks,

mgrd

[Jagadishkatam]

Please try

data have;
input Outstanding_Old$20.;
inf=input(compress(Outstanding_Old,'€'),euro10.2);
format inf comma10.2;
cards;
110,817.70€                     
46,273.19€                     
61,234.99€                     
88,841.87€   
; 

[mgrd]

Thanks Jag, It works!