Dear Web Report Studio Users, Recently, the SAS Web Report Studio (WRS) design team has been re-evaluating the mapping features and functions offered to our customers in WRS. In order to ensure that we are meeting our customer’s mapping needs, we would like to invite you to participate in a

There are times when I'm looking for the right color to highlight an item or otherwise make output beautiful. As a result, I am always struggling to find good colors to use in my output. SAS Support to the rescue. They have created a program that displays the 256 colors

As Chris Hemedinger has written in several of his blog posts, SAS Enterprise Guide 4.3 has many more formatting options. I particularily enjoyed the 'CTRL-i' option to reformat SAS code with indents and carriage returns to make my programs even more readable. The 'CTRL-e' and 'CTRL-SHIFT-e' keyboard shortcuts are also

Integrating Stored Processes into Information Maps can improve process performance as well as provide extra flexibility and complete query generation control. In order to showcase how powerful this combination is, I am presenting this topic during a SAS Talks webinar session this Thursday, December 16th. The scope of the example will

Another Guest Post from Tricia Aanderud, SAS Programmer Extraordinaire! Here's a hint from the SAS Support site that shows you how to see all the installed templates. If you don't have SAS EG, this code allows you to quickly see the different styles. Also - it can serve as a

During your installation, you can utilize a separate location to store the installation temporary files. The -datalocation option must be defined in the command line with setup.exe. The resulting files include: as well as: Local SettingsApplication DataSASSASDeploymentWizard9.2Bootstrap.log

