04-11-2012 07:40 AM
I have two datasets.A and B as follows
I need o/p as follows
I dont want value 3 in o/p dataset.Can anybody help me to solve this.
Thanks & Regards
04-11-2012 08:18 AM
Oops, just notice that OP asked in Proc section, so proc sql may be actually needed:
create table want as
select * from a
select * from b
(select * from a
select * from b);
04-11-2012 08:28 AM
Since the subject was interview question, I would think that multiple answers would be preferred. Thus, I would definitely include interleaving (see, e.g., http://www.sascommunity.org/wiki/Tips:Interleaving ).
Plus, it was never mentioned why 3 wasn't wanted, just that it wasn't wanted and not necessarily just because it was in both datasets. If it was just because its value was three, I would use an if EID ne 3 statement in the code.