Blogs

Blogs

Programming Tips

Strengthen your programming skills with tips and techniques from the experts

Learn SAS | Programming Tips

Kathryn McLawhornJuly 19, 2018 0

Keeping the top frequency count (n) for each character variable in a SAS data set

Which character variables have the highest frequency count? You can easily determine this using a variety of procedures that calculate frequency count. For example, the FREQ Procedure or the MEANS Procedure. This blog post illustrates this process through two examples.

Read More

Advanced Analytics | Programming Tips

Donut chart of cluster samples

Emily GaoJuly 18, 2018 0

How to sample textual data with SAS

See how to sample unstructured (text) data using SAS Viya and CAS actions. This post includes complete code to cluster the text documents via k-means, and treats the cluster memberships as strata for analysis.

Read More

Programming Tips

Rick WicklinJuly 18, 2018 0

Balanced bootstrap resampling in SAS

This article shows how to implement balanced bootstrap sampling in SAS. The basic bootstrap samples with replacement from the original data (N observations) to obtain B new samples. This is called "uniform" resampling because each observation has a uniform probability of 1/N of being selected at each step of the

Read More

Data Management | Learn SAS | Programming Tips | SAS Administrators

Leonid BatkhanJuly 17, 2018 0

SAS administrators tip: Automatically deleting old SAS logs

SAS batch jobs can generate many log files that accumulate over time. In this post, we present a SAS program that cleans up old log files on your system.

Read More

Data Visualization | Programming Tips

Rick WicklinJuly 16, 2018 0

Offset regions: Find all points within a specified distance from a polygon

My colleague Robert Allison recently blogged about using the diameter of Texas as a unit of measurement. The largest distance across Texas is about 801 miles, so Robert wanted to find the set of all points such that the distance from the point to Texas is less than or equal

Read More

Data Visualization | Programming Tips

Warren F. KuhfeldJuly 13, 2018 0

Advanced ODS Graphics: PROC SGPLOT, BY groups, and SG annotation

You can use PROC SGPLOT, BY variables, and a SG annotation data set together to put separate annotations into each BY group. However, you need two more steps to make it happen. This post shows all of the steps necessary to put different annotations into each graph when you have a BY variable.

Read More

Analytics | Data Visualization | Programming Tips

Robert AllisonJuly 12, 2018 0

How old is your county?

The United States declared independence in 1776, and we celebrate it on July 4th every year. But the land areas that make up the United States today weren't necessarily the same as they were back then. So I thought it would be interesting to create a map showing when each

Read More

Government | Travel

Advanced Analytics | Programming Tips

Emily GaoJuly 12, 2018 0

How to calculate Word Mover's Distance with SAS

Word Mover's Distance (WMD) is a distance metric used to measure the dissimilarity between two documents, and its application in text analytics was introduced by a research group from Washington University in 2015. The group's paper, From Word Embeddings To Document Distances, was published on the 32nd International Conference on Machine

Read More

Programming Tips

Rick WicklinJuly 11, 2018 0

The probability that two random chords of a circle intersect

In a previous article, I showed how to find the intersection (if it exists) between two line segments in the plane. There are some fun problems in probability theory that involve intersections of line segments. One is "What is the probability that two randomly chosen chords of a circle intersect?"

Read More

Analytics | Programming Tips

Rick WicklinJuly 9, 2018 0

The intersection of two line segments

Back in high school, you probably learned to find the intersection of two lines in the plane. The intersection requires solving a system of two linear equations. There are three cases: (1) the lines intersect in a unique point, (2) the lines are parallel and do not intersect, or (3)

Read More

Programming Tips

Chris Hemedinger

Chris HemedingerJuly 5, 2018 0

Using %IF-%THEN-%ELSE in SAS programs

SAS programmers have long wanted the ability to control the flow of their SAS programs without having to resort to complex SAS macro programming. With SAS 9.4 Maintenance 5, it's now supported! You can now use %IF-%THEN-%ELSE constructs in open code. This is big news -- even if it only

Read More

Advanced Analytics | Programming Tips

Emily GaoJuly 5, 2018 0

How to get N-grams and TF-IDF count from Chinese documents

SAS Visual Text Analytics provides dictionary-based and non-domain-specific tokenization functionality for Chinese documents, however sometimes you still want to get N-gram tokens. This can be especially helpful when the documents are domain-specific and most of the tokens are not included into the SAS-provided Chinese dictionary. What is an N-gram? An

Read More

Analytics | Programming Tips

Rick WicklinJuly 5, 2018 0

Compute derivatives for nonparametric regression models

SAS enables you to evaluate a regression model at any location within the range of the data. However, sometimes you might be interested in how the predicted response is increasing or decreasing at specified locations. You can use finite differences to compute the slope (first derivative) of a regression model.

Read More

Analytics | Data Visualization | Programming Tips

Robert AllisonJuly 2, 2018 0

When will women control state legislatures?

In FiveThirtyEight's Significant Digits section, they recently mentioned that nine states could potentially have 50% or more females in their legislature after the upcoming election. My first thought - I need to see some graphs! They linked to a New York Times article that had some interesting graphs. There was

Read More

Data Visualization | Internet of Things | Programming Tips | Work & Life at SAS

snackbot feature

Chris Hemedinger

Chris HemedingerJuly 2, 2018 0

The Internet of Snacks: SnackBot data and what it reveals about SAS life

At SAS, we love data. Data is central to our corporate vision: to transform a world of data into a world of intelligence. We're also famous for enjoying M&Ms, but to us they are more than a sweet snack. They're also another source of data. My colleague Pete Privitera, with

