Blogs

Blogs

Data Visualization

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

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

Advanced Analytics | Data Visualization | Programming Tips

Open Stored Process GUI with Copy Selection

Angela HallJune 6, 2012 0

Backup or copy all components of your stored process before making changes

What if you would like to make a copy of an existing stored process to test out your changes before making them live? The copy command is available from within SAS Management Console or from the SAS Enterprise Guide Open Stored Process GUI as seen below (note you can only

Read More

Data Visualization

Sanjay MatangeJune 3, 2012 0

Broken Y-Axis with SAS 9.2

In the previous post on Broken Y-Axis, I reviewed different ways to display data as a Bar Chart, where the response values for some categories are many orders of magnitude larger than the other values. These tall bars force the display of other values to be squeezed down thus making it harder to compare

Read More

Data Visualization

Sanjay MatangeMay 31, 2012 0

Broken Y-Axis

Often we want to display data as a bar chart where a few observations have large values compared to the rest. Comparison between the smaller values becomes hard as the small bars are squeezed by the tall bars. Here is an example data, and a bar chart showing the data. The large values

Read More

Data Visualization

Sanjay MatangeMay 28, 2012 0

Bivariate response graph

Recently, I came across an interesting graph showing Euro contries bank exposuro to GIIPS countries, as percent of GNP. Here is the graph: I thought I would see how far I can get in making a similar graph using SAS. I made up some data with response values for a Product x

Read More

Data Visualization

Sanjay MatangeMay 25, 2012 0

Dual category variable graph

This post is a result of an intriguing question posed by a user on the SAS communities' page. How to create a bar chart where the category is a combination of two variables var_1 and var_2 (each with values of '+' and '-'), and get a X axis that shows each

Read More

Data Visualization

Sanjay MatangeMay 20, 2012 0

Graph size for presentations

At SAS Global Forum, and again at PharmaSUG, we had the pleasure of attending many papers and presentations on various topics that included graphs in the power point decks or in the papers. More often than not, the graphs exist along other text, and occupy a smaller part of the screen

Read More

Data Visualization

Sanjay MatangeMay 17, 2012 0

PharmaSUG 2012 update

PharmaSUG 2012 conference drew to a close today, concluding two and a half days packed with papers, presentations, posters, hands-on demos and super demos by SAS staff. While the weather outside was a bit chilly from time to time, the conference what hopping with many user papers on how to

Read More

Data Visualization

Prashant HebbbarMay 7, 2012 0

'Unbox' Your Box Plots

At the 2012 SAS Global Forum, one of the questions from a user was about showing the original data used for the box plot. While you can use outliers in conjunction with the box features to get a feel for the data, for some situations you may need to see exactly

Read More

Data Visualization

Sanjay MatangeMay 3, 2012 0

Graphs with log axis

Recently I posted an article on this blog on how to create bar charts with log response axes in response to a question by a user. This generated some feedback suggesting that bar charts should not be used with log response axes or with a baseline of anything other than

Read More

Data Visualization

Sanjay MatangeApril 30, 2012 0

Axis values and hint

Getting the axis values just right generally requires some work, and the values you want can change from case to case. One such example was discussed by Dan Heath in his post on custom axis values. Here Dan shows the usage of non uniform axis values using the VALUES option on

Read More

Data Visualization

Sanjay MatangeApril 25, 2012 0

Bar chart with log response axis

Creating bar charts with log response axis has come up a few times in the past few days. Before we look into how we could do this, it would be worth pointing out the considerable opinion in the blogosphere against use of log response axes for bar charts. See BizIntelGuru and

Read More

Data Visualization

Sanjay MatangeApril 23, 2012 0

SAS Global Forum Monday update

On Friday before the conference, I presented a 1 day "developer led" seminar on SG Procedures and GTL, along with a discussion of new features for SAS 9.3. The experience was very gratifying as all users were now using SAS 9.2, and some were using SAS 9.3. We had a lively

Read More

Data Visualization

Sanjay MatangeApril 20, 2012 0

Just a legend, please

Recently, an interesting question was posed on the previous article on this blog by a reader. Can we use the new DiscreteAttrMap feature to create just a legend with specific entries, with no graph. The question was intriguing enough that I did not wait to ask - "Why?". I just got

Read More

Advanced Analytics | Data Visualization | Programming Tips

Angela HallApril 20, 2012 0

What would SAS Stored Process Key #51 be?

This past Monday, Tricia and I released our 2nd book this year. "The 50 Keys to Learning SAS Stored Processes" provides a step-by-step approach to transitioning from SAS code into user driven (prompted) stored processes. Trimming down all the things you can do with SAS Stored Processes is next to

Read More

Data Visualization

Sanjay MatangeApril 19, 2012 0

Hi ho, hi ho, its off to SASGF we go

SAS Global Forum 2012 at Orlando, Florida is just round the corner and we are excited to see so many presentations offered by users on SG procedures and GTL. We'll add a few more on new SAS 9.3 features of SG procedures and GTL. These include cluster groups for discrete and interval axes, cluster

Read More

Advanced Analytics | Data Visualization | Programming Tips

Angela HallApril 16, 2012 0

All the possible uses for PROC STP

PROC STP is a new procedure for SAS 9.3 Stored Processes. It's so new and different that I have not had the opportunity to use it yet in a customer engagement. When writing about it for the now released "The 50 Keys to Learning SAS Stored Processes" book, I had

Read More

Data Visualization

Sanjay MatangeApril 16, 2012 0

Bar chart on interval axis

Recently, a user asked about creating a Bar Chart of Value by Date, where the dates are displayed on a scaled interval axis. Consider this simulated data set of value by date and treatment shown below. This data set only has one value for each date and treatment combination. We can use the VBAR statement

Read More

Data Visualization

Sanjay MatangeApril 9, 2012 0

Simpler is better

A recent article in the SAS and R blog was about current winter temperatures in Albany, NY. The temperature data for the recent winter (Dec 2011 - Mar 2012) was plotted on a polar graph. Robert Allison posted an article on displaying the same data as a Polar Graph using SAS/GRAPH . Here is his

Read More

Data Visualization

Sanjay MatangeApril 2, 2012 0

Bar-Line graph

A user recently posted a question in the SAS communities forum about how to best display two measures by one classifier using a Bar-Line graph, where the scale of the two measures is vastly different. This got me thinking about various different ways to represent such data. Here are some of my thoughts,

Read More

Data Visualization

Sanjay MatangeMarch 30, 2012 0

Cluster groups

The topic of cluster groups comes up often. By cluster group I am referring to the feature in bar charts where the group values are displayed side by side. With SAS 9.3, SG Procedures support stack or cluster grouping for Bar Charts and overlay or cluster grouping for all other

Read More

Data Visualization

Sanjay MatangeMarch 26, 2012 0

Let them eat pie

ODS Graphics system was initially motivated by the need for high quality graphs for SAS Base, STAT, and other analytical procedures. Use of SG Procedures, ODS Graphics Designer and GTL by users too has initially focused on analytical graphs. But just like wheels on carryon bags that started for the specific needs of flight

Read More

Previous 1 … 51 52 53 54 55 Next