topic Re: Hash Object Use Selected Key Only in SAS Programming

Hash Object Use Selected Key Only

mariopellegrini — Mon, 07 Dec 2015 09:36:55 GMT

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?

Re: Hash Object Use Selected Key Only

mohamed_zaki — Mon, 07 Dec 2015 11:40:06 GMT

Give example of your desired output....

Re: Hash Object Use Selected Key Only

mariopellegrini — Mon, 07 Dec 2015 12:10:51 GMT

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

Re: Hash Object Use Selected Key Only

mohamed_zaki — Mon, 07 Dec 2015 12:15:28 GMT

Then use the the option

multidata="Y"

Re: Hash Object Use Selected Key Only

mariopellegrini — Mon, 07 Dec 2015 12:18:12 GMT

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;

Re: Hash Object Use Selected Key Only

mohamed_zaki — Mon, 07 Dec 2015 13:53:02 GMT

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;

Re: Hash Object Use Selected Key Only

data_null__ — Mon, 07 Dec 2015 18:35:00 GMT

multidata&colon;'Y'

RTM

Re: Hash Object Use Selected Key Only

Haikuo — Mon, 07 Dec 2015 17:10:26 GMT

@data_null__ wrote:
multidata&colon;'Y'

RTM

Wondering when SAS forum gonna fix this.

Re: Hash Object Use Selected Key Only

data_null__ — Mon, 07 Dec 2015 18:35:52 GMT

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

Re: Hash Object Use Selected Key Only

Haikuo — Mon, 07 Dec 2015 18:39:33 GMT

It has been consistent :).

Re: Hash Object Use Selected Key Only

mariopellegrini — Mon, 07 Dec 2015 19:56:59 GMT

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