LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (April 1996, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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 *************************************************************************

Back to: Top of message | Previous page | Main SAS-L page