Blogs

Blogs

Data Visualization

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

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

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

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

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

Previous 1 … 52 53 54 55 Next