topic Re: proc export error in SAS Procedures

proc export error

deleted_user — Sun, 17 May 2009 12:13:12 GMT

I am a new SAS user. I am trying to save a data file using the
following codes

PROC EXPORT DATA= d1
OUTFILE= "C:\UNIVAbyGindext1.xls";

I am receiving the following error and the file is not created:

ERROR: Connect:
ERROR: Error in the LIBNAME statement.
Connection Failed. See log for details.

I tried also

PROC EXPORT DATA= d1
DBMS = Excel2000
OUTFILE= "C:\UNIVAbyGindext1.xls" REPLACE;
but it didn't work

Any idea about the source of error?

Re: proc export error

sbb — Sun, 17 May 2009 12:54:06 GMT

Share more info about your SAS environment (local install or remote), version info, paste your "complete" SAS log with all source/macro logic code revealed, just prior to the error.

Scott Barry
SBBWorks, Inc.

Re: proc export error

deleted_user — Sun, 17 May 2009 12:58:01 GMT

am I printing the files or saving them on the c drive? sorry for this question

Re: proc export error

deleted_user — Sun, 17 May 2009 13:01:26 GMT

the program is really long and full with macros.

Re: proc export error

sbb — Sun, 17 May 2009 16:36:10 GMT

Without further details, you might consider adding the SAS statement below so you can self-diagnose the program as much as possible:

OPTIONS SOURCE SOURCE2 MACROGEN SYMBOLGEN MLOGIC;

Also, recommend reading up on the PROC EXPORT documentation and the purpose of the OUTFILE= parameter.

Scott Barry
SBBWorks, Inc.

Re: proc export error

Sticky — Tue, 19 May 2009 00:32:31 GMT

This error is caused by your printer driver. There is a hot fix for it, but a quick fix is to change your default printer to something other than an HP printer.
S

Re: proc export error

deleted_user — Mon, 29 Mar 2010 16:14:55 GMT

To be more specific, the following fix worked for me.

Options SYSPRINT='Microsoft Office Document Image Writer';

I do not print directly from SAS though.

Hope this helps
SM