Error while using PROC EXPORT in SAS EG 7.1

[RAmarapuram]

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

[ChrisHemedinger]

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