Date:         Wed, 3 Apr 1996 09:32:48 EST
Reply-To:     Michele Marini <MARINI@VTVM1.CC.VT.EDU>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         Michele Marini <MARINI@VTVM1.CC.VT.EDU>
Subject:      DDE, Excel, and limits on size

Thanks to those folks who responded to my question about importing an EXCEL
spreadsheet into SAS via DDE and my concerns about file size.  Thanks to
Joe Whitehurst, Rodger Karl, Jim Carter and Dean Bross.
 
The answer to my question is as follows:  if you want to infile an Excel
spreadsheet directly into SAS by way of DDE, there is a 256 byte limitation
coming into SAS.  That can be modified by including an LRECL statement in your
infile command so as to increase the size of the file that will be read.  I was
able to read in 230 columns from excel, and some of those columns contained
large values, by adjusting my LRECL size up to 3000.
 
Thanks again for the assistance.
 
*************************************************************************
                           Michele Marini
                           Statistics Department
                           Virginia Tech
                           (703) 231-8315
                           email:marini@vtvm1.cc.vt.edu
*************************************************************************