Posts Tagged ‘ sas programming ’

Code debugging and program history in SAS Enterprise Guide

August 18, 2017
By
Code debugging and program history in SAS Enterprise Guide

SAS programmers have high expectations for their coding environment, and why shouldn't they? Companies have a huge investment in their SAS code base, and it's important to have tools that help you understand that code and track changes over time. Few things are more satisfying as a SAS program that

The post Read more »

Tags: , , , , ,
Posted in SAS | Comments Off on Code debugging and program history in SAS Enterprise Guide

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?

Ten SAS Enterprise Guide program editor tricks

July 3, 2017
By
Ten SAS Enterprise Guide program editor tricks

If you spend a lot of time in SAS Enterprise Guide (as I do), you probably get to know its features pretty well. But we don't always take the time to explore as we should, so there might be a few golden nuggets of editor knowledge that have escaped you

The post Read more »

Tags: , , , ,
Posted in SAS | Comments Off on Ten SAS Enterprise Guide program editor tricks

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

Create and run SAS code in SAS Add-In for Microsoft Office

May 30, 2017
By
Create and run SAS code in SAS Add-In for Microsoft Office

When SAS Add-In for Microsoft Office was first created over a decade ago, SAS programmers were told to check their skills at the door. This new product was for non-programmers only. SAS programmers were invited to contribute to the experience by packaging their code in SAS stored processes, which end

The post Read more »

Tags: , ,
Posted in SAS | Comments Off on Create and run SAS code in SAS Add-In for Microsoft Office

Take that SAS option

May 25, 2017
By

Elizabeth is courageous. Scoliosis since birth, corrective spinal surgery replaced her spine with steel, tripping on stairs permanently broke her right ankle. Then she decided to come take yoga with me. To help ease back pain & reduce hip stress, I offered options like bent legs not cross. In class

The post Read more »

Tags: , , ,
Posted in SAS | Comments Off on Take that SAS option

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.