I have a table where one one of the columns have character format.
How do I convert the values from character to numeric format with proc sql? Possible?
Is this what you are looking for?
informat x $2.;
proc sql noprint;
create table want as
select input(x,2.) as x
View solution in original post
I think you meant tthis code:
select input(x,$2.) as x
Yes. Worked. Thank you
chimanbj1 wrote: I think you meant tthis code: <snip>
No, I meant the code that I posted. The OP wanted to convert character to numeric.
You are so right, Art! My mistake!
Need further help from the community? Please
ask a new question.