DATA Step, Macro, Functions and more

Hash Programming

Reply
Occasional Contributor
Posts: 5

Hash Programming

Hi ,
Please can someone help me with an example for
Left , inner , full join in Hash Coding
I have very large datasets nearly 1 crore so need help .

Reagrds,
Satya.
Super User
Posts: 7,778

Re: Hash Programming

Posted in reply to msbrvamsi

define "crore".

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Super Contributor
Posts: 490

Re: Hash Programming

Posted in reply to KurtBremser

Ten million

Smiley Wink

Crore

Super Contributor
Posts: 490

Re: Hash Programming

Posted in reply to msbrvamsi
Occasional Contributor
Posts: 5

Re: Hash Programming

Posted in reply to msbrvamsi
Sorry it's 1 crore data please give some examples for all joins
Super Contributor
Posts: 490

Re: Hash Programming

Posted in reply to msbrvamsi

With such number you should keep in mind that, Larger data will require more memory and can impact overall system performance.

You may consider increase the HASHEXP value to maximize the efficiency of the hash object lookup. Read more here DECLARE Statement, Hash and Hash Iterator Objects . So increase it and see if you reach better performance.

Ask a Question
Discussion stats
  • 5 replies
  • 244 views
  • 0 likes
  • 3 in conversation