topic Transfer data to existing and formatted Excel worksheet. in SAS Enterprise Guide

Transfer data to existing and formatted Excel worksheet.

attjooo — Mon, 28 Apr 2014 11:45:19 GMT

Earlier I have used DDE to transfer data from SAS data sets to an already existing and formatted Excel sheet.

That was done on a computer with a single user installation of SAS 9.2. Is there any way to achieve the same in SAS Enterprise Guide?

It is necessary for me to use the preexisting Excel sheet.

Thanks for any help.

Re: Transfer data to existing and formatted Excel worksheet.

RW9 — Mon, 28 Apr 2014 12:36:22 GMT

I don't use Enterprise Guide myself so not sure about that, however SAS provides the libname engine functionality for this. Make sure your Excel file uses named ranges for the data, then you can do a libname directly. There are several documents on this process, here is one:

http://www2.sas.com/proceedings/sugi31/024-31.pdf

DDE is still around, but not really supported and may not be around forever. There are other options, such as tagsets, with which you could re-create a spreadsheet.

Re: Transfer data to existing and formatted Excel worksheet.

Haikuo — Mon, 28 Apr 2014 13:51:40 GMT

I don't see why not. Since EG is largely server based, so you do need to be aware of some differences. Mainly to make sure that the machine where your EG is running do have Excel running, and that could be problem if you don't have server version of MS office installed and/or you don't have PC SAS which supports local session for your EG. Other than that, it shouldn't be a problem. Putting the doable issue aside, AS mentioned you should also consider migrating to excelxp tagsets, where you can have most if not all the excel formats, macros in a more robust way.

Haikuo