Learning to use a data analysis tool well takes significant effort, so people tend to continue using the tool they learned in college for much of their careers. As a result, the software used by professors and their students is … Continue reading →
Using Windows PowerShell to view your SAS data dictionary
In a previous post I showed how you can use Windows PowerShell (with the SAS Local Data Provider) to create a SAS data set viewer. This approach doesn’t require that you have SAS installed, and allows you to read or export the records within a SAS data set file. In […]
We have moved!
Our blog is now located on our website athttp://www.scorpiosoftware.com.au/blog/
Example 9.30: addressing multiple comparisons
We’ve been more sensitive to accounting for multiple comparisons recently, in part due to work that Nick and colleagues published on the topic. In this entry, we consider results from a randomized trial (Kypri et al., 2009) to reduce problem drinking …
SAS OLAP Cubes: Viewing Member Properties in Excel and Enterprise Guide
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 […]
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…