Joining tables in 7.5 SAS VA

[Janet5]

Does anyone know how to join tables in SAS VA 7.5?  I see that you can do this in SAS VA 8.5.  I have 2 separate data tables that I want to join.  Unfortunately, I tried this in SAS EG and it keeps saying the file is too big.  I have made smaller tables and uploaded them to SAS VA and I am hoping I can join them in there.  Thanks!  

[SASKiwi]

SAS VA isn't any different to 'normal' SAS when it comes to joining data. Please post your complete EG SAS log for the join you are trying.

[Janet5]

I am getting this error in SAS EG:
ERROR: Insufficient space in file WORK.QUERY_FOR_QUERY_FINAL_SERVICE_AR.DATA.
ERROR: File WORK.QUERY_FOR_QUERY_FINAL_SERVICE_AR.DATA is damaged. I/O processing did not complete.

If I break it into smaller queries in SAS EG it does it works. So with the smaller tables I wanted to join them in VA. Also, I have compressed it in SAS EG and it errors out.

[SASKiwi · Accepted solution]

@Janet5 - The errors you are getting suggest you are running out of SAS WORK disk space. If your EG uses a remote SAS server then you will need to talk to your SAS administrator about this. Also we need to see the source code of your query, not just the errors. If you aren't seeing the source code in your SAS log, run this statement first: options source;