topic Re: interview question in SAS Procedures

interview question

rawindar — Wed, 11 Apr 2012 11:40:58 GMT

Hi all

I have two datasets.A and B as follows

A B

Eid Eid

1 3

2 4

3 5

I need o/p as follows

Eid

I dont want value 3 in o/p dataset.Can anybody help me to solve this.

Thanks & Regards

Rawindarreddy

Re: interview question

Haikuo — Wed, 11 Apr 2012 12:04:16 GMT

data a;

input v;

cards;

;

data b;

input v;

cards;

;

data want;

merge a(in=a) b(in=b);

by v;

if a and b then delete;

run;

Haikuo

Re: interview question

shivas — Wed, 11 Apr 2012 12:06:22 GMT

Hi ,

Try this..

data a;

input no;

cards;

;

run;

data b;

input no;

cards;

;

run;

data c;

merge a(in=a) b(in=b);

by no;

if a ne b ;

run;

Thanks,

Shiva

Re: interview question

Haikuo — Wed, 11 Apr 2012 12:18:13 GMT

Oops, just notice that OP asked in Proc section, so proc sql may be actually needed:

data a;

input v;

cards;

;

data b;

input v;

cards;

;

proc sql;

create table want as

select * from a

union corr

select * from b

except

(select * from a

intersect corr

select * from b);

quit;

Haikuo

Re: interview question

art297 — Wed, 11 Apr 2012 12:28:55 GMT

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.