Introduction: Merging two or multiple datasets is essential for many ‘data people’. Yes, it is a dirty and routine job. Everyone wants to get it done quick and accurate. Actually, SAS has many ways to tackle this job[3]. In two competing papers fro…
Web OLAP Viewer is dead (RIP)
I remember when SAS 9.1 was released and the new SAS Web OLAP viewer for Java (SWOVJ) was released. It was a great new interface to replace the old MRV. It went through a few iterations, but not a lot changed (although I was always confused about which version could only open Cubes and whihc could open […]
A Moustachio-ed Tim Trussell Returns to his Roots
One week after the Health User Group and I’m FINALLY able to pass on some great stories from the meeting! Boy oh boy, this backlog of blog posts has bothered me beyond belief. I’ll be very pleased when I’ve caught up completely after this entry… I wa…
To INDEX or not to INDEX…
Recently, a certification candidate asked me about indexes and how SAS decides whether to use one or not. I don’t work with supper-large data sets and therefore haven’t been overly concerned with efficient coding techniques and consequen…
Calculating the UTC offset in your SAS session
Update 25Nov2010: I’ve updated this example to correct the code so that it works correctly for positive UTC offsets. Thanks to Bruno Müller, my colleague at SAS, for finding my mistakes.
One of my SAS colleagues was recently working on a p…
Booooom!!! proc explode!!!
I came across an interesting procedure today.. Its called as proc explode!This procedure enables the user to blow up the text in nice formatting and display it on the output screen (I think only in listing).This reminds me of the ‘banner’ command in th…