Converting char with $ to Numeric

[bryan22]

Hi, I am trying to sum a text field that has currency values with a $ in front ($1,109.23 for example).  I am using the code below but am getting nulls returned.  Any way I can do this?  Thanks.

sum(input(substr(dollar_value,2,length(dollar_value)-1),20.))

[Astounding]

The code you have shown is but a piece of a SAS statement.  So I have to assume that the context in which you are using it is correct.  This would be the replacement code for a variable that is defined as character with a length of 20:

sum(input(dollar_value, dollar20.))