Blogs

Blogs

Data Visualization

Get the right information, with visual impact, to the people who need it

Analytics | Data Visualization

Jennifer MarchiMarch 28, 2012 0

Picture this: The power of analytics extended to everyone in your organization

In my last blog post I revealed the WOW factor of SAS Visual Analytics. In summary: analyzing billions of rows of data, across vast numbers of columns, via 100+ correlation calculations in SECONDS (wow). What exactly does that mean? SAS Visual Analytics takes full advantage of SAS’ high-performance analytics technology.

Read More

Data Visualization

Sanjay MatangeMarch 26, 2012 0

Let them eat pie

ODS Graphics system was initially motivated by the need for high quality graphs for SAS Base, STAT, and other analytical procedures. Use of SG Procedures, ODS Graphics Designer and GTL by users too has initially focused on analytical graphs. But just like wheels on carryon bags that started for the specific needs of flight

Read More

Advanced Analytics | Data Visualization | Programming Tips

Information Map Prompt Group

Angela HallMarch 22, 2012 0

Creating a prompt for a group of data values without the administrator's help

I have previously spoken about using custom formats and from SAS Information Maps and how they can be used to categorize data differently for your end users. The problem for some is that this requires establishing the format on the SAS server, typically on lockdown by the SAS Administrator. Another

Read More

Data Visualization

Sanjay MatangeMarch 22, 2012 0

High resolution graphs

Creating a graph that looks nice, with readable, high resolution fonts is important and should be easy to do. With SG procedures and GTL, this is easy to do with a simple option, but not the default. Creating a high resolution (image) for a graph consumes higher system resources. When working on a graph,

Read More

Analytics | Data Visualization

David WallaceMarch 21, 2012 0

Pivot to win: Banks can score with big data

The first quarter of the fiscal year is the time that banking industry analysts provide clients with their vision on the key challenges and solutions in banking for 2012. TowerGroup’s Nicole Sturgill recently wrote that “understanding consumer use of the financial institution’s delivery channels is a critical element” for institutions

Read More

Data Visualization

Sanjay MatangeMarch 18, 2012 0

Graphs with class

When the data is classified by multiple class variables, you can certainly create graphs using BY variables. This results in separate graphs, one for each level of the BY variable crossings. Each graph is scaled by its own data subset, and comparisons across BY levels is harder. When comparisons need to be

Read More

Advanced Analytics | Data Visualization | Programming Tips

Angela HallMarch 16, 2012 0

Stop recreating the wheel, save those common joins into a permanent view

When you are constantly taking the data tables and completing joins to begin working on your reports or analysis it might be time to consider creating permanent views. Then you can just add the view to the Enterprise Guide project rather than dealing with the joins in a Query Builder

Read More

Advanced Analytics | Data Visualization | Programming Tips

Angela HallMarch 14, 2012 0

Why code when %_eg_WhereParam does the work for you?

After unwittingly getting involved recently in a code vs GUI discussion another pro GUI vote came in yesterday when presenting to a customer's internal user group. When creating and using prompts in SAS Enterprise Guide, it is a no-brainer to recommend leveraging the %_eg_WhereParam as it handles all the special

Read More

Data Visualization

Prashant HebbbarMarch 12, 2012 0

Scaling the graphical heights

Most users of the ODS Graphics system have probably had the need to adjust the dimensions of their graph output at times. The ODS GRAPHICS statement makes this easy to do. This statement supports the WIDTH= and HEIGHT= options. If you set just one of these, the system will calculate

Read More

Data Visualization

Sanjay MatangeMarch 8, 2012 0

Adverse event timeline - revisited

The Adverse Event Timeline graph posted earlier used the MARKERCHAR option of the SCATTER plot to draw the AE names. This option places a center-justified label at the marker position. There is no option in SAS 9.2 version to right-justify the label. Hence, we have to compute an offset in data

Read More

