There are times when you need row numbers on your report. Maybe you are ranking items and you want to be clear that the list is ranked or maybe you have a report viewer who only feels the report is…
[[ This is a content summary only. Visit my websit…
Since September, Angela and I have been actively posting on this blog about the SAS Business Intelligence toolset. It has been a lot of fun and thanks to all of your encouragement and kind comments. I’ll share some stats with you data geeks t…
There are 2 ways to develop OLAP cubes in the SAS EBI platform: using SAS OLAP Cube Studio or by writing the PROC OLAP statement by hand and submitting the SAS program. There are pros and cons for both that I will go through in this post. Personall…
If you have spent anytime building SAS prompts for a stored process, then you might have noticed the prompts near the bottom of the list and wondered how anyone would use those or even need them. In a previous post, I showed you how to use the data l…
As we have observed majorly in large enterprises, particularly the Banking and Finance sectors, there is always a huge amount of data building up every day. Moreover, one cannot ignore the fact that every observation in the database is linked up or imp…
I love to read and when I’m researching a subject, I go through books like a kid in a candy store. Recently I started reading some of the general Business Intelligence books. What I find is that you need these books when you are preparing pre…
Conditional highlighting, also referred to as traffic lighting, helps report consumers quickly recognize when the data is showing the desired trends based on their targets. Today I’ll talk about the color choices for the highlighting from MS Ex…
When working in SAS Enterprise Guide, you can access data from the metadata libraries. When you make changes to the datasets in the meta library, such as adding or modifying columns, or even deleted datasets, the metadata library does not have the data…