https://communities.sas.com/t5/SAS-Data-Science/Converting-char-with-to-Numeric/m-p/388226#M5825 <P>The code you have shown is but a piece of a SAS statement.&nbsp; So I have to assume that the context in which you are using it is correct.&nbsp; This would be the replacement code for a variable that is defined as character with a length of 20:</P> <P>&nbsp;</P> <P>sum(input(dollar_value, dollar20.))</P> Tue, 15 Aug 2017 17:26:11 GMT Astounding 2017-08-15T17:26:11Z https://communities.sas.com/t5/SAS-Data-Science/Converting-char-with-to-Numeric/m-p/388219#M5824 <P>Hi, I am trying to sum a text field that has currency values with a $ in front ($1,109.23 for example).&nbsp; I am using the code below but am getting nulls returned.&nbsp; Any way I can do this?&nbsp; Thanks.</P><P>&nbsp;</P><P>sum(input(substr(dollar_value,2,length(dollar_value)-1),20.))</P><P>&nbsp;</P> Tue, 15 Aug 2017 17:10:28 GMT https://communities.sas.com/t5/SAS-Data-Science/Converting-char-with-to-Numeric/m-p/388219#M5824 bryan22 2017-08-15T17:10:28Z https://communities.sas.com/t5/SAS-Data-Science/Converting-char-with-to-Numeric/m-p/388226#M5825 <P>The code you have shown is but a piece of a SAS statement.&nbsp; So I have to assume that the context in which you are using it is correct.&nbsp; This would be the replacement code for a variable that is defined as character with a length of 20:</P> <P>&nbsp;</P> <P>sum(input(dollar_value, dollar20.))</P> Tue, 15 Aug 2017 17:26:11 GMT https://communities.sas.com/t5/SAS-Data-Science/Converting-char-with-to-Numeric/m-p/388226#M5825 Astounding 2017-08-15T17:26:11Z