proc export error

[deleted_user]

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?

[sbb]

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.

[deleted_user]

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

[deleted_user]

the program is really long and full with macros.

[sbb]

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.

[Sticky]

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

[deleted_user]

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