topic Re: ERROR: WHERE clause operator requires compatible variables. in SAS Programming

ERROR: WHERE clause operator requires compatible variables.

radha009 — Thu, 03 Oct 2019 15:52:15 GMT

i have in my data , weekno, day , name , email and type, i am trying to get if monday (2) get the row. I couldn;t find the weekname function, so i added weekday function to get the weekday number.

&weekday. = 5

data sh.ext_supp;
set sh.ext_support;
where weekno = "&weekday";
run;

data sh.ext_supp;
476 set sh.ext_support;
477 weekday = put(weekday,12.3);
478 where weekday = "&weekday";
ERROR: WHERE clause operator requires compatible variables.
479 run;

NOTE: Character values have been converted to numeric values at the places given by:
(Line):(Column).
477:11
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set SH.EXT_SUPP may be incomplete. When this step was stopped there were 0
observations and 6 variables.

Re: ERROR: WHERE clause operator requires compatible variables.

Tom — Thu, 03 Oct 2019 15:56:01 GMT

So is WEEKDAY a numeric variable

where weekday=5;

or a character variable?

where weekday="5";

I do not see any WEEKDAY() function being used in the code you posted.

Re: ERROR: WHERE clause operator requires compatible variables.

Kurt_Bremser — Thu, 03 Oct 2019 15:58:57 GMT

A where condition works only on values present in the incoming data, not on values calculated in the step.

Since the weekday variable is numeric, you must compare it to a numeric value:

where weekno = &weekday.;

Since the type of a variable cannot be changed, this statement does not make sense:

weekday = put(weekday,12.3);