Date: Tue, 7 May 2002 21:04:02 -0400
Reply-To: FMAINVILLE <fmr@MAGMA.CA.NOSPAM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: FMAINVILLE <fmr@MAGMA.CA.NOSPAM>
Subject: Re: SAS ODBC Libname engine??
Assign the libref interactively, then issue the following
command immediately after connecting to the data source.
The connection string will be written to the SAS log.
"David Rubanowice" <rubanowice.d@GHC.ORG> wrote in message
> How about
> libname guexcel odbc dsn="Guatmala Excel";
> >>> "Delaney, Kevin P." <khd8@CDC.GOV> 05/07/02 08:08AM >>>
> I think I am close, but this doesn't quite work:
> libname guexcel odbc noprompt="DSN=Guatmala Excel;DRIVER=Microsoft Excel
> Driver(*.xls); DBQ=C:\khd8\Test Export to excel\ABRIL 5 RESULTADOS.xls;";
> You would think Windoze and SAS could work together so that once you
> assigned the DSN that would be all SAS would need, but I guess not...
> Interactively (with the "New Library" tool) I can assign this, but I want
> put it in my code!!
> Normally, I would RTFM, but I can't find the ODBC Libname engine
> Win2k and V.8.2, if it matters...
> Kevin Delaney