Date:         Thu, 3 Aug 2006 05:34:11 -0400
Reply-To:     Hari Prasadh <excel_hari@YAHOO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Hari Prasadh <excel_hari@YAHOO.COM>
Subject:      Re: Excel Import - Connect error

On Wed, 2 Aug 2006 08:35:20 -0400, Sarah Gollin <SarahGollin@HBOSPLC.COM>
wrote:

>Hi India,
>
>We had a similar problem where some computers would not proc import or
proc
>export.  It turned out to be related to some of the other software
>installed on the computer.  The people at SAS sent us this link.
>http://support.sas.com/techsup/unotes/SN/005/005898.html
>

Thanks I will try this solution.

regards,
HP
India

>Bear in mind it might not be the same problem, but I just thought I'd let
>you know!  It might be worth giving SAS a call if you're still having
>problems with this before reinstalling everything!!!
>
>Sarah
>
>14   proc import datafile="C:\Documents and
>Settings\mashru\Desktop\Projected Commodity
>14 ! Spend.xls"
>
>15
>16        out=sasuser.accounts;
>17
>18        sheet='Projected Spend';
>19
>20        getnames=no;
>21   run;
>
>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.15 seconds
>      cpu time            0.09 seconds