Guest Post from Tricia Aanderud, SAS Programmer Extraordinaire (meaning she's BASE SAS Certified and an awesome programmer!) When I send ODS HTML email to Outlook 2007, it is ugly. After a lot of research, I finally found the answer on the SAS Support site. If you use ODS HTML -

SAS Web Application Infrastructure automatically logs users out of the system after a predesignated amount of time. Unless the user has the URL bookmarked, they have to retype the Web Application URL. There is a much less frustrating way for users to get back in, allow the user login button

SAS Web Report Studio 4.2 provides you an excellent interface to schedule reports to refresh, because why would you want the report to generate for every user every time they open the report when the data is only updating weekly/monthly/etc? During your design and development of these scheduled reports, consider

There is a wide array of papers (from SAS, conferences, on blog posts, etc) discussing the need to move WORK (the SAS temporary files) off to other locations. In the SAS Intelligence Platform it's the same way, however there are a BUNCH of SAS configuration files to start worrying with.

Developing an OLAP cube, testing in Enterprise Guide or Web Report Studio, and suddenly you begin getting error messages from rebuilding the OLAP Cube stating that it's locked. Now what do you do? Restart the OLAP Server? Well, if you don't have access to the server itself or others are

Included are two quick references to tuning OLAP Cubes: Server Tuning Information ~ http://support.sas.com/documentation/cdl/en/biasag/61237/HTML/default/viewer.htm#a003145996.htm Cube Tuning Information ~ http://support.sas.com/documentation/cdl/en/olapug/59574/HTML/default/viewer.htm#a002605609.htm Also, you can add aggregations to the OLAP cube to improve performance. As mentioned in my earlier post, you should consider doing Advanced Aggregation Tuning to provide presummarized measures of various

In SAS OLAP the N-WAY summarization is created by default, however you have the option to not create the N-WAY & as I highlighted in a prior post, not creating it changes your OLAP type to either a HOLAP or ROLAP. But the real question is what the heck is this

As mentioned in my previous post, there is the need to move OLAP cubes around. Switching to one schema to another via SAS OLAP Cube Studio is straightforward enough, but what if you need to move it from one Business Intelligence Environment to another (a Development BI Server to a

SAS recommends building OLAP Cubes on a separate 'non-production schemas' because cube building can be resource intensive and time consuming. Each OLAP Server can be defined to one & only schema at a given time, therefore you will need to setup the architecture to include another OLAP Server & Schema

When creating an OLAP Cube from a Star Schema table, the Dimensions / Hierarchies created must be free of all blanks. This is because the name is used as a table alias in the SQL Join. The obvious error in the resulting code example below: proc sql; create table geography

Was assisting an individual with an issue on the SAS Discussion Forum and we discovered why some users would not get the prompt to save/view excel content in excel rather than in the web browser. Essentially, the file type options were different for these users. This was causing users to

SAS allows for three different cube storage mechanisms: 1. MOLAP The traditional SAS OLAP Cube will all aggregations / nway stored on a physical file structure accessible by the SAS OLAP Cube Server. 2. ROLAP A relational OLAP cube - where no aggregations are stored and SAS points to the

What if you need someplace to store static files for web consumption. Things that might come to mind: Images HTML Static Title Pages JavaScript PDF Documentation (such as how-to instructions) An ideal place would be a HTML server, since these aren't active files. However in a standard 9.2 installation, there

When viewing OLAP cubes in Web Report Studio, there comes a time when the user might want to view all the levels within the hierarchy, without the cumbersome process of selecting and expanding each individual item. In 9.2, there is a quick solution. When you right click on the level-heading

The %STPBegin and %STPEnd macros are pretty powerful pieces of code for SAS Stored Processes. They embed all sorts of information on devices, where content is located, and just make everything work. However for creating those fancy custom HTML forms or layouts, ods html is needed instead. I've written about

Using ActiveX in SAS graphics provides users with more functionality, options, and pretty colors than Jpeg, gif, etc (check out these examples). The issue is that ActiveX requires a device driver installed on the viewing machine, similar to Flash. In SAS 9.2, the sasgraph.exe is available within the SASWEB component deployed

So, you have created a report with a Filter. That filter is pretty evident somewhere in the report anyway (or you just want the USER to have no knowledge of what is not there) so why not remove the filter list at the top of the report? Pretty easy option,

CASE statements are a powerful mechanism in SQL code to analysis, recode, etc data. In Information Map Studio, you can utilize this CASE statement via the Expression Editor Window. Create a new data item and click edit in the 'Expression Settings' area. From the Categories - CASE operator folder, there

So you've got a nightly process that updates a file somewhere. Unfortunetly, something still has it locked and the update fails, the nightly process crashes & burns, and someone at 8am upon arriving decides to blast you for not having updated data ready for them to analyze. Sound familar? There

I must recommend that you check out this example from pg 70 of the SAS Stored Process Developers Guide. http://support.sas.com/documentation/cdl/en/stpug/61271/PDF/default/stpug.pdf This is a pretty sweet example of how to upload a file from your machine (via Internet Explorer) into the SAS System. A custom form can be created in html

The following option can be added to the Metadata Server to default users to a specific DOMAIN. This removes the requirement of using domainusername or username@domain formats for the username field.   -authproviderdomain (HOSTUSER:DOMAINNAME) I made this modification within the file: ..Lev1SASMetaMetadataServersasv9_usermods.cfg   In SAS Management Console, you must still

Included are some references for using the Libname XML Engine. This can be handy for writing and reading xml. SAS Documentation on the XML Libname for 9.2: http://support.sas.com/documentation/cdl/en/engxml/61740/HTML/default/a002594363.htm An example of exporting a SAS dataset using a custom tagset is located at: http://support.sas.com/documentation/cdl/en/engxml/61740/HTML/default/a002975327.htm The SAS User Group paper http://www2.sas.com/proceedings/sugi29/119-29.pdf also provides

You can export the .sas code from a specific task or the entire project into a .sas file! It's great when publishing a project into a repeatable batch/schedule process. However, be aware of default names for the .sas resulting file. I recently ran across an error when exporting a task

When pages are created, the author can choose the 'rank' which defines the order of tabs for users. (The default is 100.) However, users have the ability to view tabs in this manner or reorder for their viewing pleasure. These options are located within the menu 'Options - Change Page