Blogs

Blogs

Programming Tips

Strengthen your programming skills with tips and techniques from the experts

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 | Programming Tips

Rick WicklinOctober 30, 2017 0

A SAS programming technique to modify ODS templates

This article demonstrates a SAS programming technique that I call Kuhfeld's template modification technique. The technique enables you to dynamically modify an ODS template and immediately call the modified template to produce a new graph or table. By following the five steps in this article, you can implement the technique

Read More

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

Advanced Analytics | Programming Tips

Ryan LolliOctober 26, 2017 0

Tip and tricks to promote CAS tables from session-scope to global-scope

When loading data into CAS using PROC CASUTIL, you have two choices on how the table can be loaded: session-scope or global-scope. This is controlled by the PROMOTE option in the PROC CASUTIL statement. Session-scope loaded proc casutil; load casdata="model_table.sas7bdat" incaslib="ryloll" outcaslib="otcaslib" casout="model_table”; run; Global-scope loaded proc casutil; load casdata="model_table.sas7bdat"

Read More

Analytics | Data Visualization | Programming Tips

Robert AllisonOctober 26, 2017 0

Which country has the most powerful passport?

If you plan to travel abroad and see the world, you'll need a passport. And, depending on several factors, you might also need travel visas. Which passports allow you to travel with the least amount of hassle (and the least amounts of visas)? Let's create a map to help you

Read More

Government | Travel

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 | Programming Tips

Warren F. KuhfeldOctober 25, 2017 0

Advanced ODS Graphics: Curve labels and date axes

Curve labels in series plots can be positioned inside or outside the graph. Date variables can be specified as TYPE=LINEAR with a date format or more commonly as TYPE=DATE. Sometimes external curve labels might appear below or above the graph, particularly with TYPE=DATE axes. This post shows you ways to move them to the right of the graph.

Read More

Analytics | Data Visualization | Programming Tips

Robert AllisonOctober 24, 2017 0

Do you say coke, pop, or soda?

Quick Quiz! Where might you hear the following conversation? ... Waitress: "What would you like to drink, honey?" Customer: "I'll have a coke." Waitress: "What kind?" Customer: "Diet Pepsi." If you answered somewhere between Texas and Georgia, you would be correct! To those of us not from that area, it

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

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

Advanced Analytics | Programming Tips | SAS Administrators

Phil WeissOctober 20, 2017 0

Top 12 Advantages of SAS Viya

There are many compelling reasons existing SAS users might want to start integrating SAS Viya into their SAS9 programs and applications. For me, it comes down to ease-of-use, speed, and faster time-to-value. With the ability to traverse the (necessarily iterative) analytics lifecycle faster than before, we are now able to generate

Read More

Programming Tips

Amber ElamOctober 20, 2017 0

Tips for using the IMPORT procedure to read files that contain delimiters

Reading an external file that contains delimiters (commas, tabs, or other characters such as a pipe character or an exclamation point) is easy when you use the IMPORT procedure. It's easy in that variable names are on row 1, the data starts on row 2, and the first 20 rows

Read More

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

Data Visualization | Programming Tips

Warren F. KuhfeldOctober 19, 2017 0

Fun with ODS Graphics: Drawing and rotating an impossible triangle

I hope everyone has noticed some new shortcuts in Graphically Speaking. As you scroll down and look to the right, there are shortcuts for Sanjay's getting started and clinical graphs posts and one for my advanced blogs. When Sanjay asked me to make an icon for my advanced blogs, at

Read More

Analytics | Data Visualization | Programming Tips

Robert AllisonOctober 17, 2017 0

RDU airport -vs- surrounding parks and nature

In growing areas such as the Research Triangle Park, there is always the tough decision between developing land for business, or keeping it natural for parks and recreation. SAS is fortunate to have the great hiking trails at Umstead Park just across the road to the north - it's the

Read More

Sports & Entertainment | Travel

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

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

Data Visualization | Programming Tips

Warren F. KuhfeldOctober 12, 2017 0

Advanced ODS Graphics: Two types of axis tables

Axis tables can use the SUM= option to summarize data and display means, medians, sums, and percentages. They can instead be used to display data, text, and statistics without any summarization.

Read More

Analytics | Data Visualization | Programming Tips

Robert AllisonOctober 11, 2017 0

Scottish Festivals and Highland Games

I recently took a trip to Scotland, to attend the Highland Games! (ok - that statement might be a tiny bit misleading) It was a very cool and interesting event, and I wondered where and when other such events might be happening. What better way to analyze this kind of

Read More

Sports & Entertainment | Travel

Programming Tips

Rick WicklinOctober 11, 2017 0

Simulate correlations by using the Wishart distribution

The article "Fisher's transformation of the correlation coefficient" featured a Monte Carlo simulation that generated sample correlations from bivariate normal data. The simulation used three steps: Simulate B samples of size N from a bivariate normal distribution with correlation ρ. Use PROC CORR to compute the sample correlation matrix for

Read More

Programming Tips

Chris Hemedinger

Chris HemedingerOctober 10, 2017 0

Reading and writing GZIP files with SAS

SAS 9.4 Maintenance 5 includes new support for reading and writing GZIP files directly. GZIP files, usually found with a .gz file extension, are a different format than ZIP files. Although both are forms of compressed files, a GZIP file is usually a compressed copy of a single file, whereas

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

Programming Tips

Heat map of correlations between variables

Rick WicklinOctober 9, 2017 0

Order correlations by magnitude

Correlations between variables are typically displayed in a matrix. Because the correlation matrix is determined by the order of the variables, it is difficult to find the largest and smallest correlations, which is why analysts sometimes use colors to visualize the correlation matrix. Another visualization option is the pairwise correlation

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

Data Visualization | Programming Tips

Warren F. KuhfeldOctober 4, 2017 0

Introducing the new SAS/STAT lines plot

In PROC GLM and most other procedures that compute LS-means, mean comparisons are now displayed graphically. This makes comparisons between a large number of groups easier to interpret.

Read More

Analytics | Data Visualization | Programming Tips

Robert AllisonOctober 3, 2017 0

Trends in U.S. refugee admissions

"Coming to America" - it's been the name of a funny movie and a dramatic song (can you name the actor & singer without cheating?!?) It's also been a dream for many, and an action for some. People have been coming to America both legally and illegally for many years, but there's one special category

Read More

Government | Travel

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

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

Data Visualization | Programming Tips

Warren F. KuhfeldSeptember 29, 2017 0

Advanced ODS Graphics: Monotonic functions

This post shows how to use PROC SGPLOT together with PROC TRANSREG to fit monotonically increasing or decreasing functions through a scatter plot.

Read More

Analytics | Data Visualization | Programming Tips

Robert AllisonSeptember 27, 2017 0

Most popular international destination, from each US state

Orbitz recently published a map showing the most popular international travel destination for each of the 50 US states. It was an interesting map ... but of course, me being the Graph Guy, I had to pick it apart and create my own version. Follow along, and explore this interesting

Read More

Previous 1 … 37 38 39 40 41 … 64 Next