Blogs

Blogs

Learn SAS

Learn about the latest tips, tutorials, upcoming events and certifications

Data Visualization | Learn SAS | Programming Tips

Sanjay MatangeNovember 14, 2017 0

Spark table

In the previous post, I discussed creating a 2D grid of spark lines by Year and Claim Type. This graph was presented in the SESUG conference held last week on SAS campus in the paper ""Methods for creating Sparklines using SAS" by Rick Andrews. This grid of sparklines was actually the

Read More

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

Learn SAS | Programming Tips

Jim SimonNovember 10, 2017 0

Simple Proc Print trick for grouped data

Here's a Proc Print trick for grouped data. Suppose your data is divided into groups, such as males and females. You could sort by the grouping variable before printing, like this: Suppose you want to better emphasize the groups. You could add a BY statement, like this: OK, but, personally,

Read More

Data Visualization | Learn SAS | Programming Tips

Sanjay MatangeNovember 10, 2017 0

Spark grid

The 25th annual SESUG conference was held at in the SAS campus this week. I had the opportunity to meet and chat with many users and attend many excellent presentations. I will write about those that stood out (graphically) in my view. One excellent presentation was on "Methods for creating

Read More

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

Data Visualization | Learn SAS | Programming Tips

Sanjay MatangeNovember 8, 2017 0

Long category values

The South East SAS Users Group meeting wound up yesterday. The 25th anniversary conference was held on SAS Campus and it provided a great opportunity to meet with many enthusiastic SAS users and attend many informative presentations. More on this in a follow-up article. During one of these presentations, Mary

Read More

Communications | Health Care | Hospitality | Life Sciences | Sports & Entertainment | Travel

Learn SAS | Programming Tips

Rick WicklinNovember 8, 2017 0

How to format rows of a table in SAS

A SAS programmer wanted to display a table in which the rows have different formats. An example is shown below. The programmer wanted columns that represent statistics and rows that represent variables. She wanted to display formats (such as DOLLAR) for some variables—but only for certain statistics. For example, the

Read More

Learn SAS | Programming Tips

Natasha Ulanowski

Natasha UlanowskiNovember 6, 2017 0

SAS tips and tricks: Users-tell-all edition

There is certainly no shortage of terrific tips and tricks in various SAS blogs from some of our most distinguished SAS in-house experts. But, there's another group of equally qualified experts who don't often get to share their expertise on this channel: our customers. So, I went on a quest to get

Read More

Learn SAS | Programming Tips

Leonid BatkhanNovember 1, 2017 0

Hopping for the best - calculations across SAS dataset observations

The purpose of this blog post is to demonstrate a SAS coding technique that allows for calculations with multiple variables and multiple observations across a SAS dataset. This technique can be useful for working with time series, clinical trials, - in any data step calculations involving values from different observations.

Read More

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

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

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

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

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

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

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

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

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

Analytics | Learn SAS

Principal component regression in SAS: Loadings plot

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

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

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

Analytics | Learn SAS

Diffogram for multiple comparisons of means in 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

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

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

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

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

Analytics | Data Visualization | Learn SAS

Lines plot for multiple comparison of means in 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

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

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

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

Data Visualization | Learn SAS

Ryan Kumpfmiller

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

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

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

Previous 1 … 22 23 24 25 26 … 48 Next