If I use proc print, I can get the subtotal row to contain the subtotal formula once it's in excel. If I use proc report, I can get a summary row at the top, but I'd like to have it contain the subtotal formula in case numbers are updated in excel. I have a lot of excel files to create, so I'd like to have the subtotal formula inserted automatically. Are there any options to have the formula and have it on top? Thanks! Angie
... View more