Data Visualization | Learn SAS | Programming Tips

Sanjay MatangeNovember 1, 2017 0

Legend order redux

Once in a while you run into a pesky situation that is hard to overcome without resorting to major surgery.  Such a situation occurs when you have a stacked bar chart with a discrete legend positioned vertically on the side of the graph.  A simple example is shown below. title

Read More

English

Banking | Education | Energy & Utilities | Government | Health Care | Hospitality | Insurance | Life Sciences | Manufacturing | Retail

Learn SAS | Programming Tips

Charu ShankarOctober 31, 2017 0

3 freaky ways PROC FREQ can work in your favor

A ghoulish Halloween Boo to all my readers! Hope my costume freaks you out, but even if it doesn't, I’m positive PROC FREQ will in a few amazing ways! Today’s Programming 2: Data Manipulation Techniques class asked about the power of PROC FREQ. Since I stopped to explain some of it's benefits to

Read More

English

Learn SAS

SAS JediOctober 31, 2017 0

Jedi SAS Tricks: The %PATHNAME to Enlightenment

I often create temporary ODS output files - and getting rid of those files after I'm done is an extra chore I don't relish. For example, if I want to generate a PDF-only report and email it from SAS (see "Jedi SAS Tricks: Email from the Front – Part 2")

Read More

English

Data Visualization | Learn SAS | Programming Tips

Sanjay MatangeOctober 30, 2017 0

Fill patterns

