Data Visualization

Sanjay MatangeApril 6, 2013 0

Attributes Map - 2

Last week I wrote about how you can use the Discrete Attributes Map to ensure that group values with specific names are represented in the graph with specific colors or other visual  attributes such as marker symbol or line pattern. This attributes map also supports a special keyword "OTHER" which can be used to

Read More

English

Data Visualization

Sanjay MatangeApril 2, 2013 0

Attribute Maps - 1

You created a graph of Response over Time by Severity where Severity has three levels, "Severe", "Moderate' and "Mild".  How do you ensure that "Severe" is always red in your graph, regardless of the data order? Normally, when creating any graph with a GROUP role, the distinct group values are assigned the style

Read More

English

Data Visualization

Sanjay MatangeMarch 24, 2013 0

Custom Box Plots

A frequent question we get from users is how to create a box plot with custom whiskers lengths.  Some want to plot the 10th and 90th percentile, while other want the 5th and 95th percentiles.  The VBOX statement in the SGPLOT  procedure does not provide for custom whiskers.  Also, unlike GTL,

Read More

English

Analytics | Data Visualization

Robert AllisonMarch 21, 2013 0

Basketball tournaments, Moneyball, and sports analytics

A big part of  "winning" these days (be it sports or a business) is performing analytics better than your competition.  This is demonstrated in awe-inspiring fashion in the book (and movie) "Moneyball."  And on that topic, I'd like to show you a few ways SAS can be used to analyze sports data

Read More

English

Sports & Entertainment

Data Visualization

Sanjay MatangeMarch 18, 2013 0

Controlling Point Labels on Series Plot

SG procedures and GTL use a collision avoidance algorithm to position data labels for a scatter or series plot.  This is enabled by default.  The label is preferably placed at the top right corner of the marker.  The label is moved to one of the eight locations around the marker to

Read More

English

Data Visualization

Thomas KeilMarch 14, 2013 0

Analytics kann jetzt jeder – live ausprobieren

Analytics klingt nach Mathestudium oder Informatik, zumindest aber etwas, das kompliziert ist, kaum jemand versteht und am Ende doch keiner wirklich braucht. Das war lange eine verbreitete Meinung – außerhalb der SAS-Community versteht sich. Mittlerweile haben auch die großen Marktbeobachter eingesehen, dass normales Business Intelligence zwar eine wichtige Grundlage ist,

Read More

German

Data Visualization | Programming Tips

Robert AllisonMarch 14, 2013 0

Census block maps in SAS

I've heard many customers ask "Can SAS do/use/handle census block maps?" My answer was "of course!" ... but I never really had any examples to show/prove that.  Well, now I do! :) First, you need to locate & download the shape files for the census blocks you're interested in plotting.  For

Read More

English

Data Visualization

Sanjay MatangeMarch 13, 2013 0

Box with Scatter Overlay

A common request we have been often hearing is for display of the distribution of data as a box plot, along with some detailed information overlaid.  For example, one may have ratings data of all the hospitals in a region by different specialty, and you want to view this distribution

Read More

English

Data Visualization

Sanjay MatangeMarch 9, 2013 0

Parametric Bar Charts

A parametric bar chart in SG Procedure and GTL parlance is a simplified version of the regular bar chart, where the data is assumed to be summarized prior to its usage inside the SG procedures or GTL.  So, multiple occurrences of the same category and / or group combination is

Read More

English

Data Visualization

Roland BrezinaMarch 7, 2013 0

Visual Analytics: Neue Verantwortung für Marketing, mehr Gestaltungsspielraum für Business Analysten

Innovative Technologien für Customer Insights Seit Jahren überzeugen Anbieter von Kundenmanagement- und Marketing-Lösungen die Anwender in Unternehmen, Analytics als DAS effektivitätssteigernde Mittel der Kundenansprache einzusetzen. Zu recht: Marketingabteilungen, die analytische und datenbasierte Konzepte und Lösungen anwenden, sind seit Jahren Vorreiter und Maßstab des Erfolges.

