Often I refer to SAS Stored Processes as the workhorse of the SAS BI tools … you can use these little devils everywhere sometimes as Band-Aid, sometimes as the star, and sometimes as a background player. In a past post, I showed you how to use a stored process to add dashboard dials to Web Report Studio and Linking to a Stored Process from Web Report Studio. Add-In for MS Office – View Reports or Data Use the stored process to deliver a report or maybe just a dataset (using Proc Print) to the Add-In for Microsoft Office (AMO). In the past, I set up several stored processes that only contained a PROC PRINT to display a data set. Then I added a prompt for Product, which allowed the user to query product inquiries based on the product of interest. Here’s how you access the stored process from AMO 4.3. This works similarly in prior versions of AMO. Open MS Excel (or Word/PowerPoint). On the SAS ribbon, click the Reports icon. Navigate to the stored processes storage location and click the stored process name. < Optional> This stored process has two prompts: Visitor Type and ODS Style. Your stored process […]
Read more →
