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...
Read More »
I love the way some data tables get named. After a while you begin to learn the patterns – but geez sometimes I think a true alien was involved. The names are cryptic and when the tables are place in SAS Information Map Studio – it gets confusing. You can change the name for...
Read More »
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....
Read More »
SAS OLAP Cubes are a great way to quickly aggregate and summarize data that can be used in the other SAS Business Intelligence tools. Learn more about creating relative time based dimensions today. Adding Relative Time Dimensions to OLAP Cubes Dimensions and measures are the two major components of a cube. To effectively report...
Read More »
After you have setup the cascading filter from SAS Information Map Studio, you run a test and notice that the cascading filter is not working properly. Instead of filtering on your desired variable – it returns everything. Eeek … how could this happen to a programming deity such as yourself? Let’s find out …...
Read More »
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...
Read More »
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 or just post a comment....
Read More »
In SAS Information Map Studio, you may notice that some data items have similar names with a numeric after the name. When you use the data items from various tables they may use similar names. It can be difficult for the end user to understand what the data contains. Solve Your Information Map...
Read More »
In Information Map Studio, you can use the Expression Editor and some SAS functions to create new data items from existing data items. Here’s how to create some common Date data items. SAS functions make it easy to perform actions and all you need is a variable and sometimes a parameter or two. [Last week...
Read More »
When creating a new data item in SAS Information Map Studio, you might want to combine two or more data fields to make one. For instance, you want to create the data item Full Name from First Name and Last Name data items. Using the SAS CAT (concatenate) functions makes this is an easy...
Read More »
