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…
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…
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 …
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, …
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…
Someone on SAS-L wanted a piece of SAS code to convert a long url to a short one. Well, here you go:filename in “x:\temp\in”;filename out “x:\temp\out.txt”;%macro MakeTiny(longUrl=); data _null_; file in lrecl=1028; put “url=&longUrl” ; ru…
Our mini-series of hints and tips from past decades continues with 1999…
Appearing in the same issue of The Missing Semicolon (TMS) was i) an advertisement for Year 2000 Support (do you remember “Y2K”?), and ii) an article entitled “Decoding the _TY…