mutiple tabs diaplay in excel

[gyambqt]

Hello experts,

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;

run;

proc print data=b;

run;

Thanks

[Cynthia_sas]

Hi:

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.

  cynthia