Netezza and Teradata are both great examples of distributed processing databases that combine the power of SAS with their own platform to deliver a powerful analytics tool. The problem? Clients rarely use it. We have seen several clients who possess this functionality. Some of who purchased the DB at the request of the analysts, only […]
Not Documented, Not Exist?!
Weeks before I first got the column edit mode in SAS 9.3 Enhanced Editor. Since had no previous SAS versions in machine, I just checked the online documentation of SAS 9.2 in which it’s not mentioned (while documented in SAS 9.3) then I concluded the column mode is an exciting new feature in SAS 9.3: […]
Excel and OLAP Viewer: Not enough room for the Cube!
When you use the OLAP Viewer in Microsoft Excel you may have run into the window borders – literally. Your cube and analysis needs more space! Scroll, Scroll, and Scroll to See the Cube Data When you open the OLAP cube in the MS Excel OLAP Viewer the default cube size dictates the area used. You may get 20 rows by 20 columns or you might get 2 rows by 2 columns. So when you want to do some analysis, you expand a dimension and scroll, scroll this way and then scroll, scroll that way to see the coveted data! We need space to do proper analysis!! Oh have the data gods forsaken us?!? Answer to Your OLAP Prayers Obviously I would not bring up this point if I did not have an answer. So here’s how you work yourself out of this tight spot. Trick is to turn on the MS Excel Developer Ribbon. It may already be turned on – for instance, in the figure below you can see the Developer menu between the View and Excellent Analytics menus in my MS Excel menu. If you have the Developer menu – then skip to the next step. Otherwise, […]
Happy Leap Year From Logical (Point of View) Operators
Today is Feb 29, –another leap year! I just found it is a good chance to raise the topic of logic operators again. To determine if 2012 is a leap year, use the straightforward logic expression (demo is SAS, follow the pseudo code in the wiki page of leap year): if mod(year,4) = 0 then […]
Jedi SAS Tricks: Some Experience Required
As a Master Chief in US Navy submarines, one of my favorite sayings was “Good judgment comes from experience, and experience comes from poor judgment.” I’ve always had difficulty solidly learning new programming techniques in a traditional class…
A time-saving coding tip: leverage the SAS macro facility
Hi! My name is Jim. I’m a SAS instructor based in Irvine, CA. I spend a lot of time each year teaching students in CA and across the United States how to program in SAS and how to master the SAS macro facility. In case you haven’t taken one…