Help using Base SAS procedures

proc export error

Reply
N/A
Posts: 0

proc export error

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?
Super Contributor
Super Contributor
Posts: 3,174

Re: proc export error

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.
N/A
Posts: 0

Re: proc export error

am I printing the files or saving them on the c drive? sorry for this question
N/A
Posts: 0

Re: proc export error

the program is really long and full with macros.
Super Contributor
Super Contributor
Posts: 3,174

Re: proc export error

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.
Contributor
Posts: 34

Re: proc export error

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
N/A
Posts: 0

Re: proc export error

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
Ask a Question
Discussion stats
  • 6 replies
  • 311 views
  • 0 likes
  • 3 in conversation