topic Where clause requires a compatible variable. in SAS Programming

Where clause requires a compatible variable.

GN0001 — Sat, 26 Mar 2022 03:02:44 GMT

Hello team,

data mydata (keep = plan id  orderenddate year month);
set mydata1;
year = year(orderenddate);
month = month(oorderenddate);
run;

/*Year and months are not in dataset, I added them for the functions that I have use*/

data mydata2;
set mydata1;
where year =2022;
run;

where year = 2022 give errors. orderenddate is numeric data type which is formatted as a date in dataset: 2022-03-13.

How can I overcome this error?

Regards,

b&b

Re: Where clause requires a compatible variable.

SASKiwi — Sat, 26 Mar 2022 04:29:19 GMT

Read the dataset you added them to:

data mydata2;
set mydata; * You created them in mydata not mydata1;
where year =2022;
run;

Re: Where clause requires a compatible variable.

ballardw — Sat, 26 Mar 2022 05:21:36 GMT

I believe we have asked that when there are errors to copy the log with procedure or data step code and all of the note, warnings and errors; open a text box on the forum using the </> icon and paste the text with all of that.

Don't make us guess what the error is or where it occurs.

You may also want to run proc contents on your data set and show us the results.

Re: Where clause requires a compatible variable.

BrahmanandaRao — Sat, 26 Mar 2022 06:23:51 GMT

Use IF statement it converts any data type num to char and char to num this is the one difference between

IF & Where

where can not convert char to numeric

Re: Where clause requires a compatible variable.

ballardw — Sat, 26 Mar 2022 08:10:23 GMT

@BrahmanandaRao wrote:

Use IF statement it converts any data type num to char and char to num this is the one difference between

IF & Where

where can not convert char to numeric

But you can put functions in Where statements such as

where year(somedatevariable)= 2022;

Unless that "year" variable is to be used for something else it is not even needed.

Many times when you need a "year" variable it may be quite possible that applying the YEAR format to a date variable will suffice.