Date:         Fri, 22 Aug 2008 05:54:16 -0700
Reply-To:     Manoj <mtamboli@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Manoj <mtamboli@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Warning on reading records from excel file
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

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,