Hello, Everyone, I have been told great things about the SAS Hash Join and am trying to implement it in a project with a very large dataset (WORK.MASTER) that I would like to join to a smaller dataset (WORK.HASH_CLASS).  I can get the code to execute and join a table; however, SAS is joining ALL columns of the second table to my master table, even though I only desire and specify one.  Please refer to my code as follows: My goal is to simply add the "CLASS_REMAPPED" field from the WORK.HASH_CLASS table to the WORK.MASTER table; however, SAS proceeds to join *all* fields from WORK.HASH_CLASS to WORK.MASTER, even though I only specified "CLASS_REMAPPED" in the .defineData property.  Can anyone see what I'm doing wrong? Thanks! ... View more

Hello, I have a stored process that creates a number of datasets in the WORK library.  I would like the user to be able to navigate through WORK to see the results of each step of the program.  Once they close the SAS session, the WORK directory will be cleared as it normally does.  My problem is that the SAS Stored Process appears to be killing the contents of WORK before the user even has a chance to look at it.  Is there a way to prevent SAS from killing the WORK library contents? Thanks! ... View more