Blogs

Blogs

Programming Tips

Strengthen your programming skills with tips and techniques from the experts

Advanced Analytics | Learn SAS | Programming Tips

Larry LaRussoMarch 8, 2017 0

Adding SAS Viya to your SAS 9 programming toolbox

Editor’s note: This is the first in a series of articles to help current SAS programmers add SAS Viya to their analytics skillset. In this post, SAS instructors Stacey Syphus and Marc Huber introduce you to our new Introduction to SAS Viya Programming for SAS 9 Programmers video library, designed to show SAS programmers how they can

Read More

Analytics | Data Visualization | Learn SAS | Programming Tips

Robert AllisonMarch 8, 2017 0

What's your next move? (analytics for a chess tournament)

The NC Scholastic Chess Championship is coming up this weekend, and my buddy Michael Thomas asked if I might could create a few graphs to help analyze the event data. How could I pass up an opportunity like that?!?! Read along, and find out what graphs I created, and the

Read More

Sports & Entertainment

Programming Tips

Rick WicklinMarch 8, 2017 0

Display output conditionally with PROC DOCUMENT

Suppose you have several discrete variables. You want to conduct a frequency analysis of these variables and print the results, but ONLY for variables that have three or more levels. In other words, you want to conditionally display some results, but you don't know which variables satisfy the condition until

Read More

Programming Tips

Rick WicklinMarch 6, 2017 0

Reorder the output from a BY-group analysis in SAS

After reading my article about how to use BY-group processing to run 1000 regression models, a SAS programmer asked whether it is possible to reorder the output of a BY-group analysis. The answer is yes: you can use the DOCUMENT procedure to replay a portion of your output in any

Read More

Programming Tips

Rick WicklinFebruary 27, 2017 0

Point/Counterpoint: Should a programming language accept misspelled keywords?

Longtime SAS programmers know that the SAS DATA step and SAS procedures are very tolerant of typographical errors. You can misspell most keywords and SAS will "guess" what you mean. For example, if you mistype "PROC" as "PRC," SAS will run the program but write a warning to the log:

Read More

Learn SAS | Programming Tips

Ron CodyFebruary 21, 2017 0

The Other 27 SAS Numeric Missing Values

What?!? You mean a period (.) isn't the only SAS numeric missing value? Well, there are 27 others: .A .B, to .Z and ._ (period underscore). Your first question might be: "Why would you need more than one missing value?" One situation where multiple missing values are useful involves survey data. Suppose

Read More

Data Visualization | Programming Tips

Chevell ParkerFebruary 20, 2017 0

Tips for Using the ODS Excel Destination

The SAS® Output Delivery System provides the ability to generate output in various destination formats (for example, HTML, PDF, and Excel). One of the more recent destinations, ODS Excel, became production in the third maintenance release for SAS 9.4 (TS1M3). This destination enables you to generate native Microsoft Excel formatted

Read More

Analytics | Data Visualization | Programming Tips

Teri PatsilarasFebruary 14, 2017 0

Visualization Spotlight: Visual Analytics Designer 7.3 Word Cloud

In this post I wanted to shed some light on a visualization you may not be using enough: the Word Cloud. Word association exercises can often be a fun way to pass the time with friends, or it can trigger immediate action – just think of your email inbox and

Read More

Data Visualization | Programming Tips

Warren F. KuhfeldFebruary 14, 2017 0

Basic ODS Graphics: Lines, Curves, and Fit Functions

Today's post illustrates the REG, PBSPLINE, LOESS, SERIES, and SPLINE statements in PROC SGPLOT. The GROUP= and BREAK options in the SERIES statement are also discussed.

Read More

Learn SAS | Programming Tips

Leonid BatkhanFebruary 10, 2017 0

Truncating vs rounding SAS time values

