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
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;
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;
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;
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!
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.