As I sit here in the Regina airport, I'm looking out the window with longing like a puppy at the pet store. The weather here is just beautiful: + temperatures and clear skies and the sound of the running water resulting from the melt-off of the snow is...
Read more »
As a native Torontonian, I'm used to getting some friendly (and sometimes not so friendly) ribbing when I travel around the country. The 'Centre of the Universe' is often referred to in less-than-glowing terms by others. Over the years, I've tried to p...
Read more »
I like to think that I have a graph for all occasions - Chinese New Year is no exception! ... This year, the Chinese New Year is on Feb 10, 2013. The date varies from year to year, because it's based on the lunar (moon) cycles. I thought it would [.....
Read more »
Over the holidays I was having a discussion with my cat, Ms. Trixie Lou. A question that often arises during the first programming class is the following: how do I find the variables that are in common to these two or three data sets? As it turns out, ...
Read more »
Dear Miss SAS Answers, I have read through a few Dear Miss SAS Answers blog posts, but I cannot seem to find what I am looking for. I need to extract only the second duplicate from a whole list of duplicates per account number. Is there a way to...
Read more »
In the previous episode, we built our own custom SAS function - a masterful trick indeed. Gordon Keener, a developer here at SAS, responded exuberantly "You think that's cool? - try THIS!" and proceeded to demonstrate prodigious powers with the SAS by ...
Read more »
A SAS user (who lives in the the US) emailed me a question about SAS functions. He was read UTC (Coordinated Universal Time) datetime values from server logs, and to make future calculations and comparisons easier, he wanted to transform the value to ...
Read more »
The 25 boys I teach on Sundays loved these cupcakes I baked for them for Easter… the sugared peeps had them completely satisfied. I love my tea or coffee laced with sugar. I think you‘d all agree that it is always more pleasant to meet a nice custo...
Read more »