Small matters matter. Imagine saving (or spending wisely) just 1 second of your time every hour. One measly second! During your lifespan you would save or spend wisely (1 sec-an-hour * 24 hours-a-day * 365 days-a-year * 100 years) / (3600 seconds-an-hour * 24 hours-a-day) = 10 days, a whole

Read More

Programming Tips | SAS Administrators

Dave NadenFebruary 9, 2017 0

Middle Tier Changes and Upgrades in SAS 9.4 M4

Since the SAS 9.4 M2 release in December 2014, there have been several refinements and updates to the middle tier that are of interest to installers and administrators. In this blog, I’m going to summarize them for you. What I’m describing here is available in the newest SAS release (9.4 M4). I’ll

Read More

Programming Tips

Chris Hemedinger

Chris HemedingerFebruary 7, 2017 0

Tip for coding your color values in SAS Enterprise Guide

Colors are the subject of many romantic poems and songs, but there isn't much romance to be found in their hexadecimal values. With apologies to Van Morrison: ...Skipping and a jumping In the misty morning fog with Our hearts a thumpin' and you My cx662F14 eyed girl When it comes

Read More

Programming Tips

Rick WicklinFebruary 6, 2017 0

What colors does PROC SGPLOT use for markers?

Suppose you create a scatter plot in SAS with PROC SGPLOT. What color does PROC SGPLOT use for the markers? If you specify the GROUP= option so that markers are colored by a grouping variable, what colors are used to represent the various groups? The following scatter plot shows the

Read More

Data Visualization | Learn SAS | Programming Tips

Sanjay MatangeFebruary 3, 2017 0

The importance of proximity in graphing

Back in 2013, I wrote a paper for the SAS Global Forum, reviewing the attributes that go towards making a good graph. In this paper, I covered many recommendations from industry thought leaders that can help enhance the effectiveness of graphs to deliver the intended information. One of the aspects that

Read More

Banking | Health Care | Life Sciences

Programming Tips | SAS Events

John AmrheinFebruary 2, 2017 0

At SAS Global Forum, Content is King

I will begin with a short story. Like many employers, McDougall Scientific, my employer, requires its employees to review, with their co-workers and managers, what they learned at a conference or course. They are also asked to suggest applications of their learnings so that McDougall might realize value from the

Read More

Programming Tips | SAS Administrators

Mary Kathryn QueenJanuary 31, 2017 0

Securing sensitive data using SAS Federation Server at the row and column level

SAS® Federation Server provides a central, virtual environment for administering and securing access to your data. It also allows you to combine data from multiple sources without moving or copying the data. SAS Federation Server Manager, a web-based application, is used to administer SAS Federation Server(s). Data privacy is a

Read More

Data Visualization | Programming Tips

Warren F. KuhfeldJanuary 30, 2017 0

Basic ODS Graphics: Editing the Template that PROC SGPLOT Writes

PROC SGPLOT writes a graph template and uses it to create a graph. You can edit the template and then create a modified graph.

Read More

Programming Tips

Edoardo RivaJanuary 30, 2017 0

SAS Studio 3.6 new features

Recently, SAS shipped the fourth maintenance of SAS 9.4. Building on this foundation, SAS Studio reached a new milestone, its 3.6 release. All editions have been upgraded, including Personal, Basic and Enterprise. In this blog post, I want to highlight the new features that have been introduced. In subsequent posts

Read More

Programming Tips

Jim SimonJanuary 23, 2017 0

Stratified random sample: What's efficient?

In a previous blog, Random Sampling: What's Efficient?, I discussed the efficiency of various techniques for selecting a simple random sample from a large SAS dataset. PROC SURVEYSELECT easily does the job: proc surveyselect data=large out=sample method=srs /* simple random sample */ rate=.01; /* 1% sample rate */ run; Note:

Read More

Data Visualization | Programming Tips

Warren F. KuhfeldJanuary 23, 2017 0

Basic ODS Graphics: Axis Tables

I review some fundamental principles of creating axis tables along with graphs that have TYPE=LINEAR or TYPE=DISCRETE axes.

