Developing an OLAP cube, testing in Enterprise Guide or Web Report Studio, and suddenly you begin getting error messages from rebuilding the OLAP Cube stating that it’s locked. Now what do you do? Restart the OLAP Server? Well, if you don’t have access…
Power of Logic Operators: a trick
Suppose you should group people based on their ages as follows:
ID
Age
agegrp
001
1
1
002
4
2
003
5
2
004
5
2
005
2
1
006
4
2
007
5
2
008
2
1
009
9
3
010
8
3
and the rules:
age<4, group 1
4<=age<6, group 2
6<=age<10, group 3
It is a very simple question and you could use the if/else statement without thinking:
data age;
input ID $ age;
datalines;
001 1
002 4
003 5
004 5
005 2
006 4
007 5
008 2
009 9
010 8
;
data age1;
set age;
if age<4 then agegrp=1;
else if […]
Peek at your data using VBScript, OLE DB, and the SAS local data provider
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…