topic Re: Joining tables in 7.5 SAS VA in SAS Visual Analytics

Joining tables in 7.5 SAS VA

Janet5 — Fri, 15 Jan 2021 21:46:18 GMT

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!

Re: Joining tables in 7.5 SAS VA

SASKiwi — Fri, 15 Jan 2021 22:05:05 GMT

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.

Re: Joining tables in 7.5 SAS VA

Janet5 — Fri, 15 Jan 2021 22:14:08 GMT

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.

Re: Joining tables in 7.5 SAS VA

SASKiwi — Sat, 16 Jan 2021 01:48:40 GMT

@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;