I showed a SAS/IML customer a debugging tip, and she said that I should blog about it because she had never seen it before. The tip is very simple: inside of a DO loop, use the MOD function to selectively print the values of variables. Recall that the expression MOD(a,b)
More than 175 users attended the recent one-day conferences sponsored by the Pacific Northwest SAS Users Group (PNWSUG). Conference chairs Sara Beck and Mark Thompson, supported by the PNWSUG Executive Committee, created another great learning experience for SAS users in Seattle (Sept 19) and Portland (Sept 21). However, change is
Over my 32 year career in local government as a city and county manager I was faced with many difficult decisions during budget deliberations. Setting tax and utility rates, adding head count, determining compensation and benefits, calculating the appropriate mix of debt and cash for funding capital projects…these were all
In my previous post, I blogged about how to sample from a finite mixture distribution. I showed how to simulate variables from populations that are composed of two or more subpopulations. Modeling a response variable as a mixture distribution is an active area of statistics, as judged by many talks
SAS programming is taught in schools all over the world, including in high schools. Occasionally, I receive questions via my blog such as this one: Can somebody help me on this? Write a short DATA _NULL_ step to determine the largest integer you can store on your computer in 3,
Student’s schedules are packed with activities these days but taking time out to attend a conference is always a great addition to any semester. For students who use SAS and want to attend a SAS Users Group conference, here are some tips to help you get the most out of
Sometimes a population of individuals is modeled as a combination of subpopulations. For example, if you want to model the heights of individuals, you might first model the heights of males and females separately. The height of the population can then be modeled as a combination of the male and
We continue my colleague Udo Sglavo's example with the SAS code for incorporating R models into SAS Forecast Server: Code for Including R Model Results in SAS As a first step I’m exporting a data set containing one time series from SAS to R (actually I will use the same
In 2009, SAFETEA-LU—the legislation that outlines federal transportation funding for the states—expired. Since then, members of Congress have been kicking the can down the road, passing funding extensions instead of passing legislation. The major impact of this failure to act is that the U.S. continues to slip further and further
My colleague Udo Sglavo is back, responding to comments on his guest blog from two weeks ago. For fans of SAS and R, he shows how to incorporate results from Hyndman's R model into SAS. Do the Evolution After publishing my blog on replicating Rob J Hyndman’s cross validation idea
Like millions of other Americans, I recently was asked to make a decision of tremendous importance to my household -- a decision that would affect the welfare of everyone in my family. That decision, of course, was whether to continue to receive Netflix movies by mail, or opt for the
Are you planning to attend WUSS 2011 or are you a data miner who will you be in the San Francisco Bay area on Saturday, October 15 and looking for an "Unusually," "Uninteresting" data mining Unconference? An unconference is an event where users suggest topics, get together and discuss them in
The other day I encountered a SAS Knowledge Base article that shows how to count the number of missing and nonmissing values for each variable in a data set. However, the code is a complicated macro that is difficult for a beginning SAS programmer to understand. (Well, it was hard
Last week I showed a graph of the number of US births for each day in 2002, which shows a strong day-of-the-week effect. The graph also shows that the number of births on a given day is affected by US holidays. This blog post looks closer at the holiday effect.
As schools across the country delve into a new year, I want to bring my readers back to teaching basics with Part 2 of my Three R’s series on Rigor, Relevance, and Relationships. Here's Part 1. As students flood our halls and classrooms, are they eager and excited for the challenging year ahead? Do
Metadata is data about data. For the purposes of his NESUG 2011 presentation, Frank DiIorio defined metadata more precisely as data about data and data that describes workflow objects and processes. DiIorio wrote his paper because organizations are challenged more and more today to do more with less. Metadata can
As I mentioned in my introductory post about Windows PowerShell, you can use PowerShell commands as a simple and concise method to collect data from your Windows systems -- information that is ripe for analysis within SAS. In this example, I'll show a technique for using a SAS program to
Look at the following graphs showing one weekly time series. The left hand shows the actual time series plot. To the less statistically inclined this plot might indicate that the data is seasonal due to the troughs during summer and the peaks during winter. However, if you were to use
Polynomials are used often in data analysis. Low-order polynomials are used in regression to model the relationship between variables. Polynomials are used in numerical analysis for numerical integration and Taylor series approximations. It is therefore important to be able to evaluate polynomials in an efficient manner. My favorite evaluation technique
In this guest blog, my colleague Snurre Jensen (Analytic Solutions Manager, SAS EMEA Technology Practice) discusses a fine point regarding the word “seasonality” in time series forecasting. When we see general ups and downs in the data that tend to repeat year after year, we commonly refer to this as
Rick Wicklin and I are engaged in an arms race of birthday-related blog posts. To recap: Rick analyzed national data about births in the USA and what time of year they are most likely to occur. I responded by analyzing the birthdays of my Facebook friends. Rick responded by analyzing
Contributed by Sara Jones, CMP, User and Customer Marketing at SAS So many papers, so little time. Looking at the SAS users group conference schedule and deciding what to attend and how to get the very most of your day can be overwhelming - in a good way of course. So many
My friend Chris posted an analysis of the distribution of birthdays for 236 of his Facebook friends. He noted that more of his friends have birthdays in April than in September. The numbers were 28 for April, but only 25 for September. As I reported in my post on "the
Telecommuting is not always a matter of working from home. Virtual team workers are often located in a satellite office, in another country or are temporarily out of the office. Today, many managers have no choice but to incorporate telecommuting members into their team structure. Mary Varughese, Mei Dey and
Kathleen Harkins, Carolyn Maass and Mary Anne Rutkowski, from Merck Sharp and Dohme, collaborated to write T.I.P.S: Techniques and information for programming in SAS® for NESUG 2011. These three women are highly experienced programmers: Harkins has more than 20 years of experience in the pharmaceutical and aerospace industries; Maass has
The downturn in the economy beginning in 2008 and continuing even to now has put tremendous pressure on local governments to do “less with less”. In the past when economic downturns caused service level cut backs the cry was to do “more with less”. The idea was to identify ways
Windows PowerShell is one of my favorite tools to use for gathering information from my PC and network, and also for automating processes. If you are familiar with UNIX shells (such as Korn shell or its variants), you will probably be very comfortable with Windows PowerShell. Just like its UNIX
You can extend the capability of the SAS/IML language by writing modules. A module is a user-defined function. You can define a module by using the START and FINISH statements. Many people, including myself, define modules at the top of the SAS/IML program in which they are used. You can
My first trip to Portland, Maine, gave me more than I had expected - it was a touching, heartwarming experience that was not what I thought I'd signed up for. Let me explain: While planning my flight and other travel arrangements, I realized that I would arrive in Portland early
Earlier today, Rick posted interesting information about which time of year the most babies are born, at least in the USA. I don't have data nearly as extensive as what's available at the NCHS, but I do have a sample of birthday records to compare against Rick's findings. My sample
