topic Re: Need help with SAS error in ODS and Base Reporting

Need help with SAS error

deleted_user — Mon, 29 Oct 2007 19:40:25 GMT

Is anyone familiar with this error?

ERROR: Connect:
ERROR: Error in the LIBNAME statement.
Connection Failed. See log for details.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.76 seconds
cpu time 0.32 seconds

Re: Need help with SAS error

deleted_user — Tue, 30 Oct 2007 12:16:20 GMT

Hi
Show your libname statement please.

Re: Need help with SAS error

Anitha_SAS — Tue, 30 Oct 2007 12:30:29 GMT

See SAS Note SN-020002
http://support.sas.com/kb/20/002.html

Re: Need help with SAS error

deleted_user — Tue, 30 Oct 2007 13:22:29 GMT

That's the thing. There is no libname statement. I am only importing a file.

PROC IMPORT OUT= WORK.austin
DATATABLE= "AUS XSLPTPM1"
DBMS=ACCESS REPLACE;
DATABASE="G:\VAC\Marketing\\PercentChangeLeadsBySource\Leads.mdb";
SCANMEMO=YES;
USEDATE=NO;
SCANTIME=YES;
RUN;

I have tried to import locally as well as from our server. I have not seen it act this way before.

Re: Need help with SAS error

deleted_user — Tue, 30 Oct 2007 13:29:56 GMT

This worked perfectly. Thanks so much for your help!