Posts Tagged ‘ sas author’s tip ’

An introduction to SAS Visual Analytics: the Parallel Period function of the Derived Item calculations

October 9, 2017
By

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 Read more »

Tags: , , ,
Posted in SAS | Comments Off on An introduction to SAS Visual Analytics: the Parallel Period function of the Derived Item calculations

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

August 10, 2017
By

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...
Read more »

Tags: , , , ,
Posted in SAS | Comments Off on 3 steps to prepare your data for accurate predictive models in SAS Enterprise Miner

Organize your work with SAS® Enterprise Guide® Projects

July 18, 2017
By

Nowadays, whether you write SAS programs or use point-and-click methods to get results, you have choices for how you access SAS. Currently, when you open Base SAS most people get the traditional SAS windowing environment (aka Display Manager) as their interface. But it doesn’t have to be that way. If

The post Read more »

Tags: , ,
Posted in SAS | Comments Off on Organize your work with SAS® Enterprise Guide® Projects

How severe is your missing data problem?

July 17, 2017
By

Datasets are rarely ready for analysis, and one of the most prevalent problems is missing data. This post is the first in a short series focusing on how to think about missingness, how JMP13 can help us determine the scope of missing data in a given ta...
Read more »

Tags: , , , ,
Posted in SAS | Comments Off on How severe is your missing data problem?

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

June 27, 2017
By

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...
Read more »

Tags: , , , ,
Posted in SAS | Comments Off on How to perform an operation on all numeric or all character variables in a SAS data set

Keeping your data set clean: Integrity constraints

June 26, 2017
By

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 Read more »

Tags: , , , ,
Posted in SAS | Comments Off on Keeping your data set clean: Integrity constraints

Using regular expressions to verify the pattern of character data

June 6, 2017
By

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 Read more »

Tags: , , , ,
Posted in SAS | Comments Off on Using regular expressions to verify the pattern of character data

Standardizing phone numbers using SAS

May 26, 2017
By

How many times have you entered a phone number on a web page, only to be told that you did not type it the "correct" form? I find that annoying. Don't you? In my latest book, Cody's Data Cleaning Techniques, 3rd edition, I show how to convert a phone n...
Read more »

Tags: , ,
Posted in SAS | Comments Off on Standardizing phone numbers using SAS

Welcome!

SAS-X.com offers news and tutorials about the various SAS® software packages, contributed by bloggers. You are welcome to subscribe to e-mail updates, or add your SAS-blog to the site.

Sponsors





Dear readers, proc-x is looking for sponsors who would be willing to support the site in exchange for banner ads in the right sidebar of the site. If you are interested, please e-mail me at: tal.galili@gmail.com
SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration.