## Data Visualization

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

Data Visualization
0

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

Data Visualization
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

Data Visualization
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

Data Visualization
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

Data Visualization
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

Data Visualization
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:

Data Visualization
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

Data Visualization
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,

Data Visualization
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

Data Visualization
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

Data Visualization
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

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

0

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

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

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

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

0
DistinctCount() vs NUNIQUE in OLAP 9.2

I was struggling with a calculated member that completes a distinctcount of members in a dimension, the performance was simply unacceptable. After attempting several other measures such as count(), processing changes on the source data, etc, I sent out a msg on Twitter asking for advice. Once again, why aren't

0
Metadata Backup Utility via SAS 9.2 Management Console

A user who is a member of the "SAS Administrators" group and has been granted the role "Management Console: Advanced" can create a Metadata Backup job via SAS 9.2 Management Console. Right Click on 'Backup and Restore' Task under 'Metadata Utilities'. Then select the Backup task created and choose either

0
LSF Users Guide

I’ve never found a great user guide, not to say that one doesn’t exist. You should be able to schedule any type of executable/job like a batch file from using the Platform LSF client tools (packaged with the server tools). You can also use command line executables like bsub and

0
Grabbing the Data Creation Date

The data table creation date is sometimes necessary, say in the footnote of your stored process. Included below is a sample to retrieve this date from the file system. /*Open the dataset*/ %let dsid=%sysfunc(open(sashelp.shoes)); data _null_; /*grab the CRDTE function*/ ddate=%sysfunc(attrn(&dsid;,CRDTE )); /*Format in DDMONYY*/ call symput('ddate', put(ddate, dtdate9.)); run;

0
So How Do You Know What is Installed?

So you have installed the SAS System, and you can check what is licensed with the proc setinit command, but what if something hiccuped in the install. Or your supporting (I mean validating) someone else's install and you need to quickly see what is available? Included below is some 'found'