Tag: SAS Portal

SAS BI: Easy Customizations for SAS Portal and SAS Web Report Studio

Last week I talked about how you could customize the style sheet for Web Report Studio.  One reader,  Kushal Ramani, a SAS consultant from Epoch Research India, suggested that I list some other items that you can easily change in Web Report Studio and SAS Portal.  All of these changes require access to SAS Management Console – so if you don’t have that access you will need to work with your SAS site administration.   Also I’m using SAS 9.3 – if you are using a previous version then your windows or these locations may be slightly different. Change the SAS Portal Banner Title You can make a small tweak to the SAS Information Delivery Portal to replace your organization’s name with the word “SAS Portal” as shown in the following figure. It’s actually a change so simple it should probably be a sin.  You can find complete details in the SAS Usage Note 37734. Just open up SAS Management Console and do the following: In the Plug-ins tab, go to Application Management > Configuration Manager.  Locate the Information Delivery Portal item in the list. Right-click Information Delivery Portal 4.3 and select Properties. From the Advanced tab, change the Portal.Banner.Title value […]

What Can I Do With a Stored Process?

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 […]