Using Stored Processes to Improve Information Maps

Angela Hall
Angela Hall|December 13, 2010

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

Post a Comment

CASE statement syntax in Information Map Studio

Angela Hall
Angela Hall|July 8, 2010

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

Post a Comment

Capitalize the 1st letter - or better yet not

Angela Hall
Angela Hall|June 16, 2010

So you are viewing your SAS Web Report and find that all the data elements capitalizations have changed – instead of no caps or all caps, everything is prop cap (or at least PROPCASE). This is actually a default option in Information Map Studio. To turn it off, select Tools [...]

Post a Comment

Grey'd out 'Get Values' button in Web Report Studio filters

Angela Hall
Angela Hall|June 14, 2010

So we are in Web Report Studio, need to create a filter, can’t remember the values and want to see them to select them, but the ‘Get Values’ button is grey’d out? Argh! All that is required is a simple modification to the Information Map. If you go to the [...]

Post a Comment

Improve Web Report Studio performance by carefully choosing processing locations

Angela Hall
Angela Hall|February 25, 2010

Information Map Studio allows data managers the ability to join tables, create new data elements, and label/format data items for business consumption. However due to this flexibility users must weigh the benefits of customizing information maps against the performance impacts of completing many of these tasks within the Information Map [...]

Post a Comment

Parameterized date filters in Information Maps 4.2

Angela Hall
Angela Hall|January 27, 2010

The 4.2 version of SAS Information Map Studio provides data managers with the ability to create a dynamic filter based on dates. This is extremely valuable for things such as daily reports. Included below is an example of a new filter that is built off a date formatted data item. [...]

Post a Comment

Using custom formats in Information Map Studio 4.2

Angela Hall
Angela Hall|January 22, 2010

The easiest option is to simply move your 9.2 format catalog to Lev1\SASApp\SASEnvironment\SASFormats\formats.sas7bcat. But you can also modify your SASv9.cfg configuration file to point to a different location: -set fmtlib1 “E:\sharedformats” -fmtsearch (fmtlib1.formats) So e:\sharedformats is a shared location for the format catalog, and formats (filename formats.sas7bcat) is the name [...]

Post a Comment

Information Map Studio 4.2 - Something to love!

Angela Hall
Angela Hall|October 22, 2009

Bulk editing of multiple data elements An example of this is when you have 10 items that are numerical and therefore are set to allow measures, but should be classified as categorical (such as serial numbers and ids), you can select all of these values, now you can in one [...]

Post a Comment

Shared Prompts in SAS 4.2 Information Map Studio

Angela Hall
Angela Hall|October 19, 2009

Just a quick tip on the shared prompts in SAS Information Map Studio: When attempting to select a previously created prompt in Information Map Studio, SAS will only display shared prompts that can be used for the type of variable you are filtering/prompting. For example, if you have a date value [...]

Post a Comment

Cascading Prompts in SAS Stored Processes take the Cake!

Angela Hall
Angela Hall|October 14, 2009

Let me just say, I am loving SAS 9.2 and it’s functionality for cascading prompts. I created a dynamic list prompt (the icing to that cake by the way) pointing to a sas dataset that has two variables: County and City. In Prompt #1, I created a County Selection pointing [...]

Post a Comment