08-27-2017 01:49 PM - edited 08-27-2017 01:56 PM
I am trying to convert a Character value ($9.) to Numeric. As an example In sas table my Character value looks like $400.00. In my output table all I am seeing under the new column (numeric_var) is a (.)
Can someone help he with the code please.
DATA Apple.Financial_Report11; SET Apple.Financial_Report; numeric_var = input(old_Var, 9.); RUN;