Date:         Mon, 4 Aug 2003 21:58:32 -0400
Reply-To:     "Richard A. DeVenezia" <radevenz@IX.NETCOM.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Richard A. DeVenezia" <radevenz@IX.NETCOM.COM>
Subject:      Re: Look Ahead Rows for PROC IMPORT

"Kevin Myers" <WHMyers@CABLEONE.NET> wrote in message
news:0f4301c35acf$87b6a550$67a8a8c0@speedy...
> Just found SAS note SN-006123 which appears to say that if you are in V8.x
> then you are stuck using REGEDIT to adjust a value for the MS Jet database
> engine to work around this problem.  Tried that, and it seems to work ok,
> but I hate editing the registry, because then you have to remember to do
> that on every machine where your software will be used.  Anyone know of a
> better way for SAS V8.x?  Thanks again,
>
> s/KAM

You might consider checking out my new SASCBTBL sample
http://www.devenezia.com/downloads/sas/sascbtbl/index.html#WindowsRegistry
You could make setting the registry value part of the 'sas process'

--
Richard A. DeVenezia

>
>
> ----- Original Message -----
> From: "Kevin Myers" <WHMyers@CABLEONE.NET>
> Newsgroups: bit.listserv.sas-l
> To: <SAS-L@LISTSERV.UGA.EDU>
> Sent: Monday, August 04, 2003 4:12 PM
> Subject: Look Ahead Rows for PROC IMPORT
>
>
> Howdy folks,
>
> I'm almost certain there is an option to control how many rows PROC IMPORT
> will read ahead in order to determine the type of a given column, when
> reading from an Excel file for example.  But I can't seem to track this
down
> in the docs. :-(  Can someone please help me out?  Thanks,
>
> s/KAM