DATA Step, Macro, Functions and more

Convert characters to numeric

Reply
Regular Contributor
Posts: 218

Convert characters to numeric

[ Edited ]

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,

 

Super User
Posts: 19,855

Re: Convert characters to numeric

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.
Ask a Question
Discussion stats
  • 1 reply
  • 96 views
  • 0 likes
  • 2 in conversation