topic Re: Table Lookup Using Hash Tables in SAS Programming

Table Lookup Using Hash Tables

sasmaverick — Tue, 21 Jul 2015 11:21:35 GMT

I have the following two datasets:

LOOKUP DATASET:

Country_Code	Country_Name
BR	Brazil
GB	United Kingdom
KW	Kuwait
SA	Saudi Arabia
DE	Germany
ES	Spain

Main Dataset:

Country

I need to create a new variable in the main dataset based on the values found in the lookup dataset. The result should look as follows:

Country Country_Name_Full

BR Brazil

DE Germany

............

I am trying to use hash tables for this. Any help is appreciated. Thanks

Re: Table Lookup Using Hash Tables

RW9 — Tue, 21 Jul 2015 11:30:39 GMT

Hi,

Please use the search box on the main page, and type in Hash. There are over 30 very good examples which come up.

Re: Table Lookup Using Hash Tables

Ksharp — Tue, 21 Jul 2015 12:02:50 GMT

Code: Program.sas

data query;
infile cards truncover expandtabs;
input Country_Code $ Country_Name & $20.;
cards;
BR Brazil
GB United Kingdom
KW Kuwait
SA Saudi Arabia
DE Germany
ES Spain
;
run;
data Main;
input  Country $;
cards;
BR
BR
GB
KW
SA
DE
ES
ES
NO
US
US
;
run;
data want;
 if _n_ eq 1 then do;
  if 0 then set query;
  declare hash ha(dataset:'query');
  ha.definekey('Country_Code');
  ha.definedata('Country_Name');
  ha.definedone();
 end;
call missing(of _all_);
set Main;
rc=ha.find(key:Country );
drop rc Country_Code ;
run;

Re: Table Lookup Using Hash Tables

sasmaverick — Tue, 21 Jul 2015 12:27:59 GMT

Thanks a lot Xia, you are a savior!