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
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 =3Bimport and proc export for=
either excel files or access files<BR> =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. =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? =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><=3B<A href=3D"mailto:esimuli@live.com">esimuli@li=
ve.com</A>>=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_--
