02-08-2015 11:53 PM
I am having trouble to display outputs into multiple tabs in excel when the stored process report is opened by AMO like following;
The stored process below is created to produce two tables, a and b.
when I use AMO to open the stored process report, I want to display table a in sheet1 and table b in sheet2 in one excel file. How do I achieve that???
proc print data=a;
proc print data=b;
02-15-2015 10:43 PM
As far as I know, a stored process can only populate a new sheet in an existing workbook or the same sheet in a workbook or a new sheet in a new workbook. But one stored process cannot populate 2 sheets. My understanding was that you would have to run one stored process to get results in one sheet and then another stored process to get results in a different sheet.
You would have to double check with Tech Support to see whether this is still the case with stored processes and the SAS Addin for Microsoft Office.