Proc SQL - Convert from Char to Num

[KC_16]

Hi, 

How do I change my variable "Count" from a Char Variable to a Numeric Variable please?

proc sql;

create table work.steps as 

select

car_make,

car_type,

count

from work.car_overall;

quit; 

[RW9 · Accepted solution]

You use the input function, as you would in any other SAS instance (even though you seem to insist on using SQL, it is still SAS syntax - unless you pass through to a database which is the only place you have to use SQL and that would not use SAS specifics):

proc sql;
  create table work.steps as 
  select car_make,
         car_type,
         input(count,best.) as count
  from work.car_overall;
quit; 

Notice also how I use the code window and use formatting to make the code more readable.

[nkanney]

What preposterously snobbish language.