DATA Step, Macro, Functions and more

Proc SQL - Convert from Char to Num

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 18
Accepted Solution

Proc SQL - Convert from Char to Num

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; 


Accepted Solutions
Solution
‎02-28-2018 11:04 AM
Super User
Super User
Posts: 9,441

Re: Proc SQL - Convert from Char to Num

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.

View solution in original post


All Replies
Solution
‎02-28-2018 11:04 AM
Super User
Super User
Posts: 9,441

Re: Proc SQL - Convert from Char to Num

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.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 440 views
  • 0 likes
  • 2 in conversation