When a plot is classified by one or more variables, the different classes values are displayed in the graph either by position or by using different plot attributes such as color, marker shape or line pattern.  For plots that display the visual by a filled area (bar, bin, band, bubble,

Read More

English

Government | Health Care | Insurance | Life Sciences

Data Visualization | Learn SAS | Programming Tips

Sanjay MatangeOctober 27, 2017 0

Legend items

Plot statements included in the graph definition can contribute to the legend(s).  This can happen automatically, or can be customized using the KEYLEGEND statement.  For plot statements that are classified by a group variable, all of the unique group values are displayed in the legend, along with their graphical representation

Read More

English

Banking | Communications | Education | Energy & Utilities | Government | Health Care | Insurance | Life Sciences | Manufacturing | Retail

Learn SAS

Larry LaRussoOctober 25, 2017 0

SAS Help Center: Your gateway to documentation

To improve is to change; to be perfect is to change often.-Winston Churchill If you've visited SAS documentation (also known as the "SAS Help Center") lately, you may have noticed that we've made some fairly significant changes in the documentation for SAS products and solutions. The new site is organized in a new way, search

Read More

English

Learn SAS | Programming Tips

Jim SimonOctober 25, 2017 0

Finding your Dream Car with a little macro magic

Suppose you want a list of car manufacturers from the CARS dataset. Easy!  Call the %CHARLIST macro from a %PUT statement, like this: The CHARLIST macro generates a list of unique values of a selected variable from a selected dataset. So does PROC FREQ. But, if you don't need statistics, the CHARLIST

Read More

English

Data Visualization | Learn SAS | Programming Tips

Sanjay MatangeOctober 23, 2017 0

Turnip plot redux

Last year, a user asked about creating a "Turnip Plot" as used in this study of Caesarian Section Rates.  Primarily, this is similar to a histogram on the y-axis for each unique value on the y-axis.  A marker is drawn for each occurrence, starting from the center. Back then, I

Read More

English

Banking | Government | Health Care | Hospitality | Insurance | Life Sciences | Manufacturing

Analytics | Learn SAS

Rick WicklinOctober 23, 2017 0

Principal component regression in SAS

A common question on discussion forums is how to compute a principal component regression in SAS. One reason people give for wanting to run a principal component regression is that the explanatory variables in the model are highly correlated which each other, a condition known as multicollinearity. Although principal component

Read More

English

Data Visualization | Learn SAS | Programming Tips

Sanjay MatangeOctober 22, 2017 0

Tips and tricks: Segmented discrete axis

The previous post on Multiple Blank Categories showed how to include multiple blank categories on the axis.  But, given the purpose for this was to separate different segments in the data, I also included ideas on how to segmented a discrete axis using reference lines or Block Plot.  A similar idea

Read More

English

Banking | Communications | Education | Energy & Utilities | Government | Health Care | Hospitality | Insurance | Life Sciences | Manufacturing | Retail | Sports & Entertainment

Learn SAS | Programming Tips | SAS Administrators

Leonid BatkhanOctober 20, 2017 0

Creating reports in style with SAS Enterprise Guide

  “The difference between style and fashion is quality.” -Giorgio Armani With an out-of-the-box SAS Enterprise Guide (EG) installation, when you build a report in SAS EG it is displayed in a nice-looking default style. If you like it, you can keep it, and continue reading. If you don’t quite

Read More

English

Analytics | Learn SAS

Rick WicklinOctober 18, 2017 0

The diffogram and other graphs for multiple comparisons of means

In a previous article, I discussed the lines plot for multiple comparisons of means. Another graph that is frequently used for multiple comparisons is the diffogram, which indicates whether the pairwise differences between means of groups are statistically significant. This article discusses how to interpret a diffogram. Two related plots

Read More

English

Analytics | Learn SAS

Rick WicklinOctober 18, 2017 0

The diffogram and other graphs for multiple comparisons of means

In a previous article, I discussed the lines plot for multiple comparisons of means. Another graph that is frequently used for multiple comparisons is the diffogram, which indicates whether the pairwise differences between means of groups are statistically significant. This article discusses how to interpret a diffogram. Two related plots

Read More

English

Learn SAS

Matt ScicchitanoOctober 17, 2017 0

Share your SAS Certification experience and maximize value

You know the value of your SAS Certification; does the rest of the world? A recent MONEY and Payscale.com study named SAS Analytics skills as the most valuable skills to have in today’s job market and certification is the best way to demonstrate those skills. Recognition like this helps solidify

Read More

English

Data Visualization | Learn SAS | Programming Tips

Sanjay MatangeOctober 16, 2017 0

Tips and tricks - Multiple blank categories on axis

Off and on, users have expressed the need to include multiple blank categories on a discrete axis.  Often, this is desirable to separate groups of bars (or categories) in a graph due to some difference their definition.  Such a case was discussed in this blog article on using non breaking

Read More

English

Banking | Communications | Education | Energy & Utilities | Government | Health Care | Hospitality | Insurance | Life Sciences | Manufacturing | Retail | Sports & Entertainment | Travel

Learn SAS | Programming Tips

Jim SimonOctober 16, 2017 0

How to format a macro variable

Would you like to format your macro variables? Easy!  Just use the %FORMAT function, like this: What?! You never heard of the %FORMAT function? Of course not, cuz it doesn't exist! No problem. Just create it, like this: %macro format(value,format); %if %datatyp(&value)=CHAR %then %sysfunc(putc(&value,&format)); %else %left(%qsysfunc(putn(&value,&format))); %mend format; The %FORMAT

Read More

English

Analytics | Data Visualization | Learn SAS

Rick WicklinOctober 16, 2017 0

Graphs for multiple comparisons of means: The lines plot

Last week Warren Kuhfeld wrote about a graph called the "lines plot" that is produced by SAS/STAT procedures in SAS 9.4M5. (Notice that the "lines plot" has an 's'; it is not a line plot!) The lines plot is produced as part of an analysis that performs multiple comparisons of

Read More

English

Data Visualization | Learn SAS | Programming Tips

Sanjay MatangeOctober 14, 2017 0

New Features in SAS 9.40M5 - Gradient fills

ODS Graphics procedures primarily strive towards the following goal:  "Make simple graphs easy and complex graphs possible".   SGPLOT procedure allows you create simple graphs with a single plot statement, and create complex graphs by layering together or combining multiple plot statements.  Generally, the appearance follows the guidelines set by industry

Read More

English

Banking | Communications | Education | Energy & Utilities | Government | Health Care | Hospitality | Insurance | Manufacturing | Retail | Sports & Entertainment | Travel

Analytics | Learn SAS

Jeff ZeanahOctober 11, 2017 0

Transforming Analytics into an Art Form

As analytics advances into more areas of our everyday life there is an increased need to understand just what it is that analytics is accomplishing for us.  I find there is a quicker acceptance of an analytical solution and even excitement if there is a good conceptual understanding of what

Read More

English

Data Visualization | Learn SAS | Programming Tips

Warren F. KuhfeldOctober 9, 2017 0

Advanced ODS Graphics: Axis tables that contain special characters

This post provides a general macro that enables you to easily display special characters (Unicode) in axis table columns.

Read More

English

Data Visualization | Learn SAS

Ryan KumpfmillerOctober 9, 2017 0

An introduction to SAS Visual Analytics: the Parallel Period function of the Derived Item calculations

My new SAS Press book “An Introduction to SAS Visual Analytics” (written in collaboration with Tricia Aanderud and Rob Collum) covers all of the different aspects of SAS® Visual Analytics, including how to develop reports, load data, and handle administration. Below is an example of the types of tips that you can find

Read More

English

Data Visualization | Learn SAS | Programming Tips

Sanjay MatangeOctober 6, 2017 0

New features with SAS 9.40 M5

SAS 9.4 maintenance release 5 was released on Sept 19, 2017.  This release includes many new items including integration with SAS Viya and SAS Studio, a web application for SAS development.  Also Included with this release are some cool new features in the graphics domain, some of which were requested

Read More

English

Banking | Energy & Utilities | Government | Health Care | Hospitality | Insurance | Life Sciences | Manufacturing | Retail | Travel

Learn SAS

Larry LaRussoOctober 5, 2017 0

Learning in the middle of the night - or whenever

Sometimes life is just too busy, and I bet many of you feel the same way. If you’re like me, you’re playing a number of roles: employee, spouse, parent, community leader, coach and so on. With all the craziness, it’s likely we’re shortchanging another role that’s critically important to our

Read More

English

Analytics | Data Visualization | Learn SAS

Rick WicklinOctober 4, 2017 0

Create and interpret a weighted histogram

If you perform a weighted statistical analysis, it can be useful to produce a statistical graph that also incorporates the weights. This article shows how to construct and interpret a weighted histogram in SAS. How to construct a weighted histogram Before constructing a weighted histogram, let's review the construction of

Read More

English

Analytics | Learn SAS

Rick WicklinOctober 2, 2017 0

How to understand weight variables in statistical analyses

How can you specify weights for a statistical analysis? Hmmm, that's a "weighty" question! Many people on discussion forums ask "What is a weight variable?" and "How do you choose a weight for each observation?" This article gives a brief overview of weight variables in statistics and includes examples of

Read More

English

Analytics | Data Visualization | Learn SAS | Programming Tips

Sanjay MatangeOctober 1, 2017 0

Getting started with SGPLOT - Part 8 - Horizontal HighLow Plot

On a recent visit to an In-House Users Group meeting at a Pharmaceutical company, I presented a 1/2 day seminar on creating Clinical Graphs using SG Procedures.  Polling the audience for their experience with these procedures indicated that many SAS users are not familiar with these new ways to create graphs. So,

Read More

English

Banking | Communications | Education | Energy & Utilities | Government | Health Care | Hospitality | Insurance | Life Sciences | Manufacturing | Retail | Sports & Entertainment

Learn SAS | Programming Tips

Rick WicklinSeptember 27, 2017 0

Data-driven simulation

In a large simulation study, it can be convenient to have a "control file" that contains the parameters for the study. My recent article about how to simulate multivariate normal clusters demonstrates a simple example of this technique. The simulation in that article uses an input data set that contains

Read More

Analytics | Learn SAS

Rick WicklinSeptember 20, 2017 0

Fisher's transformation of the correlation coefficient

Pearson's correlation measures the linear association between two variables. Because the correlation is bounded between [-1, 1], the sampling distribution for highly correlated variables is highly skewed. Even for bivariate normal data, the skewness makes it challenging to estimate confidence intervals for the correlation, to run one-sample hypothesis tests ("Is

Read More

English

Data Visualization | Learn SAS | Programming Tips

Warren F. KuhfeldSeptember 18, 2017 0

Advanced ODS Graphics: Inserting a graph into a graph

You can use SG Annotation (and its GTL equivalent) to display one graph inside another.

Read More

English

Data Visualization | Learn SAS

Rick WicklinSeptember 18, 2017 0

The path of zip codes

Toe bone connected to the foot bone, Foot bone connected to the leg bone, Leg bone connected to the knee bone,...              — American Spiritual, "Dem Bones" Last week I read an interesting article on Robert Kosara's data visualization blog. Kosara connected the geographic centers of the US zip codes in

Read More

English