Last week, a student in my Mixed Models Analysis Using SAS class sent in the following text message during a discussion of crossover designs (sometimes known as ABBA designs, where factors vary within subjects, not ABBA designs where you’re like a Super Trouper). Does it make sense to look at
There is a wide array of papers (from SAS, conferences, on blog posts, etc) discussing the need to move WORK (the SAS temporary files) off to other locations. In the SAS Intelligence Platform it's the same way, however there are a BUNCH of SAS configuration files to start worrying with.
There are 93.6 million cats owned in the United States; 33% of all U.S. households have at least one cat. Book piracy on the Internet has reached epidemic proportions with more than nine million copyright-protected books illegally downloaded late last year and an anticipated 50% increase this year. I have
I love to teach SAS programming and in this blog, I hope to share best practices, tips, tricks and answer some frequently asked questions by our SAS users. I’m constantly learning more nuances of SAS and more programming languages like SQL. Why the interest in language? As you probably know,
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 to the server itself or others are
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 SAS user has an exciting new way
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/olapug/59574/HTML/default/viewer.htm#a002605609.htm Also, you can add aggregations to the OLAP cube to improve performance. As mentioned in my earlier post, you should consider doing Advanced Aggregation Tuning to provide presummarized measures of various
In SAS OLAP the N-WAY summarization is created by default, however you have the option 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
At the M2010 Data Mining Conference, Dick DeVeaux gave a keynote speech about the Seven Deadly Sins of Data Mining. In this video, he gives us a little more insight into these common data mining mistakes and offers some advice.
In this video, M2010 Data Mining Conference keynote speaker, Dr. Simon Sheather compares classification trees and logistic regression and discusses situations in which logistic regression is expected to outperform classification trees and vice versa. In 2001, Dr. Sheather was named an honorary fellow of the American Statistical Association. Since 2006,
