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.
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: