Greetings! I'm using SAS EG 5.1 with SAS 9.3. I've run into an issue and an error message/problem and I can't figure out a way to fix them. First, I'm trying to join 10 tables with a common variable across in each table. I've already taken out the variables I don't need, so I need all the remaining information from each table...and I've used a full outer join for the first two tables. I thought I should use outer joins for the remaining tables, but that doesn't seem to work. Do I have to add and join these one at a time, or can they all be added in one step? Since I'm keeping the information in all the tables, am I correct to choose a full outer join? Second, several small (3-4 table) "joins" have worked, so I know I've at least go the right idea. There are 3 relatively large files, however, that always result in an error message when I try to join them to any other files. The error message is: Error: insufficient space in file WORK.FILE.DATA. Error: File WORK.FILE.DATA is damaged. I/O processing did not complete. Here's the hot fix explanation that SAS help sent: In SAS ® OpRisk VaR, an internal coding problem can cause a utility file to grow very large when you use a large missing-range table. The larger the missing-range table is, the exponentially larger is the utility file. As a result, disk-space problems can occur, generating errors similar to the following: ERROR: Insufficient space in file WORK._TMP_LOSSES_M.DATA. ERROR: File WORK._TMP_LOSSES_M.DATA is damaged. I/O processing did not complete. ERROR: File WORK._TMP_LOSSES_M.DATA does not exist. ERROR 388-185: Expecting an arithmetic operator. ERROR 202-322: The option or parameter is not recognized and will be ignored. When I try to install it, however, my system says it is already up to date. Thanks in advance for any help you can provide. Charles
... View more