12-09-2015 05:58 AM
I've trouble understanding the defining keys and data in hashing. I read the document under
Still I couldn't understand. May I request someone to explain about defining keys and data in hashing in simple terms?
Thanks in advance for any help you offer me.
12-09-2015 08:47 AM
I am going through some training myself so there are most likely better sources but I will explain something as I understand it to join the conversation:
merge emphours (in=a)
length empid $6. empln $30. empfn $25. empmi $1. gender $1. startdate 8. emppaylevel $5.;
if _N_ = 1 then do;
declare hash new(dataset: 'employees',ordered: 'y');
rc = new.find();
format startdate mmddyy10.;
The two pieces of code produce the same results, definekey is the key in the hash table that I am generating and the field that I will be joining on. definedata() is the fields that I want to pull in. This is a simple merge, I am pulling fields from the employee dataset, joining to the emphours dataset. This is a very simple example for hash.
Hope I provided some help.