Read More

German

Data Visualization

Sanjay MatangeFebruary 28, 2013 0

Box Plot with URL links

Last week I was out to the 2nd Conference on Statistical Practice in New Orleans.  It was a great opportunity to meet many users of SAS, R and other software and hear about their projects in applied statistics.   I will write up my feedback on this conference soon. In the

Read More

English

Data Visualization

Thomas WendeFebruary 27, 2013 0

Datenvisualisierung – oder wo kostet der Big Mac am meisten?

„Früher war alles besser!“ pflegen gerade Ältere immer wieder zu sagen. Da ich letztes Jahr die 40 überschritten habe, rutscht auch mir bisweilen dieser Satz raus. Was Datenvisualisierung betrifft, ist er allerdings definitiv falsch. Da ist nämlich heute alles besser.

Read More

German

Data Visualization

Robert AllisonFebruary 22, 2013 0

SAS analysis of the #1 most popular baby names

I'm sure that most of you have seen the really cool interactive Baby Name Voyager, right?  If not, go have a look and try it out (be sure to plug in your name, and the names in your family, and so on). Here's a screen-capture: That's a pretty cool application!  ...

Read More

English

Data Visualization

Guido OswaldFebruary 19, 2013 0

Business Intelligence 2013 – Was Analysten erwarten und warum Visual Analytics alles kann!

Boris Evelson ist nicht irgendein Branchenkenner: Der Analyst ist vielleicht der BI Experte bei Forrester! Wie schon oft zuvor schaut er auch 2013 in die Glaskugel und trifft Voraussagen, welche Themen in diesem Jahr dominieren werden. Beim Lesen seines Artikels ist mir klar geworden, wie gut SAS® Visual Analytics den eigentlich erst noch

Read More

German

Data Visualization

Robert AllisonFebruary 14, 2013 0

What are the odds of ... winning the lottery?

What are the odds of winning the lottery?  This seems like a simple question (and yes, there is a simple answer), but there are a few technical details to work out first... Which lottery?  Let's say the Powerball Lottery. When? The number of balls used in the Powerball lottery has

Read More

English

Government

Data Visualization

Sanjay MatangeFebruary 12, 2013 0

GTL Layouts

The Graph Template Language (GTL) provides you the ability to create complex graphical layouts. We have seen how to create a regular grid of cells based on one or more classification variables using the SGPANEL procedure.   Each cell contains the same type of plot.  This topic was covered in Dan's article on

Read More

English

Advanced Analytics | Data Visualization

Waynette TubbsFebruary 8, 2013 0

Friday's Innovation Inspiration - Visualization lets them 'see' the data

Were you at SAS Global Forum last spring? Dr. Goodnight sat down at a computer console and personally demonstrated the cool things that SAS® Visual Analytics Explorer can do? Take a look at his demo, and then imagine working in a drag-and-drop, point and click environment with billions of rows

Read More

English

Data Visualization | Programming Tips

Robert AllisonFebruary 6, 2013 0

A SAS graph for the Chinese New Year

I like to think that I have a graph for all occasions - Chinese New Year is no exception! ... The exact date of the Chinese New Year varies from year to year, because it's based on the lunar (moon) cycles.  I thought it would be useful to create a

Read More

English

Data Visualization

Sanjay MatangeFebruary 4, 2013 0

Percent VBar

Recently a reader chimed in with a question on the Do Loop article by Rick Wicklin on how to create a bar chart with percent statistics.  Rick used SAS 9.3  and the reader wanted to do the same with SAS 9.2. For the basic (non-grouped) bar chart, the process is the

Read More

English

Data for Good | Data Visualization

Robert AllisonJanuary 31, 2013 0

Tracking tornadoes with SAS

We had some fierce wind storms all across the United States yesterday, which even spawned some tornadoes! It looks like we weathered the storm OK here in Cary (but I still need to run out to the lake and make sure my pontoon/houseboat is still there, agh!). Anyway ... as with other

