The SAS Output Delivery System and reporting techniques

EXCELXP Formulas

Reply
Super Contributor
Posts: 358

EXCELXP Formulas

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.

PROC Star
Posts: 7,363

EXCELXP Formulas

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]

Ask a Question
Discussion stats
  • 1 reply
  • 134 views
  • 0 likes
  • 2 in conversation