02-27-2015 08:11 AM
We have recently migrated from SAS EG 4.1 to 7.1. We were testing the PROC EXPORT on the new system and unable to create XLS or CSV files.
#1. Code to export Excel:
PROC EXPORT DATA= WORK.soma
OUTFILE= "C:\User\app-502396530\Documents\My SAS Files\test1.xls"
After executing the above code, I got the below error :
Error: CONNECT: Class not registered.
Error: Error in the LIBNAME statement.
#2. Code to export CSV
PROC EXPORT DATA= WORK.segments_final
OUTFILE= "C:\User\app-502396530\Documents\My SAS Files\test1.csv"
The above code executed successfully, but I am unable to see the file in the above path.
Kindly help me in resolving the issue.
02-27-2015 09:30 AM
I'm guessing that you also moved from 32-bit SAS 9.1 to 64-bit SAS 9.4 on Windows. That explains the Excel error -- you may need to use DBMS=EXCELCS or (better) DBMS=XLSX instead.
For the second problem: is the SAS session running on your local machine, or is it a remote Windows machine? If remote, then the "C:" reference is the C: drive on the remote machine, not your local machine. You might need to select a network location to output your files, or else use something like the Copy Files task to download the result.