SAS Programming

DATA Step, Macro, Functions and more
BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
lca
Calcite | Level 5 lca
Calcite | Level 5

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

1 ACCEPTED SOLUTION

Accepted Solutions
art297
Opal | Level 21

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;

View solution in original post

5 REPLIES 5
art297
Opal | Level 21

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
Calcite | Level 5

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
Calcite | Level 5 lca
Calcite | Level 5

Yes. Worked. Thank you Smiley Happy

art297
Opal | Level 21

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
Calcite | Level 5

You are so right, Art! My mistake!

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 5 replies
  • 36783 views
  • 0 likes
  • 3 in conversation