Hello,
I've been checking up on hash tables and what they could do for me, but even this basic test doesn't work out as expected:
data Hash_TEST;
set TEST_POPULATION point = _n_;
declare hash hh (dataset: 'work.TESTPOPULATIE', hashexp: 10);
hh.DefineKey ('KEYFIELD');
hh.DefineData ('KEYFIELD', 'SECONDFIELD');
hh.DefineDone ();
do until (eof1);
set COMPTABLE end = eof1;
if hh.find() = 0 then output;
end;
stop;
run;
This code results in the matching records, but in stead of only reporting the fields mentioned in "DefineData" I get all of the fields in the TEST_POPULATION table.
What could be a logical explanation for this?
(Could be something very basic, as I only recently found out about these)