Hi, I'm a little confused by the result of this query. At first I create two data sets with one common observation (value 2). Then I want to get this common observation from set a, but for some reason I get 3 as result. Can someone explain why is the code not working as I planned? data a; input x; cards; 1 2 3 ; run; data b; input x; cards; 2 4 ; run; proc sql; select * from a where x=(select * from a intersect select * from b); quit;
... View more