Advanced Analytics | Data Visualization | Programming Tips

Get a quick summary of your data using this task.

Angela HallMarch 7, 2012 0

Use SAS Enterprise Guide to quickly understand a new data set

During IFSUG yesterday, Sunil Gupta gave attendees to his presentation a special homework assignment. Look into the SAS Enterprise Guide task 'Characterize Data'. Sunil suggested that this was a simple approach to quickly getting a summary of all the variables within your data table. Of course, some programmers will use

Read More

Advanced Analytics | Data Visualization | Programming Tips

Angela HallMarch 6, 2012 0

A poor man's approach to fuzzy data matching

Today at IFSUG, Chuck Patridge presented a wonderful talk about how to complete fuzzy matching using BASE SAS tools. Chuck has been programming SAS since 1979 and has been tasked multiple times with coming up with in-house solutions to address business needs without the software costs that are typically associated

Read More

Advanced Analytics | Data Visualization | Programming Tips

Angela HallMarch 6, 2012 0

What does it take to be a BI Dashboard Reporter?

At the IFSUG conference this week in Cary, NC I met Stephen Harris from Bank of America. Stephen gave the talk "Manage Your Partners Before You Manage Your Dashboards: Designing Great Dashboards" covering the business aspects of successfully implementing dashboards. When you back up for a second to consider the

Read More

Data Visualization

Pratik PhadkeMarch 5, 2012 0

Proportionally sized bubble plots

Bubble plots are often used to display social and economic data as Gapminder effectively does. With the addition of the BUBBLEPLOT statement to SAS 9.3, it is now possible to create bubble plots in SAS with a few lines of code: proc template; define statgraph bplot; begingraph; entrytitle 'Bubble Plot

Read More

Data Visualization

Dan HeathMarch 1, 2012 0

Roses are red, violets are blue... (part 2)

In the previous post, “Roses are red, violets are blue…”, I discussed the general problem of getting style attributes to line up with specific group values and some ways to overcome the problem. In this installment, I want to elaborate on the attribute map functionality in the Graph Template Language

Read More

Data Visualization

Dan HeathFebruary 27, 2012 0

Roses are red, violets are blue...

This classic start to a romantic poem assumes that the correct colors are always assigned to the correct flowers; but, for those who create graphs for reports, consistent color assignment can be more of a challenge than an assumption. This challenge is particularly true for the display of group values.

Read More

Advanced Analytics | Data Visualization | Programming Tips

Celebrating #SASBIBook

Angela HallFebruary 24, 2012 0

Celebrate your own free copy of my book "Building Business Intelligence Using SAS"

Well, we can't really afford to give everyone a free copy of the Building Business Intelligence Using SAS: Content Development Examples. But copies will be presented to two randomly selected participants of today's AllAnalytics.com eChat! Then you can be a part of the celebrations! Yes, that's right! People have been

Read More

Data Visualization

Sanjay MatangeFebruary 23, 2012 0

Dashboard graphs revisited

Here is the promised follow up on the Dashboard graph. In the previous article, I posted the code to create a panel of bullet KPIs displaying three different metrics. For each KPI, I used 5 columns of data which resulted in a wide and inconvenient structure. A more convenient data structure is

Read More

Advanced Analytics | Data Visualization | Programming Tips

Angela HallFebruary 22, 2012 0

To be or not to be, testing your cube's existence

