Expression using IN has components that are of different data types…

[GiMaAsh]

This used to work fine and now I keep getting the Expression using IN has components that are of different data types. I ran proc contents and confirmed Overall Rating and Begin date are both numeric. Not sure why I’m getting this error.

Proc sql;
Select Owner_name, count(distinct(varnum)) as number_low
From sheet1
Where Begin_date > input(‘10/28/2018’, mmddyy10.) and Overall_rating IN (‘1’, ‘2’, ‘’)
Group by owner_Name;

[PeterClemmensen · Accepted solution]

If Overall_Rating is numeric then you have your answer since '1' and '2' are character literals?

proc sql;
   select * from sashelp.class
   where age in ('14', '15')
   ;
quit;

Log:

28         proc sql;
29            select * from sashelp.class
30            where age in ('14', '15')
31            ;
ERROR: Expression using IN has components that are of different data types.
NOTE: The IN referred to may have been transformed from an OR to an IN at some point during PROC SQL WHERE clause optimization.
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
32         quit;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds

[GiMaAsh]

So how would I just pull 0, 1, or 2 so it can be numeric?

[GiMaAsh]

Thank you for this! I finally got it

[PaigeMiller]

Show us the ENTIRE log for this PROC SQL. Showing us an error detached from the code doesn't usually help.

[ballardw]

---

@PaigeMiller wrote:

Show us the ENTIRE log for this PROC SQL. Showing us an error detached from the code doesn't usually help.

---

Any bets that this new data was created with Proc Import and the result is one or more of the variables changing type.