Hi everybody, I'm pretty new to SAS, studying Proc Sql stuff right now. I have came up with the code below, proc sql; select customer_firstname, customer_lastname from orion.customer_dim where 'F' in (select gender from orion.customer); quit; Why would this return every result within the customer_dim table regardless of 'M' or 'F'? I understand that an equal sign can't be used, since the subquery returns multiple results. I also understand that I could write a 'WHERE gender = 'F'' within the subquery, but why will this not work? I'm really looking for an explanation as to why the logic fails here, is it because a 'F' character constant cannot be used with the operator 'In'? I know that you can use character constant with comparison operator like the "=" sign. Thanks!!
... View more