Reg Hash Technique to do Merging

meenakshim — Wed, 07 Apr 2021 00:59:43 GMT

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;

Re: Reg Hash Technique to do Merging

ChrisNZ — Wed, 07 Apr 2021 02:09:16 GMT

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

topic Reg Hash Technique to do Merging in SAS Programming

Reg Hash Technique to do Merging

Re: Reg Hash Technique to do Merging