SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

mutiple tabs diaplay in excel

Reply
Regular Contributor
Posts: 152

mutiple tabs diaplay in excel

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

SAS Super FREQ
Posts: 8,813

Re: mutiple tabs diaplay in excel

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

Ask a Question
Discussion stats
  • 1 reply
  • 411 views
  • 0 likes
  • 2 in conversation