As a follow-up to my earlier post on taking advantage of OLAP member properties, you can also display OLAP member properties through the Add-in for Microsoft Office as well as SAS Enterprise Guide. I’m a huge fan of Enterprise Guide, so it’s nice to have that ability but even nicer when the more common information consumer can display member properties through a Pivot Table in Excel. One Click to More Information Simply right-click the level and select Show Properties in Report. From there you can check the properties you have defined. I like the way the Pivot Table displays member properties as each column in Excel. This information gives the user a little more insight into the data. Also Works in SAS Enterprise Guide To display member properties through SAS Enterprise Guide the approach is similar, right-click the level and select Show Member Property. From there you can check the member properties you want to display. More about OLAP Member Properties Check out my earlier post to see how these same OLAP member properties are defined and displayed in SAS Web Report Studio. Related content: SAS OLAP Cubes: Taking Advantage of OLAP Member Properties SAS Business Intelligence Tools Overview SAS […]
Category: SAS
Business Analytics & The Next Wave of SAS Solutions
I had the privilege this past week of attending the Forum analytique SAS de Quebec and the Forum analytique d’affaires SAS de Montreal, two of the leading edge user groups in Canada. These groups are formidable in structure and in scope, and last…
Things I’ve Learned About WordPress.com
I’m almost done moving this site from Google Sites to WordPress. This post describes some of the some things I’ve learned about WordPress.com. By default, WordPress.com makes your site look like a blog. I preferred it look like a web … Continue reading →
Blogging is Awesome: CDISC Bloggers
I remember when blogging was cool. Before the specializing and monetizing and Twitter-izing. —Peter Dewolf Well I think blogging is still cool (and awesome and awesome …). The most appealing personal reason is, blog posts are Google searchable and suitable for archive while Tweets NOT. Admittedly I hold some sort of Existentialism 2.0: if […]
Stored Processes: 3 Ways to Edit a Stored Process
Some may not realize that you can edit a SAS Stored Process in multiple ways (depending on your permissions). Today I show you three different ways to reach the stored process code. By the way, I’m using SAS Enterprise Guide 4.3 and SAS Management Console 9.3 – so your windows may look different. Method 1: SAS Enterprise Guide Many of you are aware of this method already. Just for review – here’s how you open a stored process and then change it with SAS Enterprise Guide. You have to be connected to the metadata server to reach the stored process. From the SAS Folders pane, select the SAS Folders icon. Navigate to the stored process location. Right-click the stored process and select Add to Project. The stored process appears in the Process Flow and Project Tree areas. From the Process Tree or the Project Flow area, right-click the stored process name and select Modify <stored process name>. The Stored Process Manager window appears and you can make changes to your code. I use this method most often because I like the help I get from SAS Enterprise Guide. Method 2: SAS Management Console If you have access to the […]
Top 10 tips and tricks about PROC SQL
Interestingly, I just found that the most searched keyword is PROC SQL, through the traffic analysis of my tiny blog. The reason possibly is: nowadays everybody knows SQL, more or less; then someone can do some parts of the SAS job by PROC SQL wit…
Jedi SAS Tricks – Roll Your Own Function
A SAS user (who lives in the the US) emailed me a question about SAS functions. He was read UTC (Coordinated Universal Time) datetime values from server logs, and to make future calculations and comparisons easier, he wanted to transform the value to …
ESTIMATE Statements – the final installment
FINALLY…the simplest ESTIMATE statements to write are for continuous variables not involved in interactions or higher order terms. Consider a data set containing the 2004 SAT scores for each of the 50 states. The file includes the combined math and v…