sas dde

Occasional Contributor
Posts: 13

sas dde

hi i am new to sas,

basically i came to know that just like in hyperion you can use joole to format excelsheets

in sas you can use dde to go to cell level and format excel sheets.

basically what i want is to create fancy excel sheets with coloring, pasting data to specific cells, formatting, adding formulas, headers in excel via code.

can i do that using sas dde in sas enterprise guide 4.3.

please advice

Super User
Posts: 23,724

Re: sas dde

Usually not, from what I understand, because its been turned off by default.

You should look into the Tagsets.ExcelXP destination though, it can do a lot of what you're looking to do already (minus the paste data to specific cells).

Ask a Question
Discussion stats
  • 1 reply
  • 2 in conversation