Delicious Mixed Model Goodness Imagine the scene: You’re in your favorite coffee shop, laptop and chai. The last of the data from a four-year study are validated and ready for analysis. You’ve explored the plots, preliminary results are promising, and now it is time to fit the model. It’s not
In this interview, Robin Way, SAS Analytics Consultant talks about attending the M2010 Data Mining Conference for the fourth time (this year he'll be a speaker for the second time!), his talk on demystifying sequence analysis, his favorite part of the conference and his advice for first time attendees. My
SAS allows for three different cube storage mechanisms: 1. MOLAP The traditional SAS OLAP Cube will all aggregations / nway stored on a physical file structure accessible by the SAS OLAP Cube Server. 2. ROLAP A relational OLAP cube - where no aggregations are stored and SAS points to the
The ODS ExcelXP tagset is pretty powerful stuff. Hidding columns, changing the print layout to landscape, updating the spreadsheet names, defining the default column width and row height, etc - it's all available using options within the ExcelXP setup. So the best thing to do is grab some documentation. Fortunetly,
A few days after I posted part 1 of this blog post, an interesting message popped up on Twitter from @annmariastat: Confused. If you can get #SAS certification in 3 months what exactly are you being certified as? How much can anyone learn in 3 months? A fair question, and
The %STPBegin and %STPEnd macros are pretty powerful pieces of code for SAS Stored Processes. They embed all sorts of information on devices, where content is located, and just make everything work. However for creating those fancy custom HTML forms or layouts, ods html is needed instead. I've written about
I'm happy to report that I have achieved my SAS Certified Base Programmer credential. w00t!. I took my first SAS programming course on March 10th and passed my exam on June 18th (so I guess a more accurate title would say 3 months and 8 days!). I thought I would
I must recommend that you check out this example from pg 70 of the SAS Stored Process Developers Guide. http://support.sas.com/documentation/cdl/en/stpug/61271/PDF/default/stpug.pdf This is a pretty sweet example of how to upload a file from your machine (via Internet Explorer) into the SAS System. A custom form can be created in html
This week’s assignment? Become masters of SAS Functions! Or at least understand the basics of the most popular ones. Chapter 14 is all about Transforming Data with SAS Functions. We decided to divide this chapter in half due to the length of the chapter and things in our study session
You can export the .sas code from a specific task or the entire project into a .sas file! It's great when publishing a project into a repeatable batch/schedule process. However, be aware of default names for the .sas resulting file. I recently ran across an error when exporting a task