Read More

Programming Tips

Rick WicklinJanuary 23, 2017 0

Five reasons to check out the new SAS analytical documentation

The SAS analytical documentation has a new look. Beginning with the 14.2 release of the SAS analytical products (which shipped with SAS 9.4m4 in November 2016), the HTML version of the online documentation has moved to a new framework called the Help Center. The URL for the online documentation is

Read More

Programming Tips

Lelia McConnellJanuary 20, 2017 0

Comparing SAS/GRAPH® 9.4 capabilities with SAS/GRAPH® Version 6

I remember my grandparents talking about how hard things were for them growing up. They would say, “Things were so bad that we had to walk uphill, both ways, in the freezing snow to get to school.” It was always hard for me to relate to these statements because the

Read More

Programming Tips

Rick WicklinJanuary 16, 2017 0

PUT it there! Six tips for using PUT and %PUT statements in SAS

For SAS programmers, the PUT statement in the DATA step and the %PUT macro statement are useful statements that enable you to display the values of variables and macro variables, respectively. By default, the output appears in the SAS log. This article shares a few tips that help you to

Read More

Data Visualization | Programming Tips

Warren F. KuhfeldJanuary 11, 2017 0

Advanced ODS Graphics: Axis tables in PROC SGPLOT and the GTL

Axis tables enable you to combine tabular and graphical information into a single display. I love axis tables. My involvement with axis tables dates back over 30 years to their ancient predecessor, the table that contains an ASCII bar chart. In the mid 1980s, I created a table in PROC

Read More

Programming Tips

Rick WicklinJanuary 11, 2017 0

Ten posts from 2016 that deserve a second look

Last week I wrote about the 10 most popular articles from The DO Loop in 2016. The popular articles tend to be about elementary topics that appeal to a wide range of SAS programmers. Today I present an "editor's choice" list of technical articles that describe more advanced statistical methods

Read More

Learn SAS | Programming Tips

Rick WicklinJanuary 9, 2017 0

ODS OUTPUT: Store any statistic created by any SAS procedure

In the beginning, SAS created procedures and output. The output was formless and void. Then SAS said, "Let there be ODS," and there was ODS. Customers saw that ODS was good, and SAS separated the computation from the display and management of output. The preceding paragraph oversimplifies the SAS Output

Read More

Programming Tips

Chris Hemedinger

Chris HemedingerJanuary 5, 2017 0

Reporting on GitHub accounts with SAS

At SAS, we've published more repositories on GitHub as a way to share our open source projects and examples. These "repos" (that's Git lingo) are created and maintained by experts in R&D, professional services (consulting), and SAS training. Some recent examples include: sas_kernel, which provides Jupyter notebook support for SAS.

Read More

Programming Tips

Rick WicklinJanuary 4, 2017 0

The top 10 posts from The DO Loop in 2016

I wrote 105 posts for The DO Loop blog in 2016. My most popular articles were about data analysis, SAS programming tips, and elementary statistics. Without further ado, here are the most popular articles from 2016. Data Analysis and Visualization Start with a juicy set of data and an interesting

Read More

Learn SAS | Programming Tips

Ron CodyJanuary 3, 2017 0

Character to Numeric Conversion in SAS

How many of you have been given a SAS data set with variables such as Age, Height, and Weight and some or all of them were stored as character values instead of numeric? Probably EVERYONE! Yes, we all know how to do the old "swap and drop" (rename and convert), but

Read More

Learn SAS | Programming Tips

SAS JediDecember 28, 2016 0

SAS Jedi Christmas - SAS 9.4 M4 DS2 Do Loop Upgrade

This SAS Jedi is very excited about the SAS 9.4 M4 release, which brought many wonderful gifts just in time for Christmas. So in the interest of extending the Christmas spirit, I'm going to blog about some of my favorites! I've long loved the SAS DO statement variant which allows

Read More

Previous 1 … 43 44 45 46 47 … 64 Next