BookmarkSubscribeRSS Feed
deleted_user
Not applicable
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
3 REPLIES 3
Cynthia_sas
Diamond | Level 26
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
Reeza
Super User
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]
deleted_user
Not applicable
Thanks Reeza, that's a great article. I was able to solve the problem with font.properties.

Jeff

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1741 views
  • 0 likes
  • 3 in conversation