topic Re: creating output in multiple excel of single excel or in seperate excel sheets in SAS Procedures

creating output in multiple excel of single excel or in seperate excel sheets

nith — Mon, 11 Aug 2014 00:34:33 GMT

Hi All,

I am trying create multiple excel outputs in same excel sheet in stored process.

1. i have created a prompt with static list and multiple values to populate.so, user can select one or more values from list and looking to provide an output in different tabs of single excel sheet from stored procedure or into multiple excel sheets for each selected value. How can do either of ways.

i tried using following format, but didnot work

ODS Tagsets.ExcelXP file='file-name.xml'

/*proc print code*/

ODS Tagsets.ExcelXP CLOSE;

how can i create multiple outputs..

Thanks

Re: creating output in multiple excel of single excel or in seperate excel sheets

Cynthia_sas — Mon, 11 Aug 2014 02:28:35 GMT

Hi:

I recommend you look at the Stored Process forum. There have been many postings over in that forum about using TAGSETS.EXCELXP. When you create a stored process and you run it from inside Excel, each stored process can either write to the current sheet in the current workbook, can write to a new sheet in the current workbook or can write to a new workbook. In order to create 2 sheets in a workbook you would have to run a stored process on the first sheet and then run a second stored process on the second sheet.

When you use Excel as your client application to run the stored process, the only results that Excel can "receive" are SAS Report XML results, HTML results and CSV results. So, when you are using the SAS Add-in for Microsoft office, you cannot run a stored process that uses TAGSETS.EXCELXP. The only client applications that can accept TAGSETS.EXCELXP output are the Stored Process Web Application; or the Information Delivery Portal.

I highly recommend that you search in the Stored Process forum for posts about TAGSETS.EXCELXP, instead of in the SAS Procedures forum.

cynthia

Re: creating output in multiple excel of single excel or in seperate excel sheets

nith — Mon, 11 Aug 2014 19:44:30 GMT

Thank you cynthia, for guiding me to appropriate forum!!