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
Ni
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
Thank you cynthia, for guiding me to appropriate forum!!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.