Desktop productivity for business analysts and programmers

Transfer data to existing and formatted Excel worksheet.

Reply
Contributor
Posts: 30

Transfer data to existing and formatted Excel worksheet.

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.

Super User
Super User
Posts: 7,671

Re: Transfer data to existing and formatted Excel worksheet.

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.

Respected Advisor
Posts: 3,156

Re: Transfer data to existing and formatted Excel worksheet.

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

Ask a Question
Discussion stats
  • 2 replies
  • 225 views
  • 0 likes
  • 3 in conversation