I’m really excited, Angela and I were invited to speak at the SAS Global Forum in Orlando in April. We were asked to talk about the SAS BI package and we have narrowed down our topic to SAS Information Map Studio, SAS Web Report Studio, and, if time allows, the SAS Information Delivery Portal. The point of the presentation is learning about the SAS BI clients – getting the data has proved to be a journey of it’s own. Step 1: Need some interesting data … The hardest part of preparing a teaching presentation is find data that presents some mystery and allows you to tell a story that resonates. Right now the leading topic is along the lines of “How do you let people know you have a book out there? How do you build excitement?” For us, building a companion website (this blog) that gave the users an idea of the book content was our answer. Plus the website would be a continuation of the book information for the users. The next question is – “How do you know it’s working?” Using the data that Google Analytics collects for this blog, I have been researching what kind of […]
Tag: Information Map Studio
SAS Info Map: Need leading zeros on the account number?
When creating new variables, the SAS Information Map Studio opens the entire SAS format library to you. These formats can be key to creating lots of new data items. SAS format control the way data items appear. In past articles I showed you how to create new data item using SAS functions and date formats. Check the SAS documentation to learn more about all the different formats available. Creating new Data Items in SAS Information Map Studio When data has been merged from various companies, such as when one company acquires another one, their data may be in different formats. For instance, account numbers might vary from 8 characters in one company and 12 characters wide in the other. When this occurs one option is to use the widest account number and add zeros to the front of the smaller one to integrate the fields better. You can do this easily within the information map using the Z format. From SAS Information Map Studio, you can create or modify the existing variable. In this case I have two account numbers – 1 where there are only 3 characters and the other with 5 characters. The end result should be […]
SAS Info Map: Error Message Invalid Filter
Here’s a quick tip for today. But I’m hearing some rumors that a colleague (who is an SAS OLAP wizard) is planning to post some OLAP tips . If you have a topic idea – send me an email using the envelope icon at the bottom of the page …
Dynamic Static Filters – Turbo boost!
Dynamic filters in Web Report Studio are awesome – no predefining static values and also in sync with the data. But…. they can be a bit on the slow side. Clicking on the ‘Get Values’ button runs a select distinct query which will return the filter list. How long this takes is dependant on a […]