I have a SAS table, MyTable, with 10 rows and 23 columns. The columns are named col1-col23.
I am using DDE to transfer the table to a Excel worksheet MySheet in the workbook MyWorkbook.
I have declared a range
filename MyRange dde 'excel[MyWorkbook.xls]MySheet!r1c1:r10c23' notab;
I use
data _null_;
set MyTable;
file MyRange;
put col1 '09'x col2 '09'x col3 '09'x ......... col22 '09'x col23;
run;
The first 3 rows in the Excel sheet is filled correctly, but in the 4th row the 3 last columns, 21-23, is empty, and the values that should be in those cells comes in row 5, columns 1-3. There are no more values on row 5.
The rest of the values then starts on row 6, and now again values are placed in all 23 columns.
What can be wrong?