topic Re: Expression using IN has components that are of different data types… in SAS Programming

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

GiMaAsh — Thu, 08 Sep 2022 18:10:45 GMT

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;

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

PeterClemmensen — Thu, 08 Sep 2022 18:20:48 GMT

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

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

PaigeMiller — Thu, 08 Sep 2022 18:29:17 GMT

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

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

GiMaAsh — Thu, 08 Sep 2022 18:30:34 GMT

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

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

ballardw — Thu, 08 Sep 2022 18:31:23 GMT

@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.

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

GiMaAsh — Thu, 08 Sep 2022 19:00:35 GMT

Thank you for this! I finally got it