Let’s pretend for a moment that you don’t have SAS installed on all of your office computers. But you’ve got some great content locked away inside SAS data sets. Is there a way to get to the content of that data, without having to push the data …
SAS multiple character and varying length Delimiters
I’ve solved a problem I had in my previous post “Strip Characters From Between Two Delimiters”. At work I was given a strangely formatted data file – example.
I needed to separate out the data chunks to work with it. While my first solution…
Your million and one uses of SAS
As many of you know, I write the SAS Tech Report. In that capacity, I have had the great opportunity to meet some very interesting SAS users at our user events and through e-mail, Facebook, LinkedIn and Twitter. It seems that every interesting SA…
Tuning OLAP Cubes
Included are two quick references to tuning OLAP Cubes:
Server Tuning Information ~ http://support.sas.com/documentation/cdl/en/biasag/61237/HTML/default/viewer.htm#a003145996.htm
Cube Tuning Information ~ http://support.sas.com/documentation/cdl/en…
There and Back Again
I must offer apologies to J.R.R. Tolkein for appropriating the title of the book authored by his character Bilbo Baggins as my own. However, I think it’s appropriate for a few reasons. This has indeed been a whirlwind trip to Québec City for the last …
so what is a SAS OLAP N-WAY anyway?
In SAS OLAP, you have the ability to choose whether to not create the N-WAY & as I highlighted in a prior post, not creating it changes your OLAP type to either a HOLAP or ROLAP. But the real question is what the heck is this N-WAY thingy anyhow? F…