Blogs

Blogs

Data Visualization

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

Advanced Analytics | Data Visualization | Programming Tips

Angela HallOctober 15, 2012 0

Go on a date with SAS BI Dashboard, part 2

Last week I provided the steps for how to go on a date, at least by using dynamic prompts in BI Dashboard. Now that you have seen how to create them, lets discuss making them smarter. For this example, the customer is asking for two prompts to affect a single

Read More

Data for Good | Data Visualization

Robert AllisonOctober 12, 2012 0

Building a better meningitis map

You've all heard about the recent meningitis outbreak, right? Being a data-guy and a map-guy, I went looking for maps related to the outbreak. I found the following map on the Centers for Disease Control (CDC) website. It shows the states that received the recalled drug used in epidurals (for back

Read More

Data Visualization

Sanjay MatangeOctober 7, 2012 0

Scatter plot matrix with a twist

The Scatter Plot Matrix statement supports a couple of different configurations. The basic is the N x N panel of cells, with each cell showing scatter plots plot for a pair of variables at a time. Here is an example of a 3 x 3 scatter plot matrix for the

Read More

Data Visualization

Sanjay MatangeSeptember 30, 2012 0

Forest Plot with Subgroups

During SAS Global Forum 2012, I had conversations with many SAS users who wanted to create Forest Plots. However, there was one new twist. The study names were subgrouped by categories like 'Age', 'Sex', etc., with multiple entries under each subgroup. The name of each study within the subgrouped was indented

Read More

Data Visualization

Sanjay MatangeSeptember 27, 2012 0

Report from MWSUG 2012

A week ago I had the pleasure of attending MWSUG 2012 in Minneapolis. There were many presentations on Data Visualization in various tracks including the following: Using SAS ODS Graphics - Chuck Kincaid Get the best out of SAS ODS Graphics... - LeRoy Bessler Program Assisted Patient Narratives - Faye

Read More

Data Visualization | Programming Tips

Angela HallSeptember 17, 2012 0

Always learning something new, two awesome Enterprise Guide tricks

Who says anyone is an expert at something? I definitely do not when it comes to SAS (well, anything for that matter). Each time I sit through a presentation at a conference I learn something new. During the SAS Western Users Conference, fondly know as WUSS, this month I learned

Read More

Data Visualization

Sanjay MatangeSeptember 15, 2012 0

Report from WUSS 2012

A week ago, SAS "wusses" got together in Long Beach, California for another successful WUSS conference. Personally, I really enjoy all SAS user conferences as it gives me an opportunity to see the creative ways in which SAS users are exploiting our software. One such case was the paper "Power

Read More

Data Visualization

Sanjay MatangeSeptember 3, 2012 0

Doing more with nbsp

A few weeks ago I wrote an article on using the non breaking space character to prevent stripping of leading and trailing blanks in a string. Since then, I have discovered a few more instances where the nbsp can be a useful tool for creating graphs. One such instance came up last week

Read More

Data Visualization

Sanjay MatangeAugust 26, 2012 0

How about some pie?

Pie charts have been the subject of some criticism when they are used to compare measures across multiple categories. It is generally accepted that comparison of magnitudes represented as angular measures from varying baselines is not effective. However here are some use cases where a pie chart does quite well. When it comes

Read More

Data Visualization

Sanjay MatangeAugust 19, 2012 0

Compact Scatter Plot Matrix

The Scatter Plot Matrix is a great tool that provides a quick visual of potential associations between variables. This may provide the analyst some hints on how to proceed with the analysis. Matrix of lab values for liver function tests are commonly used in clinical research. The SGSCATTER procedure provides an easy way

Read More

Data Visualization

Sanjay MatangeAugust 12, 2012 0

Non-breaking space

Forest plots come in many flavors. An example of a Forest plot using GTL is available on the SAS support web site. Simple forest plots can also be created using SGPLOT procedure by using the SCATTER statement with MARKERCHAR to display data aligned with the plot by study names. One issue

Read More

Data Visualization

Robert AllisonAugust 10, 2012 0

Do you use SAS for analytics and Excel for graphs?

Do you use SAS for analytics and Microsoft Excel for graphs? Why not use SAS for your graphs too?!? Then you could completely automate the entire process in one SAS program, with no manual steps! A lot of people use Excel to create their graphs because "it's what they know." What if somebody

Read More

Data Visualization

Robert AllisonAugust 6, 2012 0

Graphs of Olympic proportions!

Everyone in the world has their attention turned towards the Olympics this week, so what better topic to tie in to a SAS/GRAPH blog than that?!?! I had seen a graph on the guardian website that I thought was interesting, so I decided to try to create my own (slightly different)

Read More

Sports & Entertainment

Data Visualization

Sanjay MatangeAugust 2, 2012 0

Extended Bands

In the Clinical Research domain, there is often the need to display lab values by treatment or test and it is often useful to view this data along with reference lines showing the normal ranges. The obvious way is to use reference lines to denote the normal ranges. SGPLOT Code: proc sgplot data=band; scatter x=x y=y

Read More

Data Visualization | Programming Tips

Robert AllisonJuly 31, 2012 0

Visualizing evidence of a black hole, with a gif animation

