Blogs

Blogs

Data Visualization

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

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

Data Visualization

Sanjay MatangeDecember 6, 2011 0

Adding a spark to your data

When viewing time series data, often we only want to see the trend in the data over time and we are not so concerned about the actual data values. With multiple time series plots, forecasting software can find clusters to help us view series with similar trends. Recently I saw a graph showing the trend of unemployment

Read More

Data Visualization

Prashant HebbbarDecember 1, 2011 0

Graphs you can ‘bank’ on with aspect ratio

The dimensions of your graph can affect the aspect ratio, which in turn, can subtly affect the perception of your viewers. When visual perception is of prime importance, the aspect ratio of the graph needs to be adjusted with care. This technique is known as ‘banking’, was introduced by William

Read More

Data Visualization

Sanjay MatangeNovember 28, 2011 0

Survival Plot with external "At Risk" table

A frequently asked question about the Survival Plot is: "How can I display the 'At Risk' data outside the plot area?". The survival plot rendered by the LIFETEST procedure displays the at risk data inside the plot data area. The reason for this is the potential for varying number of treatment groups. Here

Read More

Data Visualization

Sanjay MatangeNovember 23, 2011 0

SGPLOT with axis-aligned statistics columns

In a previous article we discussed how to add axis aligned statistics table to a Lipid graph using GTL. Other graphs such as the Survival Plot also utilize the same technique to display the "at risk" statistics aligned by time or visits along the X axis. Often, we also need to display

Read More

Data Visualization

Pratik PhadkeNovember 21, 2011 0

Creating Heatmaps using GTL

The heatmap is a graphical representation of a table where colors are used to represent the values in the table. This is an effective graphic for finding the minimum and maximum values across the table and may surface patterns in the data. With the addition of the HEATMAPPARM statement to

Read More

Data Visualization

Sanjay MatangeNovember 17, 2011 0

Abbreviation for GTL boiler plate

Rick Wicklin's blog post on using abbreviations provided a solution for a long standing pain. When writing a new GTL program for simple graph, often the bulk of the code is boiler plate. To create a simple scatter plot of weight by height, you need to type in the following program:

Read More

Data Visualization

Sanjay MatangeNovember 17, 2011 0

SGPLOT procedure - the basics

In this blog we will discuss many aspects of the SG Procedures. This article will cover some basic features and workings of the SGPLOT procedure to establish a baseline. The single-cell graph is the work horse for data visualization. From the simple bar chart to the complex patient profiles for clinical

Read More

Data Visualization

Dan HeathNovember 14, 2011 0

The Power of Unicode

The Unicode character table contains a vast array of characters and symbols that can be quite useful for making your text more descriptive in your graph. These characters can be inserted into any viewable string that you can define in the GTL or SG procedure syntax. These strings include titles,

Read More

Data Visualization

Sanjay MatangeNovember 12, 2011 0

Graphs with axis-aligned statistics tables

The display of statistics, aligned with graphical plot of the data, is a common requirement for graphs, especially in the Clinical Research domain. In the previous post on Discrete Offset, I used an example of the Lipid Profile graph. Now, let us use the same example and add the display of statistics in

Read More

Data Visualization

Sanjay MatangeNovember 10, 2011 0

It pays to be discrete

Often we have the need to display multiple columns of data in a graph, and we want to introduce some separation into their placement in the graph. Or, we want to display a bar chart of multiple response variables, and place the values side-by-side, like in a grouped bar chart. For both

Read More

Data Visualization | Programming Tips

Angela HallNovember 9, 2011 0

Limit the number of drill-through to detail records available from OLAP cubes

Drill-through to detail is the ability to right click within a cell of a web report or OLAP viewer and request the detail source records that make up that specific cell's measure. The maximum number of records, by default, is set to 300,000. Feasibly the report user could download all

Read More

Data Visualization

Sanjay MatangeNovember 5, 2011 0

Hello, World

Welcome to this new blog on data visualization at SAS. Our goal is to engage with you on a discussion about analytical and business graphics for reporting and interactive applications. Our primary focus will be on ODS Graphics and related topics, but we look forward to a lively discussion on all things

Read More

Data Visualization | Programming Tips

Angela HallOctober 27, 2011 0

Revisiting the starting file location for Enterprise Guide

Years ago and a seemingly far galaxy away, I wrote about how to modify 9.1.3 to start Enterprise Guide users in a different location for the File folder. By default, the user only can access their personal SAS Temporary File. Why change this? I would prefer to use a central

Read More

Advanced Analytics | Data Visualization | Programming Tips

Angela HallOctober 18, 2011 0

Troubleshooting a web file upload

Functionality to upload files onto the SAS server (from 9.2 on) is available using stored processes and an html input type="file". I introduced this topic last year in my blog post using the SAS Stored Process Developer Guide sample. Of course, it is never as easy as the sample is

Read More

Data Visualization | SAS Events

Waynette TubbsApril 6, 2011 0

Creating Circular Visualizations of Tabular Data

Contributed by Bill Roehl, Data Geek at Capella University (@garciasn) Analysts love raw data and end-users love to see that same data displayed in beautiful charts and pictures with exciting color. Dr. Danni Bayn, a Research Analyst at Capella University in Minneapolis, provides a drop-in method for SAS users to

Read More

Data Visualization

Waynette TubbsMarch 23, 2011 0

SAS Rock Star, World Champ, wife, mom and entrepreneur: What’s next?

I believe I would have interviewed AnnMaria De Mars even if you hadn't sent me scads of e-mails and tweets suggesting her as a perfect candidate for the SAS Rock Stars series. I "met" AnnMaria when I started looking for SAS users on Twitter – nearly three years ago while

Read More

Advanced Analytics | Data Visualization

Angela HallMarch 21, 2011 0

Create a fully summarized table for OLAP Cubes

SAS procedure SUMMARY is a quick method of converting your detail table to a fully summarized one. Included is a sample. The key option to set is the NWAY - this generates the lowest level of summary for use in the OLAP cube. Essentially - the class statement contains all

Read More

Advanced Analytics | Data Visualization

Angela HallNovember 10, 2009 0

Using Multiple Selection Prompts in SAS Stored Process Code

It is definitely easier to force single selections for prompts used in SAS Stored Processes, however it isn't very usable when the majority of users need to select multiple values. For example, let us say we create a prompt for region (called 'region_prompt') and then use that in the query

Read More

Previous 1 … 53 54 55 56 Next