topic Table - convert from character to numeric in SAS Programming

Table - convert from character to numeric

lca — Tue, 11 Oct 2011 15:16:23 GMT

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

Table - convert from character to numeric

art297 — Tue, 11 Oct 2011 15:20:08 GMT

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;

Table - convert from character to numeric

chimanbj1 — Tue, 11 Oct 2011 18:29:30 GMT

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;

Table - convert from character to numeric

lca — Tue, 11 Oct 2011 18:38:00 GMT

Yes. Worked. Thank you

Table - convert from character to numeric

art297 — Tue, 11 Oct 2011 18:43:07 GMT

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.

Table - convert from character to numeric

chimanbj1 — Tue, 11 Oct 2011 19:46:34 GMT

You are so right, Art! My mistake!