topic Re: How to pass more than 2 Macro Variables as KEY to Hash Object in SAS Programming

How to pass more than 2 Macro Variables as KEY to Hash Object

KachiM — Tue, 29 Sep 2015 15:42:54 GMT

I want to pass two or more macro variables as Key to a hash object.

%let KEY = Name Account_Number;

data _null_;

if _n_ = 1 then do;

if 0 then set Some_Data_Set;

declare hash h();

h.definekey("&KEY");

h.definedata("&KEY");

h.definedone();

end;

run;

The following is the error.

ERROR: Undeclared key symbol name account_number for hash object at line 2158 column 7

Re: How to pass more than 2 Macro Variables as KEY to Hash Object

Astounding — Tue, 29 Sep 2015 16:25:49 GMT

In this case, it would be appropriate for you to do the first half of the work. Show us what the final program would look like if you were not using macro language, but just hard-coding the whole thing.

Re: How to pass more than 2 Macro Variables as KEY to Hash Object

michelle_delaurentis_sas_com — Tue, 29 Sep 2015 21:07:34 GMT

I believe the issue here is syntax. Try setting your macro variable like this:

%let KEY = Name", "Account_Number;

definekey and definedata are expecting each key and data variable to be surrounded by quotes and separated by a comma.

Re: How to pass more than 2 Macro Variables as KEY to Hash Object

ChrisNZ — Tue, 29 Sep 2015 22:11:44 GMT

%let keys = 'Name', 'Account_Number';
data _null_;
  if _n_ = 1 then do;
    if 0 then set Some_Data_Set;
    declare hash h();
    h.definekey(&keys.);
    h.definedata(&keys.);
    h.definedone();
  end;
run;

would be the clean way to pass those values imho.

Re: How to pass more than 2 Macro Variables as KEY to Hash Object

KachiM — Tue, 29 Sep 2015 22:30:26 GMT

Michelle:

Your solution works. Thank you.

ChrisNZ:

Your solution works too. Thanks.

I found that the KEY has also to be used in KEEP= SET option. I wanted to use in "data out(keep = &KEY);" . Both your suggestions will

not directly work. I found it convenient to split the KEY into two:

%let key1 = name;

%let key2 = account_number;

then I used

h.definekey("&key1", "&key2");

Re: How to pass more than 2 Macro Variables as KEY to Hash Object

michelle_delaurentis_sas_com — Wed, 30 Sep 2015 17:40:23 GMT

I completely agree with ChrisNZ, much cleaner.

One additional point...you can use call missing for any variables that are defined as data in the hash if they do not exist anywhere else in the data step, to avoid the warning you get in the log for undefined variables.

Re: How to pass more than 2 Macro Variables as KEY to Hash Object

Tom — Wed, 30 Sep 2015 19:00:35 GMT

Personally I have a utility macro that I use for things like this.

%let KEY = Name Account_Number;
%put %qlist(&key);
('Name','Account_Number')


 h.definekey%qlist(&KEY);