Desktop productivity for business analysts and programmers

Error while using PROC EXPORT in SAS EG 7.1

Reply
Contributor
Posts: 27

Error while using PROC EXPORT in SAS EG 7.1

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

Community Manager
Posts: 2,697

Re: Error while using PROC EXPORT in SAS EG 7.1

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

Ask a Question
Discussion stats
  • 1 reply
  • 1737 views
  • 1 like
  • 2 in conversation