Blogs

Blogs

Data Visualization

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

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

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

Advanced Analytics | Data Visualization | Programming Tips

Angela HallApril 30, 2012 0

Mobile is available for all SAS programmers

During the SAS Global Forum this past week, SAS offered several demos on mobile technology including: Michael Hecht, SAS, JMP iPad App Super Demo Chris Hemedinger hosted a Live Tech Talk on Tuesday that covered the new SAS Visual Analytics Explorer with demos on Microsoft Surface and iPad Apps Remember everyone is using mobile devices

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

Advanced Analytics | Data Visualization | Programming Tips

Angela HallApril 27, 2012 0

The things I missed at #SASGF12

Unfortunately, my clone attempt didn't work like Chris Hemedinger's did. With all my papers, presentations, and demo hall duties, I realized yesterday that I certainly missed a lot. Included is my to-do list for items to watch and catch up on this weekend. Not really sure how I missed the

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

Advanced Analytics | Data Visualization | Programming Tips

Angela HallApril 25, 2012 0

SAS Talks Backstage Sneak Peek: Soft skills required for BI developers

Whether you call it Business Intelligence, Business Analytics, Visual Analytics, etc. - getting information to the users when they need it and make it actionable requires more than just software. BI Content Developers can have a certification but to be successful they really need to have an understanding of human

Read More

Previous 1 … 53 54 55 56 57 … 59 Next