topic Help with column type change in SAS Programming

Help with column type change

kajal_30 — Fri, 12 Jun 2020 04:02:23 GMT

I have column cust has character type and I want to change the type to numeric of the same variable.

data one;

set wes;

cust = input ( cust,best8.) ;

run;

But still, in the output, I am seeing the type of cust as a character which I am expecting to be numeric.

SASKiwi — Fri, 12 Jun 2020 04:19:51 GMT

To change column type you have to assign it to a different column:\

data one;
set wes (rename = (cust = cust_char));
 cust = input ( cust_char, best8.) ;
run;

ChrisNZ — Fri, 12 Jun 2020 06:40:26 GMT

Or even:

data one (drop = CUST_CHAR);
  set WES (rename = (CUST = CUST_CHAR) );
  CUST = input ( CUST_CHAR, best8.) ;
run;

ChrisNZ — Fri, 12 Jun 2020 06:41:56 GMT

> But still, in the output, I am seeing the type of cust as a character which I am expecting to be numeric.

Look at the log. Look at the log. Look at the log. Look at the log. Look at the log.

Always look at the log. Even if there are (you think) no errors.