topic Re: mutiple tabs diaplay in excel in Microsoft Integration with SAS

mutiple tabs diaplay in excel

gyambqt — Mon, 09 Feb 2015 04:53:09 GMT

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

Re: mutiple tabs diaplay in excel

Cynthia_sas — Mon, 16 Feb 2015 03:43:52 GMT

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