Read More

English

Data Visualization

Sanjay MatangeJanuary 30, 2013 0

AE Timeline by Name

In my previous article on Adverse Event Timeline Graph, I wrote about how to create the AE timeline using SAS 9.2 code, using VECTOR plot and the MARKERCHAR option in SCATTER plot.  I  described a better way to place the labels at the lower end of the vectors. SAS 9.3 provides an easier way

Read More

English

Data Visualization

Thomas KeilJanuary 30, 2013 0

Visualisierung & Analytics - Wie war das mit dem Bild und den 1000 Worten?

Warum ist Visualisierung ein so wichtiges Thema - gerade jetzt? Und warum ist Analytics eine so wichtige Komponente, sozusagen die zweite Seite der Medaille? Eine Annäherung in drei Schritten: 1. Visualisierung Die Ausgangsüberlegung ist simpel: Ein Bild sagt mehr als tausend Worte. Mit einer aussagekräftigen Grafik lassen sich viele Informationen

Read More

German

Data Visualization

Sanjay MatangeJanuary 28, 2013 0

Unicode Tick Values using GTL

Often it is desirable to use special Unicode characters for the tick value names on the axes.  However, SG procedures and GTL do not support Unicode strings in SAS data sets. With SAS 9.3, the SGPLOT procedure supports annotation which does support Unicode strings.  You can create an annotation data set

Read More

English

Data Visualization

Sanjay MatangeJanuary 21, 2013 0

Bar Chart with Target and Attribute Map

A commonly requested graph is a bar chart with response and targets.  With SAS 9.3, the SGPLOT procedure supports new "parametric" plot statements called HBARPARM and VBARPARM.  These statements are special versions of the HBAR and VBAR statements and they expect summarized data for each category or category+group combination.  Also,

Read More

English

Data Visualization | Programming Tips

Angela HallJanuary 21, 2013 0

Maintaining prompt selections in multiple Web Report Sections (v4.3)

SAS Technical Support has a wonderful how-to guide for using one set of prompt values across multiple sections of a Web Report Studio report. This works great in 4.2, however there is one additional item that I discovered in a 4.3/9.3 install. With the addition of PROC STP and SAS

Read More

English

Data Visualization | Programming Tips

Robert AllisonJanuary 17, 2013 0

A neat new trick to trim your macro variables in 9.3

SAS macro variables are a great way to store a calculated value, so you can use it later in your code.  They are not just limited to the data step -- you can also use macro variables in title statements, axis statements, etc. By default, the macro variable will be padded with

Read More

English

Data Visualization

Sanjay MatangeJanuary 14, 2013 0

Multiple Classifiers vs Small Multiples

Often we have the need to see the data by two different classifiers at the same time, as requested by a recent query on the SAS Communities page. In this example I have simulated a response over time for patients by study and treatment.  We want to create series plots

Read More

English

Data Visualization | Programming Tips

Robert AllisonJanuary 9, 2013 0

How to handle percent (%) values in SAS

Being that 2013 is the International Year of Statistics, I wanted to make sure everyone knows how to handle my favorite statistic - percent (%) - in SAS! I often see data in spreadsheets/csv/etc that purport to represent "percents"... but you have to be a bit careful when working with

Read More

English

Data Visualization

Sanjay MatangeJanuary 6, 2013 0

Forest Plot with SAS 9.3

OK, I promise this is the last article on Forest Plots (at least for a while). In the previous article on Subgrouped Forest Plot with Font Attributes, I discussed how to use bold text for subgroup headings.  I mentioned that increasing the font size would not work as it would

Read More

English

Data Visualization

Sanjay MatangeJanuary 5, 2013 0

Subgrouped Forest Plot with Font Attributes

Just a few days ago our "super-duper tech support trooper" called in asking for the link to the subgrouped Forest Plot with bold headings.  She was referring to this Forest Plot with Subgroups  I had posted earlier.  However, as you can see, while the subgroup values are indented from the subgroup headers, the headers

Read More

English