Blogs

Blogs

Data Visualization

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

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

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

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

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

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

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

Data Visualization

Sanjay MatangeJanuary 26, 2012 0

Nested graphs

Here are a couple of bar charts showing the city mileage of cars by Type and Origin using the SGPLOT procedure from the sashelp.cars dataset. title 'Vehicle Mileage by Type'; proc sgplot data=cars; format mpg_city 4.1; vbar type / response=mpg_city stat=mean datalabel; xaxis display=(nolabel); run; title 'Counts by Country'; proc sgplot

Read More

Data Visualization

Sanjay MatangeJanuary 23, 2012 0

Timeseries plots with regimes

Recently we discussed the features of the Shiller Graph, showing long term housing values in the USA. To understand the features necesary in the SGPLOT procedure to create such graph easily, it was useful to see how far we can go using GTL as released with SAS 9.2(M3). I got the data Shiller Housing index data

Read More

Data Visualization

Dan HeathJanuary 19, 2012 0

They go where you put them

An issue that SAS/GRAPH users have wrestled with in the past has been how to put tick marks at irregular intervals on their axes. In PROC GPLOT, if you specify irregular intervals using the ORDER option on the AXIS statement, the procedure’s axis kicks into a “discrete” mode, where the

Read More

Data Visualization

Sanjay MatangeJanuary 16, 2012 0

The more the merrier

Often it is useful to view multiple responses by a common independent variable all in the same plot. SGPLOT procedure and GTL support the ability to view two responses, one each on the Y and Y2 axes by one independent variable (X) in one graph. Yes, you can also have X

Read More

Data Visualization

Sanjay MatangeJanuary 12, 2012 0

Custom confidence intervals

Recently a user posted a question on the SAS/GRAPH and ODS Graphics Forum about drawing a plot with custom confidence intervals . The user has a simple data set with category, response (mean) and custom lower and upper confidence intervals. The data looks like this: Robert Allison provided the code (proc gplot +

Read More

Data Visualization

Sanjay MatangeJanuary 9, 2012 0

In good company

A recent post on the SAS website shows the SAS Annual Revenue History. It would be interesting to see how we could create such a graph using SG procedures, and how we could add more information and interest in the presentation. So, I started with the basic informaiton on the annual revenues provided,

Read More

Data Visualization

Sanjay MatangeJanuary 5, 2012 0

Panel graph with axis-aligned statistics

Following up on the theme of graphs commonly used in many applications, here is another one that displays a horizontal bar chart with multiple data columns aligned with the bars. Recently at WUSS, a user stopped by asking how to create just such a graph. While this user wanted something more complex

Read More

Data Visualization

Sanjay MatangeJanuary 2, 2012 0

Simply useful

Let us ring in the new year with something simple and useful. A recent question by a user over the holidays motivated this article on what is likely a commonly used graph. We want to compare the preformance of two categories along with a third measure. This could be something like "How

Read More

Data Visualization

Dan HeathDecember 22, 2011 0

Creating graphs can be a (multi-layered) piece of cake

When I give presentations on using the SG procedures, I try to describe how you can take simple plots and layer them to create more complex graphs. I also emphasize how you must consider the output of each plot type so that, as you overlay them, you do not obscure

Read More

Data Visualization

Sanjay MatangeDecember 19, 2011 0

Map overlays

In Simple maps can go a long way, we discussed some techniques to create simple outline maps from map datasets in the MAPS library using GTL. Now, let us take this a step further to do something more useful with this feature. For some graphs, the map information is an essential part of the

Read More

Data Visualization

Sanjay MatangeDecember 15, 2011 0

Secrets of statistical graphics procedures revealed

A new book from SAS Press, "Statistical Graphics Procedures by Example" co-authored by Dan Heath and I has now been published (phew!). For both Dan and I, this was our first foray into writing a book, so it was highly educational to say the least. The key idea behind the presentation

Read More

Data Visualization

Sanjay MatangeDecember 12, 2011 0

Simple maps can go a long way

Charlie Huang recently posted an article on a new way to draw maps using SGPlot procedure. The basic idea is simple, just use the SCATTER statement to plot the (x, y) points from the data sets in the MAPS library. The GROUP option can be used to color the markers for each

Read More

Data Visualization

Pratik PhadkeDecember 8, 2011 0

Calendar Heatmaps in GTL

Calendar Heatmaps are an interesting alternative view of time-series data. The measured value is displayed as color mapped cells in a calendar. Calendar Heatmaps can be easily created with SAS 9.3 using just the HEATMAPPARM, SERIESPLOT and BLOCKPLOT statements in GTL and some simple data manipulation. The example below shows

Read More

Advanced Analytics | Data Visualization | Programming Tips

Angela HallDecember 8, 2011 0

Building custom measures for OLAP cubes

In one minute (and 10 seconds, but are you measuring that?) you can add a custom measure (also known as calculated members) to your OLAP cube. Watch this video to create a simple calculation multiplying units * price. Remember that this mechanism is not just used for multiplications, you can

Read More

Previous 1 … 53 54 55 56 Next