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

Stored proc execute but report doesn't show in Excel

Accepted Solution Solved
Reply
Contributor tlk
Contributor
Posts: 49
Accepted Solution

Stored proc execute but report doesn't show in Excel

Hello,

I wonder if anyone had this problem, I execute  a report  from Excel, it's a proc print from a sashelp table, something simple to test my problem.   The stored proc execute, the log is fine no error, but the status window indicate that the report failed and nothing show up on my sheet...

Thanks!

Laurent


Accepted Solutions
Solution
‎08-03-2015 02:53 PM
Contributor tlk
Contributor
Posts: 49

Re: Stored proc execute but report doesn't show in Excel

Hello,

As I was work with SAS TS, I found what was the problem, in June IT dept changed the unc path(where is My SAS File directory).  The AMOOptions.xml file is created the first time we use AMO...  the file was created before the unc path change...  The quick way to correct this is to delete the file and AMO will recreate it or edit the file to change the unc path.

Hope this help!

View solution in original post


All Replies
SAS Super FREQ
Posts: 8,643

Re: Stored proc execute but report doesn't show in Excel

Hi:

  The reason for the stored process not delivering results to Excel are usually that:

1) you have specified the wrong destination -- for example, your stored process might have an override to use ODS PDF and that is not one of the result types that Excel can receive and open

2) you don't have the right stored process elements, such as %STPBEGIN; and %STPEND; in your code.
   

  Someone will have to look at ALL your code for the stored process and ALL your stored process settings.
    

  When I register and run THIS stored process on my image of the BI Platform, it runs for me in EG, Web Report Studio, Excel, Word and PowerPoint and produces results:

%stpbegin;

 

proc print data=sashelp.class;

run;

 

%stpend;
     

  I think your best resource in this situation is to open a track with Tech Support. You say in your note that the status window says the report failed. You will need to capture the exact text of the failure message for Tech Support.


     cynthia

Contributor tlk
Contributor
Posts: 49

Re: Stored proc execute but report doesn't show in Excel

Hi

Thanks for your answer.

It runs fine in EG, it's just in Excel, Word and Powerpoint,  I cannot try it on the Web platform, it is not functioning right now(it's another story!). I opened a track given  a sceenshot of the status window and the log.

Solution
‎08-03-2015 02:53 PM
Contributor tlk
Contributor
Posts: 49

Re: Stored proc execute but report doesn't show in Excel

Hello,

As I was work with SAS TS, I found what was the problem, in June IT dept changed the unc path(where is My SAS File directory).  The AMOOptions.xml file is created the first time we use AMO...  the file was created before the unc path change...  The quick way to correct this is to delete the file and AMO will recreate it or edit the file to change the unc path.

Hope this help!

Post a Question
Discussion Stats
  • 3 replies
  • 1514 views
  • 4 likes
  • 2 in conversation