ODS output result not displayed

[Smijoss]

Hi,

I have a program that creates an output file using ODS Target.excelxp.

When i run it normally in EG , i see an addtional tab of result from where I can download it.

However when i convert the code and run it as a stored procedure, the result tab does not appear.

Please see the attachment.

Has anyone faced this issue before and was able to solve it.  Is there some setting I am missing ?

Thanks

Smijo

[Cynthia_sas]

Hi:

  There have been many previous forum postings, in this forum, about using TAGSETS.EXCELXP. Generally, as a stored process, TAGSETS.EXCELXP output can only be the destination returned to a few of the client applications: the Information Delivery Portal and to a browser using the Stored Process Web App. Even Excel will not accept a stored process whose destination has been set to TAGSETS.EXCELXP. If some client applications recognize that you are using a destination that they don't accept, they will either not show you anything or show you a blank screen or sometimes, change the destination behind the scenes to SASReport XML. So without actually seeing the code you created and whether your overrode &_ODSDEST correctly and/or whether you set the content-type header correctly, it is hard to make more constructive suggestions except that you search the forum for postings on stored processes and TAGSETS.EXCELXP. You should find plenty of hits.

cynthia