https://communities.sas.com/t5/SAS-Programming/How-to-convert-character-with-symbol-format-to-numeric-format/m-p/249199#M46839 <P>Hello,</P><P>&nbsp;</P><P>I need to transform a variable character with € symbol to numeric formal. Like this:</P><P>&nbsp;</P><P>Outstanding_Old &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Outstanding_New</P><P>110,817.70€ &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;110,817.70</P><P>&nbsp;46,273.19€ &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 46,273.19</P><P>&nbsp;61,234.99€ &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 61,234.99</P><P>&nbsp;88,841.87€ &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 88,841.87</P><P>&nbsp;</P><P>Thanks,</P><P>mgrd</P> Wed, 10 Feb 2016 15:06:47 GMT mgrd 2016-02-10T15:06:47Z https://communities.sas.com/t5/SAS-Programming/How-to-convert-character-with-symbol-format-to-numeric-format/m-p/249199#M46839 <P>Hello,</P><P>&nbsp;</P><P>I need to transform a variable character with € symbol to numeric formal. Like this:</P><P>&nbsp;</P><P>Outstanding_Old &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Outstanding_New</P><P>110,817.70€ &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;110,817.70</P><P>&nbsp;46,273.19€ &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 46,273.19</P><P>&nbsp;61,234.99€ &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 61,234.99</P><P>&nbsp;88,841.87€ &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 88,841.87</P><P>&nbsp;</P><P>Thanks,</P><P>mgrd</P> Wed, 10 Feb 2016 15:06:47 GMT https://communities.sas.com/t5/SAS-Programming/How-to-convert-character-with-symbol-format-to-numeric-format/m-p/249199#M46839 mgrd 2016-02-10T15:06:47Z https://communities.sas.com/t5/SAS-Programming/How-to-convert-character-with-symbol-format-to-numeric-format/m-p/249204#M46841 <P>Please try</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas"> 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€ ; </CODE></PRE> Wed, 10 Feb 2016 15:21:25 GMT https://communities.sas.com/t5/SAS-Programming/How-to-convert-character-with-symbol-format-to-numeric-format/m-p/249204#M46841 Jagadishkatam 2016-02-10T15:21:25Z https://communities.sas.com/t5/SAS-Programming/How-to-convert-character-with-symbol-format-to-numeric-format/m-p/249219#M46848 <P>Thanks Jag, It works!</P> Wed, 10 Feb 2016 16:01:49 GMT https://communities.sas.com/t5/SAS-Programming/How-to-convert-character-with-symbol-format-to-numeric-format/m-p/249219#M46848 mgrd 2016-02-10T16:01:49Z