Hash Object Use Selected Key Only

[mariopellegrini]

Good morning.

In the guide sas (https://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a002576871.htm) is an example of how the option 'replace' stores the last duplicate key record, but it does not show how to record in the object hash values of duplicate key:

data table;
  input key data $;
  datalines;
  531 yellow
  620 green
  531 blue
  908 orange
  620 brown
  143 purple
 run;

data _null_;
length key 8 data $ 8;
if (_n_ = 1) then do;
    declare hash myhash(dataset: "table", duplicate: "r");
    rc = myhash.definekey('key');
    rc = myhash.definedata('data');
    myhash.definedone();
 end;

rc = myhash.output(dataset:"otable");
run;

I would get in the dataset 'table', the values of duplicate key. It's possible?

[mohamed_zaki]

Give example of your desired output....

[mariopellegrini]

a dataset identical to the original one (table), including duplicate data

[mohamed_zaki]

Then use the the option 

multidata="Y"

[mariopellegrini]

I've already tried, but I do not get duplicates:

data table;
  input key data $;
  datalines;
  531 yellow
  620 green
  531 blue
  908 orange
  620 brown
  143 purple
 run;

data _null_;
length key 8 data $ 8;
if (_n_ = 1) then do;
    declare hash myhash(dataset: "table",   multidata = 'Y');
    rc = myhash.definekey('key');
    rc = myhash.definedata('data');
    myhash.definedone();
 end;

rc = myhash.output(dataset:"otable");
run;

[mohamed_zaki · Accepted solution]

The hash object keeps the multiple values in a list that is associated with the key. This list can be traversed and manipulated by using several methods such as HAS_NEXT or FIND_NEXT.

See the first example in Better Hashing in SAS® 9.2

data _null_;
length key 8 data $ 8;
if (_n_ = 1) then do;
declare hash myhash(dataset: "table",multidata: "y");

rc = myhash.definekey('key');
rc = myhash.definedata('data');
myhash.definedone();
end;

do key = '531', '620', '908', '143';
rc = myhash.find();
if (rc = 0) then do;
put key= @15 data=;
myhash.has_next(result: r);
do while(r ne 0);
myhash.find_next();
put key= @15 data=  @25 '(dup)';
myhash.has_next(result: r);
end;
end;
end;
run;

[mariopellegrini]

This method is intricate, it is perhaps best to add the variable _N_ the key object to not have duplicates?

[data_null__]

multidata:'Y'

RTM

[Haikuo]

---

@data_null__ wrote:
multidata:'Y'

RTM

---

Wondering when SAS forum gonna fix this.

[data_null__]

I modified to make it CODE but that didn't fix it. 😞

[Haikuo]

It has been consistent :).