SUGI 27: Creating Custom Excel Workbooks from Base SAS(r) with Dynami c Data Exchange: A Complete Wa

5 data _null_; file sas2xl; put '[workbook.activate("sheet3")]'; put '[formula.fill("XY Average", "r1c1")]'; put '[formula.fill("=average(sheet1! r[+2]c2:r[+2]c3)", "r2c1:r101c1")]'; run; The ‘formula.fill’ function may be used to simply enter text or a v

www2.sas.com