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

English

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

English

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

English

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

English

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

English

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

English

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

English

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

English

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

English

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

English

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

English

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

English

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

English

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

English

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

English

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

English

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

English

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

English

Advanced Analytics | Data Visualization

Angela HallOctober 20, 2009 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

Read More

English

Advanced Analytics | Data Visualization

Angela HallOctober 9, 2009 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

Read More

English

Advanced Analytics | Data Visualization

Angela HallOctober 5, 2009 0

Automatic Updates of the SAS Data Libraries (and Tables) Metadata

The SAS 9.2 XML engine is very very very slick. I created an xml map to generate a dataset from xml generated during a metadata getobjects job to then run call execute statements for a proc metalib update. "Wait, you did what??!@#?&" you ask? Here are my simple steps. This

Read More

English

Advanced Analytics | Data Visualization

Angela HallMarch 10, 2008 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

Read More

English

Advanced Analytics | Data Visualization

Angela HallMarch 10, 2008 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;

Read More

English

Advanced Analytics | Data Visualization

Angela HallOctober 6, 2006 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'

Read More

English