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 complete when the numbers are present. To add row numb…
Using SQL for data management
Every weekday I pull out data from IBM DB2 database and do analysis in SAS. I use SQLite to record my personal chores, such as credit card transactions. And I am taking courses of database development by Microsoft SQL Server. Then I have pretty enough…
NOTE: The Hits of 2011
To join all of the others on the internet, here’s an “end of year” list… Blogger tells me that the most popular posts on the NOTE: blog this year were:
1. NOTE: SAS Global Forum 2011 – Update #3, 1,069 page views
2. NOTE: SAS Global Forum …
SAS and IWA (Integrated Windows Authentication) Notes
Over the past year I have worked on a number of SAS® 9.2 platform installations helping to get Integrated Windows Authentication (IWA) working nicely for single sign-on (SSO) for the SAS platform. Whilst it’s relatively easy to turn IWA on, …
Popular Posts, Stats, and Other Musings from 2011
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…
Best Practices: To Write or Not to Write PROC OLAP… That is the Question
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…