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

Don ChapmanFebruary 4, 2013 0

Use visual analytics to find and detect the best forecasting method

There are numerous algorithms used in forecasting, and each of those algorithms is optimized for a certain class of data.  How does a business analyst know which forecasting algorithm to use?  With the new version of SAS Visual Analytics, you don’t have to know – the product does all the

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

Data Visualization

Robert AllisonJanuary 4, 2013 0

Using statistics to help you... get dressed

In the spirit of the new year – the International Year of Statistics – I thought I’d share some different ways to use statistics. Can statistics help you in your everyday life?  Certainly!  And here's an example to prove it... Let's say you have a dresser drawer full of white socks. 

Read More

English

Data Visualization

Dan HeathDecember 31, 2012 0

Sorting out your panelled graphs (part 2)

In this final post for 2012, I would like to finish up the panel sorting topic with a discussion on sorting the panel cells by statistic. With this sort, the response or dependent data in each cell is calculated down to a single statistic value (mean or median, for example). These values are

Read More

English

Data Visualization

Robert AllisonDecember 17, 2012 0

Santa's information dashboard

'Twas the week before Christmas, and all through the world ... dot-matrix printers were humming as Santa's naughty/nice list was unfurled... Can you imagine what it must have been like years ago when Santa had to maintain his naughty/nice list by hand, with a feather quill pen?!?  Or even these

Read More

English

Retail

Data Visualization

Dan HeathDecember 17, 2012 0

Sorting out your panelled graphs (part 1)

The SGPANEL procedure is used to create panelled graphics based on classification variables. The panelled cells are generated starting from either the top left (the default) or the bottom left of the panel, controllable by the START option. Currently, the ordering of the cells is determined by two criteria: 1.

Read More

English

Analytics | Data Visualization

Kevin GarbedianDecember 11, 2012 0

5 features SMBs want from data visualization

To read more ongoing tips and insights for small and midsize businesses, follow our SAS4SMB blog series or visit SAS for Small and MidSize Business. Data underpins the operations and strategic decisions of every business. Yet these days, data is generated faster than it can be digested, making it challenging

Read More

Data Visualization

Sanjay MatangeDecember 10, 2012 0

Naomi's Graph Makeover Contest

Naomi Robbins has posted a contest, part 1 of which is to submit alternative representations for the following graph: Clearly, usage of two pie charts to represent the share of the B2B and B2C referrals will invite many responses.  To create the graph, I took the data shown in the Pie Charts themselves, so we are using percent

Read More

English

Data Visualization

Robert AllisonDecember 5, 2012 0

Fun SAS graphs for the holidays

While I'm waiting for the next "data intense" event to show up in the news (so I can blog some SAS graphs about it), I thought I'd share a few fun SAS graphs in the spirit of the holiday season! Please don't hold me to too high of graphical "best practices"

Read More

English

Data Visualization

Sanjay MatangeDecember 3, 2012 0

Most Frequent AE Sorted by Relative Risk

In addition to the Forest Plot with Subgroups, another popular graph in the clinical research space is the Most Frequent Adverse Events Sorted by Relative Risk graph.  Recently, I worked with folks from some pharmaceutical companies to contribute SAS code for this graph to the CTSPEDIA resource for statistical graphics. The data for number

Read More

English

Data Visualization

Prashant HebbbarNovember 27, 2012 0

A Newbie at NESUG

“So, you work for SAS?” asked my co-passenger. I was on the plane to Baltimore to attend my first NESUG conference and the tag on my laptop bag was the clue. I happened to be seated next to a SAS user who was familiar with ODS Graphics. I ended up

Read More

English

Data Visualization

Sanjay MatangeNovember 19, 2012 0

Condtional Highlighting

A recent question by a user lead led me to experiment with what is often referred to as conditional highlighting.  The user wanted to display a bar chart of response by year, where each bar is colored by year, and show a cross hatch pattern on the bars where the

Read More

English

Data Visualization | Learn SAS

Robert AllisonNovember 19, 2012 0

Talking Turkey with SAS Graphs

Have you heard the expression "Talk Turkey"? Well then, what better (tongue-in-cheek) thing to do around the Thanksgiving holiday, than talk some turkey using SAS Graphs! ;) I don't usually decorate my graphs with images and pictures (they typically make the graph more difficult to read), but when it comes

Read More

English

Data Visualization

Sanjay MatangeNovember 10, 2012 0

Report from SCSUG 2012

Last week I attended my first SCSUG conference, this one in Houston.  Houston, the fourth most populous city in USA, is the world's capitol of the Oil and Gas industry.  So it was no surprise I met many attendees from local oil and gas related companies.  But, I also met many

Read More

English