|
On Fri, 12 Dec 2008 16:48:42 -0800, Gary <gshyoung@GMAIL.COM> wrote:
>Hi all,
>
>I'm trying to dump some observations into an Excel spreadsheet (*.xls)
>via dde using the following code:
>
>--------------------------------------
>filename test dde "Excel|Sheet1!r1C1:r500C100" notab;
>
>data _null_;
> set test;
> file test; put var1 (var2--var70)( +(-1) '09'x);
>run;
>--------------------------------------
>
>However, the problem is that the last few variables for some
>observations are being written to a new row in the spreadsheet. The
>problem does not occur for all observations.
>
>What could be the problem?
>
>Thanks,
>Gary
default LRECL of 256 is too low
|
