The SAS Output Delivery System and reporting techniques

EXCELXP Formulas

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.

Posts: 7,844

EXCELXP Formulas

If you are using the excelxp tagset according to this note you may have to state it in relative terms:

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
  • 2 in conversation