My "xlsx" was intended to be the libname. I experimented with several libnames with the same result. No errors in the log, it appears to work fine, but the resulting Excel file will not open when using the pcfiles code. When I use the xlsx method, it also appears to work, but again I get unreadable content in the excel file. The message here is "Excel found unreadable content in <filename>. Do you want to recover the contents of this workbook?" If I click yes, it opens, but with unreadable content. If I try to use the method that worked fine in 9.3 (just using a libname statement without an "xlsx" or "pcfiles") it gives me a SAS error: ERROR: Connect: Class not registered ERROR: Error in the LIBNAME statement. I think I'm going to have to find a different method here. Could the issue be 64-bit SAS vs. 32-bit Office?
... View more