Convert characters to numeric

[mlogan]

Hi There,

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;

Thanks,

[Reeza]

Try the informat of dollar9.
The informat should reflect what the variable currently looks like and apply a format to show how you want it displayed.