Date: Sat, 23 Aug 2008 15:33:38 -0400
Reply-To: "Howard Schreier <hs AT dc-sug DOT org>"
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Howard Schreier <hs AT dc-sug DOT org>"
Subject: Re: Warning on reading records from excel file
On Fri, 22 Aug 2008 05:54:16 -0700, Manoj <mtamboli@GMAIL.COM> wrote:
>I am using the following code to read the number of records in an
>excel file. I do get the following warning message. Not sure as to
>what this means and how this can be avoided ????????
> proc sql noprint;
> select count(*) into :nobs1
> from book.'sheet1$'n;
>WARNING: The SCAN_TEXT option is ignored in the implicit pass-through
>WARNING: Use libname option DIRECT_SQL=NO to disable the implicit pass-
>through joins if you want the SCAN options on.
It means that SAS is asking Excel to evaluate the query. This may or may not
make a difference.
If you use the DIRECT_SQL=NO option it will go away.