https://communities.sas.com/t5/SAS-Programming/Convert-characters-to-numeric/m-p/391135#M93894 <P>Hi There,</P> <P>I am trying to convert a Character value ($9.) to Numeric. As an example In sas table my Character value looks like $400.00. In my output table all I am seeing under the new column (numeric_var) is a (.)</P> <P>Can someone help he with the code please.</P> <P>&nbsp;</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">DATA Apple.Financial_Report11; SET Apple.Financial_Report; numeric_var = input(old_Var, 9.); RUN;</CODE></PRE> <P>&nbsp;</P> <P>Thanks,</P> <P>&nbsp;</P> Sun, 27 Aug 2017 17:56:17 GMT mlogan 2017-08-27T17:56:17Z https://communities.sas.com/t5/SAS-Programming/Convert-characters-to-numeric/m-p/391135#M93894 <P>Hi There,</P> <P>I am trying to convert a Character value ($9.) to Numeric. As an example In sas table my Character value looks like $400.00. In my output table all I am seeing under the new column (numeric_var) is a (.)</P> <P>Can someone help he with the code please.</P> <P>&nbsp;</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">DATA Apple.Financial_Report11; SET Apple.Financial_Report; numeric_var = input(old_Var, 9.); RUN;</CODE></PRE> <P>&nbsp;</P> <P>Thanks,</P> <P>&nbsp;</P> Sun, 27 Aug 2017 17:56:17 GMT https://communities.sas.com/t5/SAS-Programming/Convert-characters-to-numeric/m-p/391135#M93894 mlogan 2017-08-27T17:56:17Z https://communities.sas.com/t5/SAS-Programming/Convert-characters-to-numeric/m-p/391138#M93896 Try the informat of dollar9.<BR />The informat should reflect what the variable currently looks like and apply a format to show how you want it displayed. Sun, 27 Aug 2017 18:01:43 GMT https://communities.sas.com/t5/SAS-Programming/Convert-characters-to-numeric/m-p/391138#M93896 Reeza 2017-08-27T18:01:43Z