topic Re: Reg:doing by Hash Keys in SAS Programming

Reg:doing by Hash Keys

sas_Forum — Fri, 30 Dec 2011 11:05:47 GMT

Hi in table table1 and table2 i want to create table l3 from table1 and table2 tables based on table2.id2 =table.id
i want to do it on hash keys

data table1;
input id id2;
cards;
1 2
2 3
3 4
4 5
run;

data table2;
input id id2;
cards;
2 3
run;

output
id id2
3 4

Re: Reg:doing by Hash Keys

sas_Forum — Fri, 30 Dec 2011 11:08:13 GMT

I can do same in joins

proc sql;
create table l3 as select a.id,a.id2 from table1 as a right join table2 as b
on a.id=b.id2;
quit;
proc print;run;

Re: Reg:doing by Hash Keys

Ksharp — Sat, 31 Dec 2011 02:31:31 GMT

OK. Easy.

Assuming your id2 in table2 has no replicated value.

data table1;
input id id2;
cards;
1 2
2 3
3 4
4 5
;
run;

data table2;
input id id2;
cards;
2 3
;
run;

data want;
 if _n_ eq 1 then do;
  if 0 then set table2;
  declare hash ha(dataset:'table2', hashexp:10);
   ha.definekey('id2');
   ha.definedone();
 end;
 set table1;
  if ha.check(key:id)=0 then output;
run;

Ksharp

Re: Reg:doing by Hash Keys

sas_Forum — Mon, 02 Jan 2012 07:33:14 GMT

Thqs Ksharp i know you will Reply