Exporting data from sas 9.1 to excel 2007 Using dde

Raitag — Mon, 28 May 2018 11:38:37 GMT

Hey everyone !
I 'm trying to export some data from sas to excel using dde. Here is my code :

Options noxwait noxsync ;
X ' start excel' ;

Data _null_ ;
Rc = sleep(3);
Run ;
/* openning my xls file : note that i created a xls file */

Filename export dde "excel|system" ;
Data _null_ ;
File export ;
Put '[open("filepath\filename.xls")]';
Run ;

/*Selecting the range in my xls file where to export data */

Filename range dde "excel|sheet1! R1c1:r2c67" ;

Data _null_ ;
Set sashelp.workers ;
File range ;
Put date electric /* columns to export */ ;
Run ;

When i open my xls file nothing is exported,the file is empty but the log says that everything is exported as it should be. I can't figure why, can you help me ?

Ps : i work with sas 9.1 and excel 2007 ( the file is a xlsx saved as xls)

Thank you for your help.

Re: Exporting data from sas 9.1 to excel 2007 Using dde

Tom — Mon, 28 May 2018 17:34:48 GMT

You have a command to open the file, but I don't see one to save the file.

Re: Exporting data from sas 9.1 to excel 2007 Using dde

Patrick — Mon, 28 May 2018 23:12:28 GMT

@Raitag

Before implementing new code using DDE you probably should read this article:

https://blogs.sas.com/content/sasdummy/2014/10/14/dde-is-doa/

topic Re: Exporting data from sas 9.1 to excel 2007 Using dde in SAS Programming

Exporting data from sas 9.1 to excel 2007 Using dde

Re: Exporting data from sas 9.1 to excel 2007 Using dde

Re: Exporting data from sas 9.1 to excel 2007 Using dde