Unlike BASE SAS tables, OLAP cubes must exist in within the metadata in order to access from any of the OLAP Viewers. In addition to having some metadata OLAP cubes have a physical file structure presence (at least for MOLAP/HOLAP because it's a different story for ROLAP). When you refresh

Read More

Advanced Analytics | Data Visualization | Programming Tips

Angela HallFebruary 20, 2012 0

Skipping through OLAP to find your value

One of the cool things with SAS OLAP Viewer in Add-in to Microsoft Office is your ability to skip right into a specific value. Out of the box, viewing OLAP cubes can lead you to believe that in order to view a specific value you need to click-thru a hierarchy

Read More

Data Visualization

Sanjay MatangeFebruary 20, 2012 0

Dashboard graphs

In this blog we have been discussing graphs useful for analysis of data for many domains such as clinical research, forecasting and more. SG Procedures and GTL are particularly suited for these use cases. So, when I came upon a dashboard image from Steven Few's Visual Business Intelligence blog, showing the

Read More

Data Visualization

Sanjay MatangeFebruary 16, 2012 0

Distribution of Maximum LFT by Treatment

The graph showing the distribution of the maximum liver function test values by treatment for all participants in a study is commonly used for the analysis of safety data in clinical trials. The data is often structured in multiple columns (one per treatment) as below on the left, or grouped by

Read More

Data Visualization

Sanjay MatangeFebruary 13, 2012 0

Beer, diapers and heat map

The parable of beer and diapers is often related when teaching data mining techniques. Whether fact or fiction, a Heat Map is useful to view the claimed associations. A co-worker recently enquired about possible ways to display associations or dependency between variables. One option is to show the dependency as a node

Read More

Advanced Analytics | Data Visualization | Programming Tips

Angela HallFebruary 9, 2012 0

Best practices for refreshing production OLAP cubes

Unlike prior versions of SAS OLAP technology, 9.2 provides more options for maintaining and refreshing OLAP cubes. With this comes some discussion about what each one does alone, and how pairing these techniques really provides SAS OLAP Server Administrators and cube developers a cornucopia of OLAP options. PROC OLAPOPERATE Remember

Read More

Data Visualization

Sanjay MatangeFebruary 9, 2012 0

SG Procedures Book Samples: Adverse Event Timeline

Here is the second installment of sample graphs from the SG Procedures book - The Adverse Event Timeline. This is a graph commonly used in patient profiles for clinical trials where we track the progress of a patient through a hospitalization event, tracking the dates and severity of the adverse events. The

Read More

Advanced Analytics | Data Visualization | Programming Tips

Angela HallFebruary 7, 2012 0

The best part of writing a book is learning something new

Many of the chapters in my new book Building Business Intelligence Using SAS: Content Development Examples were straightforward to write but one in particular was the beast. Neither Tricia nor I wanted to tackle the SAS BI Dashboard chapter. Just chalk it up to no major work experience with this

Read More

Data Visualization

Sanjay MatangeFebruary 6, 2012 0

Comparative density plots

Recently a user posted a question on the SAS/GRAPH and ODS Graphics Communities page on how to plot the normal density curves for two classification levels in the same graph. We have often seen examples of a distribution plot of one variable using a histogram with normal and kernel density curves. Here is a simple example: Code Snippet:

Read More

Data Visualization

Sanjay MatangeFebruary 1, 2012 0

SG Procedures Book Samples: Forest Plot

In December of last year, the book "Statistical Graphics Procedures by Example" co-authored by Dan Heath and I was published. On the back cover, it proclaims "Free Code on the Web". Now, who can resist such an offer? Since most of the examples in the book have very short syntax,

Read More

Advanced Analytics | Data Visualization | Programming Tips

Angela HallFebruary 1, 2012 0

Complete your order using preview results in SAS Add-in to MS Office

Recently I've made several online purchases buying eBooks for the new Amazon Kindle my daughter received as a holiday gift. The online checkout process is very straight-forward, especially with the 'Continue' buttons that change to a 'Place your order' button on the final step. Did you know that the same

Read More

Data Visualization

Dan HeathJanuary 30, 2012 0

A (tool)tip for band plots

Recently, I had a discussion with a user concerning the volume of imagemap data generated for an interactive, web-based visual contain a large number of graphs. The large amount of imagemap data was causing problems with the current version of their web browser. The graphs consisted of either bar charts

Read More

Previous 1 … 55 56 57 58 59 60 Next