BookmarkSubscribeRSS Feed
deleted_user
Not applicable
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?
6 REPLIES 6
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
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
Not applicable
am I printing the files or saving them on the c drive? sorry for this question
deleted_user
Not applicable
the program is really long and full with macros.
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
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
Fluorite | Level 6
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
Not applicable
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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 6 replies
  • 959 views
  • 0 likes
  • 3 in conversation