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:
sum(input(dollar_value, dollar20.))
Ready to join fellow brilliant minds for the SAS Hackathon?
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.