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;
... View more
