One of the sweet new capabilities in 9.2 OLAP for cube developers is the Cube Job that is automatically created for each new cube. The job is used as a interface mechanism to schedule the cube refresh code without manually retrieving the PROC OLAP c…
Measuring the value of my DVD-by-mail movie service
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 […]
A Great Start to the Fall User Group Season
The Toronto Area SAS Society (TASS) meeting last Friday was the perfect way to kick-off what promises to be a very busy Fall/Winter user group season. As I blogged about on the SAS Canada Community site, I was really looking forward to a tightly-themed…
A Great Start to the Fall User Group Season
The Toronto Area SAS Society (TASS) meeting last Friday was the perfect way to kick-off what promises to be a very busy Fall/Winter user group season. As I blogged about on the SAS Canada Community site, I was really looking forward to a tightly-themed…
A Great Start to the Fall User Group Season
The Toronto Area SAS Society (TASS) meeting last Friday was the perfect way to kick-off what promises to be a very busy Fall/Winter user group season. As I blogged about on the SAS Canada Community site, I was really looking forward to a tightly-themed…
A test to count missing values for large data
This morning Rick introduced how to count the missing frequencies for all variables in a dataset, including character and numeric variables. He provided two solutions by either PROC FREQ or PROC IML. I have a petty macro based on PROC SQL’s nmiss() f…