This paper provides example of Hash merging using 2 keys....  Refer to page 5.    http://www2.sas.com/proceedings/forum2008/029-2008.pdf   Hope this helps... ... View more

Thanks for following up @jakarman Sorry if I was unclear.      I am trying to find out if there is a tool that can be used for deploying SAS code in a Unix environment, an equivalent of "Changeman" or "Endevor" that exists on a Mainframe environment.     Hope this helps...!!! ... View more

Appears a thread exists for probably what you are looking for...  https://communities.sas.com/t5/SAS-Procedures/HASH-join/m-p/112108#U112108 ... View more

Another option....   1) connect to your SQL database within your SAS program using the loginid & password defined in a LIBNAME statement  2) all the SQL tables can be read as SAS files and set using SET statements using the structure "libref.filename".      Alternatively, instead of step 2), you can also use a proc sql to create a SAS file from "CREATE TABLE " syntax reading the SQL Table.   Either one should bring you the data.  ... View more

Thanks for your detailed explanation.  This is exactly why,  I'm trying to find out the possible options available based on other SAS user experiences.  To me it appears like there is no straight forward tool that can be used for checking in a code to a production Unix environment requiring an approval authority. I hear of users using WINSCP and SVN but they have the copy step done manually which,  I'm trying to avoid.  Basically,  the code should be moved to production directories automatically upon approval.  Seems straight forward but haven't come across a tool that will accomplish this without added complexity.  ... View more

I failed to provide the link to the article I referred in my post earlier. ..here you go. ..   http://support.sas.com/kb/14/178.html ... View more