ERROR: Error in the libname statement.PROC EXPORT issue

RAmarapuram — Fri, 27 Feb 2015 14:20:15 GMT

Hi All

I have gone through couple of blogs on the same error, I have tried all the suggested options and posting my issue.

#1. While trying to export xls file using DBMS=EXCEL option in the below code :

PROC EXPORT DATA= WORK.soma

OUTFILE= "C:\User\app-502396530\Documents\My SAS Files\test1.xls"

DBMS=EXCEL REPLACE;

SHEET="Historical INFO";

RUN;

ERROR:Connect: Class not registered

ERROR: Error in the libname statement.

If I use DBMS=EXCELCS, I get an error saying

ERROR: Failed to connect to server.

#2. While trying to export csv file using the below code, the code gets executed without errors and the log

says that file SUCCESSFULLY created, But I am unable to see the created file at the location(mentioned in the code):

PROC EXPORT DATA= WORK.segments_final

OUTFILE= "C:\User\app-502396530\Documents\My SAS Files\test1.csv"

DBMS=CSV REPLACE;

RUN;

Re: ERROR: Error in the libname statement.PROC EXPORT issue

ChrisHemedinger — Fri, 27 Feb 2015 14:40:58 GMT

To use EXCELCS you need to have the PC Files Server installed on your SAS for Windows server, or on another dedicated node. With SAS for Windows, installing the PC Files Server is easy and SAS can launch it via "autostart", no additional configuration required.

Chris