Tag: sas press

Using SAS to Help Girl Scouts Grow Cookie Sales!

Motivating students is one of the major challenges teachers and student advocates face on a daily basis and encouraging students to be interested in analytics is a whole other mountain to climb, or is it? What motivates students? Often we make assumpti…

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 […]

The post An introduction to SAS Visual Analytics: the Parallel Period function of the Derived Item calculations appeared first on SAS Learning Post.

3 steps to prepare your data for accurate predictive models in SAS Enterprise Miner

In this post I describe the important tasks of data preparation, exploration and binning.These three steps enable you to know your data well and build accurate predictive models. First you need to clean your data. Cleaning includes eliminating variable…

8 new summer reads for SAS users

Summer is here, which means vacations and time at the pool with a good book. If expanding your knowledge is a goal of yours this summer, SAS has a shelf full of new titles becoming available over the next few months. From new editions of classics – such as SAS® for Forecasting […]

The post 8 new summer reads for SAS users appeared first on SAS Learning Post.

How to perform an operation on all numeric or all character variables in a SAS data set

In a previous blog, I demonstrated a program and macro that could identify all numeric variables set to a specific value, such as 999. This blog discusses an immensely useful technique that allows you to perform an operation on all numeric or all chara…

Keeping your data set clean: Integrity constraints

When I teach my Data Cleaning course, the last topic I cover in the two-day course is SAS Integrity Constraints.  I find that most of the students, who are usually quite advanced programmers, have never heard of Integrity Constraints (abbreviated ICs).  I decided a short discussion on this topic would […]

The post Keeping your data set clean: Integrity constraints appeared first on SAS Learning Post.

Using regular expressions to verify the pattern of character data

Wait!  Don’t close this window.  I understand that regular expressions can be very complicated (yes, there are many books on the subject), but some basic expressions to test patterns such as zip codes or telephone numbers are not that difficult.  In addition, you can sometimes use Google to search for […]

The post Using regular expressions to verify the pattern of character data appeared first on SAS Learning Post.

How to control the name of Excel sheets when they are all created at once

Ok, so you know how to create multiple sheets in Excel, but can anyone tell me how to control the name of the sheets when they are all created at once? In the ODS destination for Excel, the suboption SHEET_INTERVAL is set to TABLE by default.  So what does that […]

The post How to control the name of Excel sheets when they are all created at once appeared first on SAS Learning Post.