Hash Table adds all values in table in stead of only the defined ones

RFLinnenbank — Tue, 01 Mar 2011 10:18:12 GMT

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)

Re: Hash Table adds all values in table in stead of only the defined ones

Ksharp — Wed, 02 Mar 2011 05:39:34 GMT

Hi.
You need change ' set TEST_POPULATION point = _n_;' into
[pre]
if _n_ = 0 then set work.TESTPOPULATIE';
[/pre]

to let SAS know what type variable in the hash table.

Ksharp

topic Hash Table adds all values in table in stead of only the defined ones in SAS Procedures

Hash Table adds all values in table in stead of only the defined ones

Re: Hash Table adds all values in table in stead of only the defined ones