Hi All
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"
DBMS=EXCEL REPLACE;
SHEET="Historical INFO";
RUN;
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"
DBMS=CSV REPLACE;
RUN;
The above code executed successfully, but I am unable to see the file in the above path.
Kindly help me in resolving the issue.
Thanks
Rajesh
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.
http://blogs.sas.com/content/sasdummy/2012/05/01/64-bit-gotchas/
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.
Chris
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.