How to write the code if I would like to get the same result by using 'merge' function?

[Alexxxxxxx]

Hi,

I am running code like below,

PROC SQL;
	CREATE TABLE want.C  AS
	SELECT DISTINCT
	*
	FROM
	have.A as A
	JOIN have.B AS B ON A.family_id=B.family_id
	;
QUIT;

my question is: How to write the code if I would like to get the same result by using 'merge' function?

I try to use 

data want.C;
	merge have.A 
	have.B;
	by family_id;
run;

But I did not get the same result. could you please give me some suggestions about this?

Thanks in advance.

[PeterClemmensen]

Try this

data want.C;
	merge have.A (in=a)
	have.B (in=b);
	by family_id;
	if a and b;
run;

[Kurt_Bremser]

The data step MERGE cannot mimic the SQL join if there is a many-to-many relationship.

[Alexxxxxxx]

Thanks for your reply. but what should I do? the result of SQL is 'Error: Sort execution failure.' Could you please give me some suggestions about this?

[Kurt_Bremser]

---

@Alexxxxxxx wrote:
Thanks for your reply. but what should I do? the result of SQL is 'Error: Sort execution failure.' Could you please give me some suggestions about this?

---

See your other thread about this.

[Ksharp]

Try FULL JOIN .
Better post sample data ,and can test the code .