topic Re: HASH update all records in SAS Programming

HASH update all records

ger15xxhcker — Wed, 22 Jun 2022 07:17:41 GMT

Hi!

How can i update all columns in a table into hash join?

data master_table;
	set  master_table;
	if _n_ = 1 then
		do;
			declare hash a (dataset:"update_table");
			a.definekey('ID1','ID2');
			a.definedone();
		end;
	if a.check() = 0 then
		do;
			/*??*/
		end;	
run;

Thanks!

Re: HASH update all records

PeterClemmensen — Wed, 22 Jun 2022 07:46:28 GMT

Whar do you mean by update? And to what values?

Re: HASH update all records

ger15xxhcker — Wed, 22 Jun 2022 07:58:57 GMT

Where the 'update_table' table matches the 'master_table' key by key, overwrites all (non-key) fields with the field values in 'update_table'. (Both tables have the same fields.). Thanks!

Re: HASH update all records

PeterClemmensen — Wed, 22 Jun 2022 08:06:45 GMT

I can't see your data, so this code is untested. But I think this is what you want

data master_table;
   
   if _n_ = 1 then do;
      declare hash a (dataset:"update_table");
      a.definekey('ID1','ID2');
	  a.definedata(all : 'Y')
      a.definedone();
   end;
   
   set  master_table;
   
   if 0 then set update_table;
   
   rc = a.find(); 
   
run;

Re: HASH update all records

PeterClemmensen — Wed, 22 Jun 2022 10:54:28 GMT

Also, if both tables contain exactly the same variables, then the if 0 .. statement is obsolete.

Re: HASH update all records

ger15xxhcker — Wed, 22 Jun 2022 12:56:35 GMT

Thanks!