BookmarkSubscribeRSS Feed
etrunner
Calcite | Level 5

1.) I am trying to export several counts into a PPT slide via ODS. Thus far, I have utilized proc sql count statements, with each proc sql statement appearing in a separate box and aligned either in one or two columns (layout=titleandconent -or- layout=twocontent) and this has worked fine. However, I cannot generate arrows in between the boxes(counts) to show the data flow. The only function I have found is sganno/arrow function, which only seems to work within plots. Is there any other function to add shapes into ODS output?

2.) In addition, how do you properly control spacing within ODS between sql statement outputs (boxes), as well as between the ods text up top and the first boxes?

3.) Lastly, when you use the layout=twocontent statement, is there a way to control how many boxes/counts you have in each columnFor example, if I have 6 counts it wants to evenly split 3 boxes in each column, even though in some cases I only want 1 box on the left and 5 boxes on the right.

1 REPLY 1
Rick_SAS
SAS Super FREQ

I think what many people do is to use unicode characters, such as the "RIGHTWARDS ARROW" symbol, which has the Unicode code U+2192. But HOW you use it depends on what you are trying to do. Put it in a title or footnote? Use it as the value of an observation in a data set?  

I recommend that you perform an internet search for your terms, such as "use unicode characters in SAS reports" or something similar. There have been several papers and articles on this topic. Here is one that came up when I did a search:

Useful Tips for Handling and Creating Special Characters in SAS® (pharmasug.org)

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

SAS Training: Just a Click Away

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

Browse our catalog!

Discussion stats
  • 1 reply
  • 636 views
  • 0 likes
  • 2 in conversation