BookmarkSubscribeRSS Feed
0 Likes

When running a SP in Excel, there should be one worksheet generated for each output of the SP, not just concatenated within a single worksheet.  So, if a SP has 3 proc prints, there should be 3 separate worksheets.

4 Comments
KatS_SAS
SAS Employee

Hello Tom,

I will share this request with development.  However, just to let you know, you can easily cut and paste output from a stored process onto other worksheets, and when you refresh that stored process in most cases we should maintain the location of the output.  

Other options are to use a BY Group (sas note 43863), use ODS code to write to an Excel workbook (ODS Excel or ODS tagsets.ExcelXP) or use multiple stored processes to control the output.

Thank you.

-Kat

tomrvincent
Rhodochrosite | Level 12

The By group doesn't work with multiple outputs (diff data, diff layouts, etc) and writing out to a workbook when you're already IN Excel seems clumsy, but I guess it's the kludge I'll have to use. 😞

 

Not sure what you mean by 'or use multiple stored processes to control the output.'...are you suggesting that using PROC STP will output one worksheet per SP in the same workbook?  If so, that would work, I think.

KatS_SAS
SAS Employee

What I mean by Multiple stored processes is that you have a separate stored process for each output on each worksheet.  Then you would insert each stored process onto the separate worksheets.  And you can refresh all of them in Manage Content at the same time.

tomrvincent
Rhodochrosite | Level 12

Well, I had a detailed response, but then the forum maintenance crashed and it was lost.  Maybe I'll try to reconstruct it, but essentially storing and running multiple SPs in a saved xlsx file adds 2 more layers of complexity and I think SAS should focus on making things *more* simple, not *less* simple.  I have to deal with noobs and this stuff needs to be easier for people to work with.