Table - convert from character to numeric

[lca]

Hi!

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?

lca

[art297 · Accepted solution]

Is this what you are looking for?

data have;

  informat x $2.;

  input x;

  cards;

1

2

3

;

proc sql noprint;

  create table want as

    select input(x,2.) as x

      from have

;

quit;

[chimanbj1]

I think you meant tthis code:

data have;

  informat x $2.;

  input x;

  cards;

1

2

3

;

proc sql noprint;

  create table want as

    select input(x,$2.) as x

      from have

;

quit;

[lca]

Yes. Worked. Thank you

[art297]

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.

[chimanbj1]

You are so right, Art! My mistake!