Converting character variables to numeric

SIMMII — Fri, 01 Dec 2023 03:44:22 GMT

Hi,

I'm trying to do a proc glmselect with all the variable interactions. However, I have a log error message telling me that the y variable does not match the type prescribed in the list. I know that it is because my y variable is a character variable (it is binary) while all the Xs are numeric. What code exactly should I use to convert this y variable into a numeric variable?

Screenshot 1: The log message

Screenshot 2: The SAS code in question

The list of variables and their attributes for dataset "ps2renamed"

Thank you! (Btw, I'm SAS On Demand for Academics)

Re: Converting character variables to numeric

Patrick — Fri, 01 Dec 2023 04:17:58 GMT

Something along the line of below sample code should do

data work.ps2renamed;
  x41=1;
  y='Yes';
  output;
  Y='No';
  output;
run;

proc format;
  invalue yn_char2num(upcase)
    'Y','YES' = 1
    'N','NO'  = 0
    other =.
    ;
run;

data work.ps2renamed;
  set work.ps2renamed(rename=(y=y_char));
  y=input(y_char,yn_char2num.);
  drop y_char;
run;

proc print data=work.ps2renamed;
run;

topic Re: Converting character variables to numeric in New SAS User

Converting character variables to numeric

Re: Converting character variables to numeric