Specifically, the following code works fine: ods excel file="%sysfunc(pathname(WORK))\test.xlsx" options(sheet_name='Report'); proc report data=SASHEP.CLASS; columns height weight pctwt; define height / display order=internal; define weight / display; define pctwt / computed f=percent8.1; compute pctwt; pctwt=height/weight; endcomp; run; ods excel close;
... View more