Hopefully you know that a gif animation can be used for more than just showing a cartoon animal doing cute tricks! Being a savvy data-meister, I'm sure you are also aware that you can use gif animations to see how data changes over time. But perhaps you didn't know you could

Read More

Data Visualization

Robert AllisonJuly 27, 2012 0

Finding patterns in big data with SAS/GRAPH

When working with "big data" you usually have too many points to view in a plot, and end up subsetting or summarizing the data. But now, in SAS 9.3, you have an alternative! For example, the following scatter plot of 10,000+ points is just a visual "blob": But using a new

Read More

Data Visualization

Sanjay MatangeJuly 23, 2012 0

Butterfly plots

When comparing results by category and group, putting the items to be compared close together usually leads to a graph that is easier to decode. Take the case of the data (simulated) shown below. Here we have population by age group and sex. To compare the population by sex, it is

Read More

Data Visualization

Sanjay MatangeJuly 15, 2012 0

Risk tables, annotated or not

A key element of graphs used for analysis of safety data for clinical research is the inclusion of statistical data (or tables) about the study that are aligned with the x axis of the graph. A common example of this comes from the paper "Graphical Approaches to the Analysis of

Read More

Data Visualization

Sanjay MatangeJuly 4, 2012 0

Spark lines made easy

Spark lines, made popular by Edward Tufte, provide a way to visualize trends in a concise space, often inline with the rest of the narrative or data. Previously, I posted an article on Spark Plots in which I created different plot types, some of which included multiple graphs and data in each row. For such

Read More

Data Visualization

Dan HeathJune 25, 2012 0

Graphical swiss army knife

The Swiss army knife is known for its versatility, with a variety of tools and blades to help you complete the task at hand. When you are creating graphics, you sometimes have a special feature you want to add, but you can't seem to find the right syntax "tool" to

Read More

Data Visualization | Programming Tips

Angela HallJune 18, 2012 0

Code wizards make the magic happen

Wizard Harry Potter makes magic just waving his wand around and shouting out spells. Using SAS Enterprise Guide (and you are welcome to shout out your own commands too) you can create some magic, allowing the Stored Process Wizard to code for you. On Step 2, the "Include code for"

Read More

Data Visualization

Sanjay MatangeJune 17, 2012 0

Graphical display of statistics

Statistical graphs often include display of derived statistics along with the raw data. Often these statistics are presented in a tabular format inside the graph. With SGPLOT procedure, a table of statistics can be added to the graph as an inset table, as shown below. Using a Stat Table: SGPLOT code:

Read More

Data Visualization

Sanjay MatangeJune 14, 2012 0

Quick and easy with MODSTYLE

ODS Graphics components like GTL and SG procedures are designed to work with Styles to create graphs that are effective in the delivery of information and aesthetically pleasing out of the box. You no longer have to tweak the colors to ensure a nice graph. The graph derives all the

Read More

Advanced Analytics | Data Visualization | Programming Tips

Angela HallJune 12, 2012 0

How did you find that metadata?

A common question really and one that I get after posting code like yesterday's All SAS Stored Process Locations Report. The neat trick is just to type METABROWSE in a BASE SAS command window. (There are two other commands: METACON and METAFIND. Has anyone got any tips on when those

Read More

Advanced Analytics | Data Visualization | Programming Tips

Angela HallJune 11, 2012 0

Where is the SAS code for that stored process?

Stored process code can exist within the metadata itself for version 9.3 (the benefits of which I discussed earlier). But for all other versions (and as a option in version 9.3) the SAS code is stored as a .sas file within the server's file system (or mapped folder/drive structure). When editing

Read More

Data Visualization

Sanjay MatangeJune 10, 2012 0

LFT Panels

CTSPedia.org is a website of Knowledge Base for Clinical and Translational Research. On this site you can find sample graphs for statistical analysis of safety data for Clinical Research. Graphs included in this resource have been submitted by contributors, and include a graph for Liver Function for different tests by treatment.

Read More

Advanced Analytics | Data Visualization | Programming Tips

Angela HallJune 8, 2012 0

Selecting multiple individual dates in prompted reports

The date prompt from SAS Prompt Framework provides the options of single selection or a range, however what if you need to select multiple individual dates such as Monday (May 28), Wednesday (May 30), and Friday (June 1) of last week? There are a few alternatives to accomplishing this. Option

Read More

Data Visualization

Sanjay MatangeJune 7, 2012 0

Bar chart with response sort

A graph in a recent article in Fortune magazine caught my eye. The graph shows the cost of hosting the Summer Olympics over the past eight events. Here is what I termed the "Medal" graph. Now, practitioners of the art of Effective Graphics would likely find some shortcomings in the graph. Clearly

Read More

Advanced Analytics | Data Visualization | Programming Tips

Angela HallJune 7, 2012 0

Change your passwords without locking out your connection

Did you change your LinkedIn password yesterday? (If you didn’t, you should!) But did it happen to be the same as your corporate password? First, tisk tisk. Second, change your corporate password NOW! Ok, now that this is done ~ don’t let your saved connection profile for SAS applications lock

Read More

Previous 1 … 51 52 53 54 55 56 Next