Blogs

Blogs

Data Visualization

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

Advanced Analytics | Data Visualization | Programming Tips

Angela HallSeptember 12, 2012 0

Defining a custom color palette for BI Dashboard bar charts

Out of the box, the simple bar graph uses the same color for each bar. A frequent request from users is to define a standard color palette for the dashboard indicators so distinct bars are the same color in each indicator or from refresh to refresh. With most dashboard tricks,

Read More

Analytics | Data Visualization

Robert AllisonSeptember 6, 2012 0

What cities have the worst (and best) commute to work?

A while back, I had seen the following map on the CEOs for Cities website. It seemed like an interesting topic and an interesting map, but I just couldn't grok what their map was saying ... So I decided to download the data and create my own map with SAS. I

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

Analytics | Data Visualization

Robert AllisonAugust 28, 2012 0

Browser wars: And the winner is ...

Have you ever tried to put something on the Web, and then it looks different for other people (or maybe doesn't work at all)? ... And you eventually found that it was because they were using a different browser? That's one of the reasons I like traditional SAS/Graph output -- it's simple

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

Advanced Analytics | Data Visualization | Programming Tips

Angela HallAugust 8, 2012 0

Testing recommendations for SAS BI Dashboard & SAS Web Report Studio

With limited time and budget, you can still thoroughly test SAS reports built in SAS BI Dashboard and SAS Web Report Studio by considering how all the tools were used to build the end report. An understanding of the functionality within each part of the chain from raw data to

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 21, 2012 0

Use OLAP data sources from SAS Stored Processes

So are you now dreaming big? Coming up with other ideas for how SAS Stored Processes can be leveraged in your installation of SAS? As I mentioned in last week's post, you could use OLAP cubes as a data source for your SAS Stored Process. Here is how I would

Read More

Advanced Analytics | Data Visualization | Programming Tips

Angela HallJune 20, 2012 0

I have doubts

One of my new work friends says this frequently. But the statement is lost in his translation from Portuguese, it is not that he does not believe me, it is just that he has questions about how things happen so he can learn. I debate on which version of this

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

Advanced Analytics | Data Visualization | Programming Tips

Angela HallJune 15, 2012 0

And the difference between Business Intelligence and Business Analytics is ...

After some discussion with SAS Product Marketing yesterday, we devised this response to everyone's question about the Business Analytic differentiator that SAS provides. ********************************************************************************************************* Business Intelligence is one of the key components from SAS that ties into a suite of analytic techniques, information handling and performance infrastructures needed to deliver

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 14, 2012 0

Any SAS program can become a SAS Stored Process

Questions (or search strings) lead people to my blog or my email box on a daily basis and many of these are related to what SAS Stored Processes can or cannot do. Can a SAS Stored Process query an RDBMS? Can a SAS Stored Process create a data table? Could

Read More

Advanced Analytics | Data Visualization | Programming Tips

Angela HallJune 13, 2012 0

Leverage metadata user synchronization macros for other uses

Six user import and synchronization macros are available in the SAS Foundation directory, these are documented as available in creating programs to retrieve information and compare authentication provider (such as LDAP) account information with what is stored in SAS Metadata to then synchronize the two. Try this code in BASE

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

Previous 1 … 53 54 55 56 57 … 60 Next