topic Re: Bold with DDE? in SAS Programming

Bold with DDE?

deleted_user — Mon, 21 Mar 2011 15:42:13 GMT

I'm using DDE to export data to a spreadsheet. Everything is working fine but I need to bold certain entries on the fly. Is there a way to use Escapechar? Something else?

Jeff

Re: Bold with DDE?

Cynthia_sas — Mon, 21 Mar 2011 16:04:54 GMT

Hi:
DDE is NOT using ODS. So, you'd have to use Microsoft commands to select your cells and perform your bolding -- I'm not sure what DDE/Microsoft command would be the equivalent of clicking on the 'B' button on the Excel ribbon.

ODS ESCAPECHAR techniques would only work with ODS output, such as that created by ODS HTML, ODS MSOFFICE2K or ODS TAGSETS.EXCELXP when you create HTML or XML files to be opened with Excel.

cynthia

Re: Bold with DDE?

Reeza — Tue, 22 Mar 2011 20:37:28 GMT

You can do it using the font.properties command, see paper 022-31 by Bessler on DDE.

[pre]
data _null_;
File DDEcmds;

put '[select("R5C3:R7C5")]';
put '[font.properties("Verdana","Bold Italic",16,,,,,,,3)]';

run;
[/pre]

Re: Bold with DDE?

deleted_user — Fri, 25 Mar 2011 15:59:49 GMT

Thanks Reeza, that's a great article. I was able to solve the problem with font.properties.

Jeff