Hello
I have a process where I export data from SAS into an Excel workbook using DDE. However, I also have to manipulate existing values within the target excel file. My attempts at a simple copy and paste of existing values in the worksheet are not working as expected, if anyone has done this previously please could you point me in the right direction?
Thanks
my code:
* copy and paste previous snapshots; filename ongcopy dde "excel|Sheet1! r2c1:r11c14";
data _null_; put '[error(false)]'; file ongcopy notab lrecl=500; put '[select("r2c1:r11c1")]'; put '[copy()]'; put '[SELECT("r2c4")]'; put '[PASTE()]'; run;
I can't attach an excel file, but here's what the cells look like if you open Excel and paste these into Sheet1
copy from here
paste to here
Aug-15
1
25
0
0
1
27
18
67%
26/05/2015
... View more