On the SAS-L mailing list, a participant posed this question (paraphrased): How can I tell which date format my Windows session is using: European format (with day first) versus USA format (with month first)? I'm reading in output from a Windows file listing, and need to know how to interpret
The other day I encountered an article in the SAS Knowledge Base that shows how to write a macro that "returns the variable name that contains the maximum or minimum value across an observation." Some people might say that the macro is "clever." I say it is complicated. This is
It's Friday, and on SAS Voices they are posting fun stuff about dogs who work at SAS. I'm posting about PROC SQL and MySQL. You tell me - which of us knows how to ring in the weekend with style? I've been working with MySQL data sources lately, and SAS/ACCESS
I've been a fan of statistical simulation and other kinds of computer experimentation for many years. For me, simulation is a good way to understand how the world of statistics works, and to formulate and test conjectures. Last week, while investigating the efficiency of the power method for finding dominant
SAS users, by definition, do not embrace the mysterious. That's one of the main reasons that they use SAS: to demystify some data or process. And so, when you (as a SAS user) have gone to the trouble of designing a process flow in SAS Enterprise Guide, you like to
First: A Report from the 67th Pine Tree Festival and Southeast Timber Expo Back in March The BFD investigated the topic of Google-ing yourself (aka egosurfing). I reported on finding a namesake in show business, a self-described "Magic Mike Gilliland" and his sidekick Lollipop the Clown. I attempted to disparage
One of the first skills that a beginning SAS/IML programmer learns is how to read data from a SAS data set into SAS/IML vectors. (Alternatively, you can read data into a matrix). The beginner is sometimes confused about the syntax of the READ statement: do you specify the names of
Remarkably, this week's tip was initially inspired by the Guinness Brewery in Dublin, Ireland. In his new book Statistical Analysis for Business Using JMP, Professor Willbann Terpening provides lots of useful information - including the origin and usage of the Student t-distribution. If you'd like to get to know Willbann and
What tiny looking operator packs a mighty punch with large datasets? Your queries are big. Your reports span multiple columns. To top it all you have to summarize data in multiple ways. Are you tempted to throw in the towel? Do you feel like saying a firm “Can’t be done”
In a previous post I showed how you can use Windows PowerShell (with the SAS Local Data Provider) to create a SAS data set viewer. This approach doesn't require that you have SAS installed, and allows you to read or export the records within a SAS data set file. In
When I was at SAS Global Forum last week, a SAS user asked my advice regarding a SAS/IML program that he wrote. One step of the program was taking too long to run and he wondered if I could suggest a way to speed it up. The long-running step was
Pet lovers do the most incredible things. My friend Grace told me she trained her pet rabbit to walk on a leash. I said, "That's amazing Grace -- I never heard of such a thing!!! I thought rabbits could only hop." Rest assured there are no dogs (cats or rabbits
With the rapid changes in our education systems regarding new standards, assessments, accountability and evaluation, teachers are rightfully feeling the pressure of being underprepared. The majority of teachers were not trained or certified with these rigorous systems in place. Recognizing that higher education institutions need to play an active role
In statistical programming, I often test a program by running it on a problem for which I know the correct answer. I often use a single expression to compute the maximum value of the absolute difference between the vectors: maxDiff = max( abs( z-correct ) ); /* largest absolute difference
This week's SAS author's tip comes from Carol Matthews and Brian Shilling and their book Validating Clinical Trial Data Reporting with SAS. SAS users have raved about this guide. In her review, Susan Fehrer said "Carol and Brian's book provides a good overview, practical hands-on tips, and many examples of how to perform
Have you seen this week's news item on "tanning mom" Patricia Krentcil, the New Jersey mother accused of sunburning her young daughter in a tanning booth? Now I'm as big a fan of diversity as the next guy, and lovingly embrace people of every visible color (although I do find House Speaker John Boehner's orange a
A reader asked: I want to create a vector as follows. Suppose there are two given vectors x=[A B C] and f=[1 2 3]. Here f indicates the frequency vector. I hope to generate a vector c=[A B B C C C]. I am trying to use the REPEAT function
Can you explain the "random error" in your forecasts? This question was posed two weeks ago by Sam Iosevich, Managing Principal at Prognos, during his presentation at the INFORMS Conference on Business Analytics and Operations Research. Sam stated that if your planners have knowledge that helps explain the "random error" in
A SAS user (who lives in the the US) emailed me a question about SAS functions. He was reading UTC (Coordinated Universal Time) datetime values from server logs, and to make future calculations and comparisons easier, he wanted to transform the value to local datetime. The INTNX() function worked great, but
To a statistician, the DIF function (which was introduced in SAS/IML 9.22) is useful for time series analysis. To a numerical analyst and a statistical programmer, the function has many other uses, including computing finite differences. The DIF function computes the difference between the original vector and a shifted version
Many SAS customers are quickly adopting 64-bit versions of Microsoft Windows, and they are pleased-as-punch when they find a 64-bit version of SAS to run on it. They waste no time in deploying the new version, only to find that a few things don't work quite the same as they
Robert Allison's SAS/GRAPH: Beyond the Basics collects examples that demonstrate a variety of techniques you can use to create custom graphs using SAS/GRAPH software. To celebrate the book’s publication, we asked Robert to tell us more about why he loves SAS/GRAPH. Here’s what he had to say: A graph is
Last week I introduced this series. Today I begin to dive deeper into each of the four E's. First up? Enforcement. In 2009, there were 5.5 million police-reported traffic crashes. Law enforcement officers work diligently to prevent crashes by enforcing traffic safety laws pertaining to, among other things, seat belt
To a statistician, the LAG function (which was introduced in SAS/IML 9.22) is useful for time series analysis. To a numerical analyst and a statistical programmer, the function provides a convenient way to compute quantitites that involve adjacent values in any vector. The LAG function is essentially a "shift operator."
Question: What do John Travolta, Gina Davis, and I all have in common? (I mean, besides the obvious fact that we are all awesome dancers.) Answer: We have all had makeup applied by artist Roxie Stice. I was the host for two SAS Tech Talks, which were broadcast via Livestream
Last week's INFORMS Conference on Business Analytics and Operations Research drew over 700 attendees to Huntington Beach, CA. I had the pleasure of serving on the conference selection committee, and wanted to share this content from one of our invited speakers, Kean Chew of HAVI Global Solutions. The Numbers Behind Burgers
Like Vince said a few days ago, you don’t have to be Goliath to see how the intersection of big data and high performance analytics creates competitive advantage. Let’s also be realistic though: compared to someone like Walmart, pretty much everyone’s David! While Telstra and the Commonwealth Bank may not be the largest companies by global measures, they’re still
Bill Franks’s new book, Taming the Big Data Tidal Wave: Finding Opportunities in Huge Data Streams with Advanced Analytics, has just released. This book shows how big data is changing the world of analytics; what people, processes, technologies, and mindsets are necessary to succeed in analytics in this new era;
How can you go home on time? Take a quick tour with these 5 tips that I was able to summarize for my students in the SAS SQL 1: Essentials class yesterday. Since they found it handy and asked if it could become a blog post, I thought I’d share
The April 2012 issue of ORMS Today contains a piece on "How analytics enhance the guest experience at Walt Disney World," by Pete Buczkowski and Hai Chu. While many of us are used to forecasting just one or two things (such as unit sales or revenue), Pete and Hai illustrate