Read More

Data Visualization | Learn SAS | Programming Tips

Jim SimonJune 29, 2018 0

Custom Maps in SAS Visual Analytics: My Neighborhood

The Geo Map Visualization has several built-in geographical units, including country and region names and codes, US state names and codes, and US zip codes. You can also define your own geographic units. This paper describes how to identify any geographic point of interest, or collection of points, on a map to create custom maps in SAS.

Read More

Analytics | Data Visualization | Programming Tips

Robert AllisonJune 28, 2018 0

What's the electricity bill for your air conditioner this summer?

During these hot summers in the southern US, many people regard Willis Carrier (the man who invented modern air conditioning) as a saint. But along with the comfortable indoor temperatures comes the high electricity bill at the end of the month. And how much does the electricity cost? That's a difficult

Read More

Energy & Utilities

Analytics | Programming Tips

Rick WicklinJune 27, 2018 0

Reduced models: A way to choose initial parameters for a mixed model

This article describes how to obtain an initial guess for nonlinear regression models, especially nonlinear mixed models. The technique is to first fit a simpler fixed-effects model by replacing the random effects with their expected values. The parameter estimates for the fixed-effects model are often good initial guesses for the

Read More

Data Visualization | Programming Tips

Robert AllisonJune 26, 2018 0

Coming to America ... from Mexico

One of my favorite Eddie Murphy movies when I was growing up was Coming to America. And speaking of coming to America, there's been a lot in the news recently about people doing just that. So I thought I'd use my SAS skills to help people wanting to come to

Read More

Government | Travel

Data Visualization | Learn SAS | Programming Tips

Sanjay MatangeJune 25, 2018 0

Pie Charts Redux

It seems only a few months back I posted an article on creating Pie Charts using a GTL based macro. Well, looking back, that was almost 6 years ago!! Recently, a colleague here at SAS needed to create Pie Charts in his report along with other plots created using SGPLOT

Read More

Learn SAS | Programming Tips

Jody CarltonJune 22, 2018 0

A transcoding story (or, How Oliver S. Füßling lost his last name and comes to find it again)

There are many ways to avoid transcoding problems when you have national language characters in SAS programs that you save from a SAS®9 (English) session and move to a UTF-8 environment. In this article, we'll share tips to help you avoid such issues.

Read More

Programming Tips

Steven SoberJune 21, 2018 0

How to reference CAS tables using a one-level name

To reference CAS tables using a one-level name we will issue two statements that alter which libref houses the tables referenced as one-level names.

Read More

Analytics | Data Visualization | Programming Tips

Robert AllisonJune 21, 2018 0

Tableplots and ACS data

A question recently popped up in a discussion forum about creating table plots using SAS. So I thought I'd dabble in this topic, and see what I could come up with. If you're interested in tableplots, or American Community Survey (ACS) data, or data visualization, I invite you to follow

Read More

Learn SAS | Programming Tips

Excel named range

Chris Hemedinger

Chris HemedingerJune 21, 2018 0

How to use SAS to read a range of cells from Excel

I've said it before: spreadsheets are not databases. However, many of us use spreadsheets as if they were databases, and then we struggle when the spreadsheet layout does not support database-style rigor of predictable rows, columns, and variable types -- the basic elements we need for analytics and reporting. If

Read More

Analytics | Programming Tips

Rick WicklinJune 20, 2018 0

The bootstrap method in SAS: A t test example

A previous article provides an example of using the BOOTSTRAP statement in PROC TTEST to compute bootstrap estimates of statistics in a two-sample t test. The BOOTSTRAP statement is new in SAS/STAT 14.3 (SAS 9.4M5). However, you can perform the same bootstrap analysis in earlier releases of SAS by using

Read More

Programming Tips

Stephen FoersterJune 19, 2018 0

Threads and CAS DATA Step

Cloud Analytic Services (CAS) is really exciting. It’s open, multi-threaded and distributed. And, best of all for SAS programmers, it’s SAS. You can even run DATA Step in CAS. Here's more on how DATA Step work in a multi-threaded, distributed context.

Read More

Learn SAS | Programming Tips

Allison SaitoJune 18, 2018 0

Changing font size in SAS

When making a new piece of code, I like to use the smallest font I can read. This lets me fit more text on the screen at once. When presenting code to others, especially in a classroom setting, I like to make the font large enough to see from the back of the room. Here’s how I change font size in SAS in our three programming interfaces.

Read More

Analytics | Data Visualization | Programming Tips

Robert AllisonJune 18, 2018 0

SAS analytics for the Gorge Downwind Champs race

Ever since the Moneyball book & movie came out, athletes have been scrambling to use data and analytics to gain a competitive advantage. One of my favorite sports is boat racing - the ones you paddle. Follow along as I lead you through some maps and graphs I created for

Read More

Sports & Entertainment

Analytics | Data Visualization | Programming Tips

Robert AllisonJune 15, 2018 0

Cremation rates in the US, by state

I recently read an interesting article that claims "a single cremation emits as much carbon dioxide as a 1,000-mile car trip." This got me wondering about cremation data, and I ended up on the Wikipedia page about cremation rates. They had a map of the US cremation rates by state ... but the more

Read More

Programming Tips

Rick WicklinJune 15, 2018 0

Video: New random number generators in SAS

My 2018 SAS Global Forum paper was about "how to use the random-number generators (RNGs) in SAS." You can read the paper for details, but I recently recorded a short video that summarizes the main ideas in the paper. In particular, the video gives an overview of the new RNGs

Read More

Previous 1 … 29 30 31 32 33 … 65 Next