Hi, I am learning hash objects ,when I was working on the below scenario,it is giving as specified below.please clarify. I have two data sets ,I am assuming that one is bigger one and one is smaller one. the smaller data(data1) set consists of following data. connection_id credit_teamid the bigger one(master) data set consists of following data. Connection_id credit_teamid unit_desc group_code DATA Hash_sample(drop=search); length connection_id 10; length credit_team_id unit_desc group_code $20; if _n_=1 then do; declare hash first_HT(dataset:"master"); first_ht.definekey("connection_id","credit_team_id"); first_ht.definedata("unit_desc","group_code"); first_ht.definedone(); end; set data1; search=first_ht.find(); if search=0 then output; run; Here I'm getting the output like this Even though master data set consists of same connection id and credit team id's more than once,small data set is not merging with all the connection and credit team id's in the master data set. It is only merging with first occurance(first.) of the connection id and credit team id's of the master data set. Please clarify.
... View more