I am using SAS EG 7.1 and have Excel 2016. I need to use proc report to export multiple SAS datasets from a permanent sas library into a single excel workbook; with each dataset being printed on a new sheet. Also i need to give specific names to the sheets. how can i achieve this using ods excel? eg:library sasdata datasets: abc, def, ghi, jkl etc... output: Filename.xlsx sheet1(name-task): abc sheet2(name-outcome) :def sheet3(name-issues): ghi......etc... Please help!
... View more