11-28-2014 04:08 PM
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?
11-28-2014 09:22 PM
It does look wrong, and so do the results from
select x, (select x from a intersect select x from b) as y from a;
select x, (select x from b intersect select x from a) as y from a;
You should submit a "Problem Report" to SAS (link at the bottom of the page) .