I experimented a bit more with this and got some additional feedback from my birdie. Let me share that with you:

- The _ODSM_SR_RAW is set if your properties in Excel are set so the content is returned in what is called "SAS Report" format (thus the SR). If the user chooses HTML then that variable does not exist, but a variable called _inExcel does (pretty clear what that is). The third choice for returned results is CSV and neither of the two variables exist in that case.

- Using _RESULT might be OK if your stored processes will always be returning streamed content and not a package. In that case, the speculation is that if _RESULT is not STREAM that the client is likely to be EG since it apparently always wants a package as the return result set.

Might I also suggest that once you figure out a reasonable technique (along with the caveats) that you write it up and post it to sasCommunity.org (www.sasCommunity.org)? I will be glad to assist you in doing that if you are intested.

Regards, -donh

-----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of And Sent: Friday, February 29, 2008 1:55 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: Find the application that invoked a SP

On 29 Fev, 15:50, donaldjhender...@HOTMAIL.COM (Don Henderson) wrote: > A birdie has confirmed for me that there is no failsafe way to do this > in 9.1.3, but added that in 9.2 there is supposed to be a macro > variables called (I think _CLIENT) which will have different values > for the different clients). > > In the meantime, you should probably check out the macro variables > that are set to see if ther are any differences between AMO and EG. I > did a quick check and compared Excel and EG and found a few > differences (but use them with caution (the first value is the value > when Excel was the client, the second when EG was the client: > > _ENCODING: UTF8 vs utf-8 > _NAMEVALUE: null vs _default_entry=main.html > _ODSDEST: tagsets.SASREPORT11 vs HTML > _ODSM_SR_RAW: only seems to exist in Excel > _RESULT: STREAM vs PACKAGE_TO_ARCHIVE > > There were a number of others. You should check them out by looking at > sashelp.vmacro in all the client environments you care about. > > While this is a hack and no bulletproof, perhaps checking either > _ODSM_SR_Raw or _RESULT is a safe way to go. > > HTH, > -donh > > > -----Original Message----- > > From: SAS(r) Discussion [mailto:SA...@LISTSERV.UGA.EDU] On Behalf Of > > And > > Sent: Friday, February 29, 2008 7:38 AM > > To: SA...@LISTSERV.UGA.EDU > > Subject: Find the application that invoked a SP > > > Hi, > > > I am facing this problem. I have a stored process that will be > > invoked from both SAS Enterprise Guide and SAS Add-In for MS is it > > possible to make it generate different outputs depending on the > > application that invoked it. > > > Thanks in advance > > > And

That seems a good approach. I will try it and if I have any news I will let you know!

Thanks again

And