topic Re: Proc SQL - Convert from Char to Num in SAS Programming

Proc SQL - Convert from Char to Num

KC_16 — Wed, 28 Feb 2018 15:55:40 GMT

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;

Re: Proc SQL - Convert from Char to Num

RW9 — Wed, 28 Feb 2018 16:00:32 GMT

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.

Re: Proc SQL - Convert from Char to Num

nkanney — Tue, 24 Jul 2018 21:46:37 GMT

What preposterously snobbish language.