Error while using PROC EXPORT in SAS EG 7.1

RAmarapuram — Fri, 27 Feb 2015 13:11:22 GMT

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

Re: Error while using PROC EXPORT in SAS EG 7.1

ChrisHemedinger — Fri, 27 Feb 2015 14:30:43 GMT

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

topic Re: Error while using PROC EXPORT in SAS EG 7.1 in SAS Enterprise Guide

Error while using PROC EXPORT in SAS EG 7.1

Re: Error while using PROC EXPORT in SAS EG 7.1