Reg Hash Technique to do Merging

[meenakshim]

Hi All,

     I am in the process of understanding Hash technique to perform dataset merge. I worked out simple examples, but it would be great if someone give me a equivalent hash code to perform below SAS merge.

There are non unique key fields and has OR condition in the where clause of SQL. 

How to implement this query using Hash?

Thanks for all your suggestions.

proc sql;
create table tablec as
Select distinct a.*
From tablea a join tableb b on ((a.ID =b.ID) or (a.ID=b.CURRENT_ID))
and (a.PROC_CODE =b.PROCEDURE_CODE)
and (a.START_DATE =b.from_date) and (a.END_DATE =b. END_DATE ) ;
quit;

[ChrisNZ]

For the duplicate keys and for the OR clause, you need to use the duplicate keyword, and to iterate.