SAS Learning Post

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

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 character variables in a SAS data set. For example, you could convert all numeric variables with… Continue reading How to perform an operation on all numeric or all character variables in a SAS data set

SAS Learning Post

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 be useful. Integrity Constraints are… Continue reading Keeping your data set clean: Integrity constraints

SAS Users

How to protect your audit trail in a SAS environment

I have discussed auditing within a SAS environment and how to identity who has accessed data or changed reports. For many companies keeping an audit trail is very important. If you’re an administrator in your environment and auditing is important at your organization, here are a few steps to take to secure the auditing setup… Continue reading How to protect your audit trail in a SAS environment

SAS Users

Auditing SAS server availability from 30,000 feet

One very useful type of auditing for a SAS administrator is to have summary data about the availability and performance of various resources (platforms, servers, services) from the 30,000-foot view. Using SAS Environment Manager, it’s easy to go in and look at the availability of any one resource over various time spans–for the past few… Continue reading Auditing SAS server availability from 30,000 feet

Graphically Speaking

Advanced ODS Graphics: Vector plots and adjusting point labels

A vector plot draws a line (potentially ending in an arrowhead) from one point in a graph to another point. Often, that first point is the origin (0,0) although both PROC SGPLOT and the GTL enable you to specify other points. In this blog, I will show you how to pick a different origin: that… Continue reading Advanced ODS Graphics: Vector plots and adjusting point labels

The Do Loop

The jackknife method to estimate standard errors in SAS

One way to assess the precision of a statistic (a point estimate) is to compute the standard error, which is the standard deviation of the statistic’s sampling distribution. A relatively large standard error indicates that the point estimate should be viewed with skepticism, either because the sample size is small or because the data themselves… Continue reading The jackknife method to estimate standard errors in SAS

SAS Voices

Digital government: How to make it a vibrant reality

Citizens served by the government are increasingly the same digital savvy consumers that market disruptors in banking, retail and utilities are attracting with sophisticated, data-driven online experiences. It’s a mutually beneficial arrangement; consumers get to buy services in ways that suit them while businesses get the efficiencies they want, wrestling profits and market share from… Continue reading Digital government: How to make it a vibrant reality