SAS curriculum includes more than 100 SAS, JMP and statistical courses offered in the traditional classroom setting, on-site at your location, in the Live Web classroom, or Self-Paced e-Learning, all aimed at improving user performance and skills using…
Just-in-time data prep in SAS Enterprise Guide
On this blog, I’ve delivered a few tips about using SAS formats to stratify your data values “in place” without having to actually change your data. The most recent example addressed date and datetime variables. My previous examples included simple SAS programs that you can run in SAS display manager […]
SAS OLAP Cubes: Tips for Building OLAP Cube Aggregations Effectively
As promised, this is a guest post by Steve Overton, who was one of the external reviewers on the Building Business Intelligence with SAS. Steve works as a SAS BI consultant in the Raleigh-Durham, NC area and is sharing some of his SAS OLAP Cube wizardry with us today! Building OLAP Cube Aggregations Effectively Let me start by saying that I follow a general practice of building cubes by writing the code directly in a SAS program rather than relying solely on SAS OLAP Cube Studio. Tip #1: Use SAS OLAP Cube Studio for Skeleton Code A good technique I’ve learned is to start building the cube in SAS OLAP Cube Studio to get the skeleton code written for you. Then proceed with additional dimensions, measures, and customizations by enhancing the SAS code directly. Once you have a few cubes built, it is also just as easy to copy the OLAP code from one program to the next! Tip #2: Use Separate Steps for OLAP Cube Aggregations Aggregations in OLAP cubes are used to improve the response time of a cube. By default, aggregations are defined along with the cube in one giant PROC OLAP step. One critical technique […]
Clearning up the sqldf confusion
Apparently I have issues with my reading comprehension and with Textmate (initially) when it comes to using the sqldf package. G. pointed out in the previous comments, I could have just used options(gsubfn.engine = “R”) instead of going through the trouble of installing the tcltk binaries. If you’ve got a happy distribution of R that […]
Example 9.16: Small multiples
Small multiples are one of the great ideas of graphics visionary Edward Tufte (e.g., in Envisioning Information). Briefly, the idea is that if many variations on a theme are presented, differences quickly become apparent. Today we offer general guida…
Example 9.16: Small multiples
Small multiples are one of the great ideas of graphics visionary Edward Tufte (e.g., in Envisioning Information). Briefly, the idea is that if many variations on a theme are presented, differences quickly become apparent. Today we offer general guida…