BookmarkSubscribeRSS Feed
OS2Rules
Obsidian | Level 7

Hi All:

I know this must have been answered somewhere, but I can't find it ...

I would like to write a formula to Excel rather than a value.  I know I can write like:  '=ROUND(+RC[-1],2)'  but I would like to just write a simple ' =B1/B4'  into the sheet.  When I try this, Excel wraps a bunch of quotes around the value and it becomes garbage. 

Thanks in advance.

1 REPLY 1
art297
Opal | Level 21

If you are using the excelxp tagset according to this note you may have to state it in relative terms: http://support.sas.com/rnd/base/ods/odsmarkup/excelxp_demo.html

Thus, if it is going in column 5, you may have to state it like your round formua: =RC[-4]/RC[-1]

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

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
  • 1 reply
  • 1031 views
  • 0 likes
  • 2 in conversation