Date:         Fri, 12 Dec 2008 16:48:42 -0800
Reply-To:     Gary <gshyoung@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Gary <gshyoung@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Weird problem with SAS DDE --> Excel
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

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