LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (October 2009, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Thu, 1 Oct 2009 15:07:06 +0000
Reply-To:     evallyne sikuku <esimuli@LIVE.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         evallyne sikuku <esimuli@LIVE.COM>
Subject:      Re: ERROR: Connect: Error in Libname statement
Comments: To: snoopy369@gmail.com
In-Reply-To:  <b7a7fa630910010758u4c3bb5b7l676166fca6185fc5@mail.gmail.com>
Content-Type: multipart/alternative;

<b7a7fa630910010758u4c3bb5b7l676166fca6185fc5@mail.gmail.com> MIME-Version: 1.0

--_8f2c2292-f755-42e5-92cb-419ca7707736_ Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable

The error occurs when am running the proc import and proc export for either= excel files or access files =20

Date: Thu=2C 1 Oct 2009 09:58:54 -0500 Subject: Re: ERROR: Connect: Error in Libname statement From: snoopy369@gmail.com To: esimuli@live.com CC: SAS-L@listserv.uga.edu

I'd not be able to tell without seeing the excel file=2C so you should look= at that.

First off=2C you don't need the $ in the sheet name. Don't know if that do= es any harm=2C but it's not necessary in PROC IMPORT=2C only in straight up= libname.

Second=2C you might try doing a straight up libname=2C see if it works bett= er=2C or gives you a more useful error:

libname myfile excel "C:\Documents and Settings\Administrator\My Documents\= ESIKUKU\Mwangalizi\Mwangalizi_list.xls"=3B

data test=3B set myfile."children$"=3B run=3B

Where does the error occur - in the libname=2C or in the data step? Or nei= ther?

-Joe

On Thu=2C Oct 1=2C 2009 at 9:52 AM=2C evallyne sikuku <esimuli@live.com> wr= ote:

Hi SAS friends=2C

I am having trouble doing imports and exports using SAS with a SAS code tha= t had been working well.

sample of code

PROC IMPORT OUT=3D WORK.CHILDREN

DATAFILE=3D "C:\Documents and Settings\Administrator\My Docume

nts\ESIKUKU\Mwangalizi\Mwangalizi_list.xls"

DBMS=3DEXCEL REPLACE=3B

SHEET=3D"children$"=3B

GETNAMES=3DYES=3B

MIXED=3DNO=3B

SCANTEXT=3DYES=3B

USEDATE=3DYES=3B

SCANTIME=3DYES=3B

RUN=3B

it gives me this error

ERROR: Connect:

ERROR: Error in Libname statement

Am unsure what the problem could be.

Thanks in advance for your help.

Eva

_________________________________________________________________ Show them the way! Add maps and directions to your party invites. http://www.microsoft.com/windows/windowslive/products/events.aspx =0A= _________________________________________________________________=0A= Windows Live=99: Keep your life in sync. Check it out!=0A= http://windowslive.com/explore?ocid=3DTXT_TAGLM_WL_t1_allup_explore_012009=

--_8f2c2292-f755-42e5-92cb-419ca7707736_ Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable

<html> <head> <style><!-- .hmmessage P { margin:0px=3B padding:0px } body.hmmessage { font-size: 10pt=3B font-family:Verdana } --></style> </head> <body class=3D'hmmessage'> The error occurs when am running the proc&nbsp=3Bimport and proc export for= either excel files or access files<BR>&nbsp=3B<BR> <HR id=3DstopSpelling> Date: Thu=2C 1 Oct 2009 09:58:54 -0500<BR>Subject: Re: ERROR: Connect: Erro= r in Libname statement<BR>From: snoopy369@gmail.com<BR>To: esimuli@live.com= <BR>CC: SAS-L@listserv.uga.edu<BR><BR>I'd not be able to tell without seein= g the excel file=2C so you should look at that.<BR><BR>First off=2C you don= 't need the $ in the sheet name.&nbsp=3B Don't know if that does any harm= =2C but it's not necessary in PROC IMPORT=2C only in straight up libname.<B= R><BR>Second=2C you might try doing a straight up libname=2C see if it work= s better=2C or gives you a more useful error:<BR><BR>libname myfile excel "= C:\Documents and Settings\Administrator\My Documents\ESIKUKU\Mwangalizi\Mwa= ngalizi_list.xls"=3B<BR><BR>data test=3B<BR>set myfile."children$"=3B<BR>ru= n=3B<BR><BR>Where does the error occur - in the libname=2C or in the data s= tep?&nbsp=3B Or neither?<BR><BR>-Joe<BR><BR> <DIV class=3Decxgmail_quote>On Thu=2C Oct 1=2C 2009 at 9:52 AM=2C evallyne = sikuku <SPAN dir=3Dltr>&lt=3B<A href=3D"mailto:esimuli@live.com">esimuli@li= ve.com</A>&gt=3B</SPAN> wrote:<BR> <BLOCKQUOTE class=3Decxgmail_quote style=3D"PADDING-LEFT: 1ex">Hi SAS frien= ds=2C<BR><BR>I am having trouble doing imports and exports using SAS with a= SAS code that had been working well.<BR><BR><BR><BR>sample of code<BR><BR>= <BR><BR>PROC IMPORT OUT=3D WORK.CHILDREN<BR><BR>DATAFILE=3D "C:\Documents a= nd Settings\Administrator\My Docume<BR><BR>nts\ESIKUKU\Mwangalizi\Mwangaliz= i_list.xls"<BR><BR>DBMS=3DEXCEL REPLACE=3B<BR><BR>SHEET=3D"children$"=3B<BR= ><BR>GETNAMES=3DYES=3B<BR><BR>MIXED=3DNO=3B<BR><BR>SCANTEXT=3DYES=3B<BR><BR= >USEDATE=3DYES=3B<BR><BR>SCANTIME=3DYES=3B<BR><BR>RUN=3B<BR><BR><BR><BR>it = gives me this error<BR><BR>ERROR: Connect:<BR><BR>ERROR: Error in Libname s= tatement<BR><BR><BR><BR><BR><BR>Am unsure what the problem could be.<BR><BR= >Thanks in advance for your help.<BR><BR>Eva<BR><BR><BR><BR>_______________= __________________________________________________<BR>Show them the way! Ad= d maps and directions to your party invites.<BR><A href=3D"http://www.micro= soft.com/windows/windowslive/products/events.aspx">http://www.microsoft.com= /windows/windowslive/products/events.aspx</A></BLOCKQUOTE></DIV><BR> = <br /><hr />Windows Live=99: Keep your life in sync. <a href=3D'http:/= /windowslive.com/explore?ocid=3DTXT_TAGLM_WL_t1_allup_explore_012009' targe= t=3D'_new'>Check it out!</a></body> </html>=

--_8f2c2292-f755-42e5-92cb-419ca7707736_--


Back to: Top of message | Previous page | Main SAS-L page