I am a beginning SAS user and have taken over a job with a company. Many lines of data that the SAS program uses come from a .txt file. One of the columns "On-Hand" is set up in SAS as a numeric value, however somehow in the .txt file a negative amount is written as (# -) instead of (- #). SAS can not read this as a numeric number. Is there an easy way to have the number truly be a negative number? At first I tried to just convert it to a character, but another program uses this information for a calculation and I now get errors with the calculation. I really appreciate it if anyone can help.
... View more