Date:         Sat, 23 Aug 2008 15:33:38 -0400
Reply-To:     "Howard Schreier <hs AT dc-sug DOT org>"
              <schreier.junk.mail@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Howard Schreier <hs AT dc-sug DOT org>"
              <schreier.junk.mail@GMAIL.COM>
Subject:      Re: Warning on reading records from excel file

On Fri, 22 Aug 2008 05:54:16 -0700, Manoj <mtamboli@GMAIL.COM> wrote:

>Hi,
>
>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;
>  quit;
>
>WARNING: The SCAN_TEXT option is ignored in the implicit pass-through
>joins.
>WARNING: Use libname option DIRECT_SQL=NO to disable the implicit pass-
>through joins if you want the SCAN options on.
>
>
>Thank you,

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.

See http://www.sascommunity.org/wiki/Be_Aware_of_Implicit_Pass-Through