Tuesday, December 14, 2010

Celebration is in the Air

... and it may not just be the spirit of the season! We've finally arrived: the final user group meeting of 2010. It's hard to believe, to be honest... this has been such a busy, full year with so much to celebrate. I'll have a lot of numbers, testamonials and new developments to share with you in the coming weeks... so just because the meetings are done for now doesn't mean there won't be any more posts! Au contraire, I feel like I'm just warming up...

The last TASS meeting of the year will be taking place this Friday, December 17th: if you haven't yet registered, it's not too late! You'll find the full agendas of both meetings here, as well as opportunities to register. In addition to this being the last meeting of the year, it's also a cause for celebration: this is the 25th anniversary of TASS! One of the original members, Carl Clutton, will be regaling the group with tales of the early days of TASS... 20 people who paid yearly dues to attend the small sessions. Fast forward in time and we're now seeing over 200 people attending what has grown into a full day meeting experience. The morning portion of the meeting focuses on coding-related issues, and the afternoon on more point-and-click interfaces such as Enteprise Guide, JMP, and Enterprise Miner.

This TASS meeting will feature Chevell Parker, an exciting coup for SAS Canada! Chevell is an incredibly valuable member of the SAS family. A Microsoft Office/Excel guru, Chevell will be talking about maximizing output between SAS and Excel, as well as some FAQs around how the two applications mesh. We're very excited to have been able to 'steal' him from Cary for a few short days... and on his wife's birthday to boot! Thanks, Chevell.

Look forward to seeing many of you on Friday and I'll have more following the meeting: stay tuned...

Friday, December 3, 2010

Parade Held in Montréal for the Business Analytics Forum!

OK, so that's wishful thinking. The truth is that the Forum analytique d’affaires SAS de Montréal happened to coincide with the victory parade for the back to back champion Montréal Alouettes. They were wending their way through the heart of downtown to the joyful cries of fans braving the wet weather in order to salute their heroes. As a native Torontonian whose team was handily eliminated in the preceding round by said Alouettes, I suppose I can take some cold comfort in the knowledge that at least we were beaten by the champs. Félicitations, Montréal: bien fait!

This final trip to a host city was bittersweet. Perhaps it's because I know I won't see many of my friends and colleagues for months, if not a year. Or, perhaps it's because I find travelling the country and meeting such interesting people so invigorating: my next opportunity may be as far away as SAS Global Forum in Las Vegas in early April! It's hard to imagine. However I still had this final trip to take and I was looking forward to enjoying some of the fine dining for which Montréal is reknowned. I had a more-than-willing collaborator in Rick Miller of CIBC.

I've known Rick for a few years having first met him through former TASS President Rupinder Dhillion at a user group meeting early in my SAS career. A long-time SAS supporter and even longer serving CIBC employee, Rick is currently the Vice President of Credit Risk Data Solutions within the Risk Management division of the bank. Approachable and knowledgeable about business and technology, I was thrilled when he accepted my recent invitation to present at the Forum analytique d’affaires SAS de Montréal. His presentation had been seen at SAS Global Forum 2010 by the group's President, Loretto Chiovitti of Desjardins: not surprising as Rick has presented three times at Global Forum. Entitled 'Supercharged Analytics', the talk is a compelling look at the rationale, requirements and ramifications of going to an in-database processing structure for increased performance and productivity. You'll be able to find a copy at the group's website within the coming weeks, but if you can't wait simply email me: I'll be happy to send you an advance version.

Rick's presentation was extremely well-received and inspired quite a few questions. Next, Ronald Allard of SAS Canada took the talk to a more technical level by showcasing some of the in-database processing options available through a variety of SAS tools and applications. As SAS' Jean-Francois Michaud joined the two presenters for an open-room panel discussion, it was clear the audience had saved many of their inquiries for this moment and that the presentations had stimulated some curiosity. Questions and answers filled the room over a half-hour's time and it we actually had to curtail discussion a bit in order to fit in the prize draw! All in all, a very successful meeting.

If I may, a word or two about the amazing hospitality and friendliness of Montréalers. From the amazing cuisine and conversation at Cavalli the evening before or the delicious lunch following the meeting, SAS staff, user group executives and attendees alike were amazingly gracious and hospitable. Thanks for making my last road trip one I'll remember!

There's only one more meeting this calendar year: two weeks from now, the TASS meeting takes place at the SAS offices. We'll be celebrating the 25th anniversary of the group so if you're in the area and haven't registered, please do: it's a great way to close out the year.

I'll have more for you about TASS in the next few days... until then.

Monday, November 29, 2010

SAS Goes To A Ceilidh (Sort Of)

My manager Wally Thiessen was lucky enough to travel to beautiful Halifax for the SHRUG user group meeting last week. I say 'lucky' through gritted teeth set in a face tinged by the horrible green of jealousy... I absolutely adore Halifax and Nova Scotia in general and selfishly try to get out there myself as often as I can! I think I may have made a deal with SHRUG Dictator-for-Life (or the foreseeable future) John Fahey to ensure that my colleague Sylvain and I are able to join them for their spring meeting: John has amicably agreed to guarantee good weather... so how can we say no? But that is then, and this is now.

Wally was good enough to contribute a guest post for the blog this week. He's already given me very glowing reviews of the meeting in general, and this spells it out in a bit more detail. With no further ado, take it away, Wally!

Checking In With the SHRUG ‘Family’

It had been a few years since I last had the opportunity to visit the SHRUG user community, and I was curious to see how the group was faring. Ever since its formation in ’02, SHRUG has fostered a wonderful spirit of cooperation for sharing ideas— with the kind of kinship that you often find in a number of the user groups based in key cities across the country. They may be smaller in size, but certainly not in engagement and energy! It’s a real thrill to watch colleagues connect and pick up conversations which had been left at the last SHRUG meeting, and to clearly see how this community of SAS users goes out of its way to support each other outside the structured confines of the SHRUG meeting.

Of course I was not to be disappointed in this meeting either. Under the leadership of the SHRUG executive committee—John Fahey, Pan Andreou, Jo-Anne Douglas, Barry Campbell, Jill Casey and Martha Cox, I was pleased to find that the group was continuing to find new and interesting ways to encourage participation from everyone in the room. A series of shorter tips and tricks presentations from Lynn Lethbridge, Pan, and John provided enough new ideas to keep attendees’ synapses firing until well into the New Year! Prior to the break, Jill Casey, our emcee for the afternoon, asked everyone to introduce themselves, share a little bit about how they used SAS as well as one problem they had used SAS for in the past year (or alternatively, what they would like to use SAS for). Not only was this great fodder for future presentations (as Barry Campbell diligently noted everyone’s comments), but it also provided a terrific starting off point for networking during the break.

The interactive nature of the meeting continued as Gordon Flowerdew challenged everyone with a quiz on missing values, for which a series of prizes following the meeting were awarded. And by the time Peter Eberhardt had shared his content-filled 45 minute presentation on SAS dictionary tables, it certainly seemed as if people’s heads were ready to explode with the sheer volume of new SAS knowledge gained that afternoon. To end things off on a lighter note, I shared Matt’s social media presentation with the group as well as discussed some of our initial plans around building a Canadian community site to complement the SAS user group and insights e-newsletter programs. .. but more on that in the weeks and months to come.

To finish off the afternoon on a happy - if not completely sobering – note, the SHRUG gang invited Peter and I to join them at a popular local establishment called the Henry House - the historic home of William Alexander Henry, one of the fathers of Confederation. Although politics and history weren’t on the menu, good discussion on alcoholic and non-alcoholic topics ensued as Peter shared his passion for craft beer-making as well as the making of his DVD “Brewing Made Easy”. I thought I saw a glint in John’s eye as Peter expounded upon the DVD, perhaps hoping to put his newfound marathon skills to the test by running home to give it a first watch. While our plans for bringing SAS Global Forum to Halifax, or at least to Canada, didn’t get quite as fully formed as we would have liked, the company, the discussion, the food, and yes, the drink, were all top drawer, leaving us in healthy anticipation of the next SHRUG meeting in the spring!

W

Thanks Wally, and again: I'm very jealous! I hope I'll have great stories myself after the next SHRUG gathering.

As for me: well, I've reached the natural end of my Fall user group season with more than a little sadness. I'm off to Montréal tomorrow with Rick Miller of CIBC for the Forum Analytique d'Affaires SAS de Montréal meeting on Wednesday: I hope you can join us, and stay tuned for my feedback within a few days time.

Until then...

Thursday, November 25, 2010

A Moustachio-ed Tim Trussell Returns to his Roots

One week after the Health User Group and I'm FINALLY able to pass on some great stories from the meeting! Boy oh boy, this backlog of blog posts has bothered me beyond belief. I'll be very pleased when I've caught up completely after this entry... I want to ensure I'm doing justice to everyone in an appropriate and timely fashion.

Last week's Health User Group meeting was notable for a few reasons. I would like to acknowledge Eugene Wen of CIHI who has stepped down as President of the executive committee after many years of sitting at the helm. Eugene steered a perfect route through the storm: he went out of his way to ensure that the mandate of the group - to support health industry professionals - was respected through and through. Health practitioners in Toronto, you'll be hard pressed to have as vocal and tenacious a champion again... thanks for all of your contributions, Eugene.

The second person I need to acknowledge is Ruth Croxford of ICES. I honestly don't know where to begin with Ruth. She's a tireless champion both of the Health User Group as well as the first person to step forward in order to support that community. Case in point: Ruth volunteered to not only research but deliver a large 'SAS Tips & Tricks' presentation specific to healthcare. The appreciative murmurs I heard running through the room told me that she hit the proverbial nail right on the head. Great job, Ruth, and thanks for personifying the spirit of the SAS user community so well.

Finally, I come to Mr. Tim Trussell. Those who know me are very well aware that Tim is a great friend of mine. Professionally and personally, he's been there for me above and beyond the call of duty.... and I'm not alone in this sentiment. In fact, Tim was the driving force (along with Ruth and Eugene) behind forming the health-specific user group around 5 years ago. His background is in epidemiology and statistics, meaning he speaks the language of the industry and understands the challenges, pains and priorities of this critical vertical. Given his demand as the analytics guru for SAS Canada, being able to secure his time for the meeting was a real coup and Tim certainly didn't disappoint (except in the patchy growth of his Movember moustache: to learn more and to sponsor him in this worthy cause, click here).

Tim's hour-long talk was on the topic of text analytics within the health industry, and I think it's fair to say that the presentation was both eye-opening and thought-provoking. Leveraging his intimate familiarity with all aspects of healthcare, Tim was able to bring forward non-Canadian examples of how text analytics is being used in new and dynamic ways in order to help parse health records, doctor's notes, journal articles, exit surveys, and much more. In fact, Tim's looking for some willing healthcare organizations here in Canada to help validate the utility of SAS' text analytics solution... and he's willing to make the solution available in order to do so! If this is of interest, definitely reach out to him via his email address to discuss further...

The meeting was a bit smaller than normal but this actually proved to be a boon, not a limitation. The intimacy of the room and the willingness of the presenters to engage with the audience ensured that the room was relaxed and ready to talk... and they sure did! I had a great conversation with a gentleman about the fact that it was Facebook's 'un-friend' day - ironic, considering that I was about to deliver a large social media-themed talk. All the same, I made note of some pleasant smiles and nods of understanding as I framed out SAS Canada's early social media forays specific to healthcare through the newly formed HUG LinkedIn group. A few individuals have already connected with me there and I'm looking forward to getting to know many more of you!

Tim was able to demonstrate the text analytics solution as a variety of scenarios and potential roadblocks were suggested by the group. Ruth's talk was punctuated by individuals validating or asking for further detail around one of her tips and tricks, and there was a lot of furious scribbling on SAS notepads. The sense of community and the desire to share knowledge was truly palpable, a consistent hallmark of this group. All in all, the meeting was a great success. It was really fun to watch Tim and the executive team help to set establish a warm, welcoming environment: my thanks to all of them for their assistance. I'll be posting the results of the evaluations in the LinkedIn group shortly for your feedback, and of course the presentations have already been posted at the Health user group site.

Next up: my manager is in Halifax attending the SHRUG meeting and will be guest-posting upon his return... and I learn to bellydance: with photographic evidence! Stay tuned...

Tuesday, November 23, 2010

SAS Presents: Kerry Blanchard in Ottawa!

As promised, I'm turning over this space to my colleague Kerry Blanchard. Many of you will know Kerry as an indispensable asset in the SAS user community. Assisting with user group logistics, analysis and support, she's definitely made my life easier and helped grow the user community through her bright personality and eagerness to contribute. With no further ado, over to you, Kerry! I'll have the Health User Group post ready for your consumption within a few days.

Musings from a TRUE Outlier
– by Kerry Blanchard

To begin my first guest blogging experience on Matt’s wonderful blog ‘Musings from and Outlier’, I must say I’m a little intimidated! I’ve read quite a few of his posts and he always writes with such eloquence, passion and pizazz that I don’t think that it’s at all possible to mimic the feel that he gives to his readers…but I’ll give it a shot!

As a TRUE newbie to SAS (a mere 6 months young) I was both nervous and excited to head out to my first on-the-road user group meetings for the Ottawa Area SAS Society (OASUS) and the Ottawa Platform User’s Society (OPUS.) Arriving the night before and staying in downtown Ottawa was such a nice experience as I’m familiar with the area having grown up about an hour away in Brockville. There is something about Ottawa that is so peaceful to me - I’m not sure if it’s the stunning beauty of the Parliament Buildings or the Chateau Laurier, or just the fact that it seems a lot less busy than downtown Toronto (even during rush hour!) – but it was nice to be back in a city that I knew and loved.

The morning of the meeting started bright and early and even though I made it to the National Arts Centre by 7:15 am, the executive committee was already hard at work setting up. I have to say a few ‘thank-yous’ here to the entire executive for making me feel so welcome even though I had never met any of them face-to-face. Hing-Poon Chan was diligently working at the sign-in table and cheerfully greeted me as I walked into the room. OASUS President John Ladds gave me such a warm smile I would have thought I was visiting a dear old friend. It was great to see that even though I thought I was an outsider, they definitely didn’t make me feel like one.From then on the day went quite smoothly. The sound, computer and equipment tests were all completed before the first guest arrived and the NAC staff was more than happy to get any little extra thing we asked for (they even photocopied more evaluation forms for us!) The only issue throughout the whole day occurred around 8:45 am when we realized that we wouldn’t have enough SAS pens for all the attendees. Now, we still aren’t 100% sure what happened, but somewhere between receiving 200+ pens in the mail from our Toronto office the day before and 8:44 am when most of them had been given out… well, let’s just say that they were ‘misplaced.’ I’d like to make a formal apology to the attendees of the OPUS meeting in the afternoon because of this unfortunate incident and I hope that many of you had brought your own pens which hopefully made up for it …but I will say this: someone out there must really be enjoying about 50 SAS pens right about now, and shame on you for not sharing with the others!

Regardless of this little mishap, OASUS and OPUS went flawlessly. We had a wonderful turn out with 132 people at OASUS in the morning, and although attendance was smaller in the afternoon, Joel Orr and the rest of the OPUS executive gave members who had attended the past five OPUS meetings with a token of their appreciation for being so dedicated. I have also been informed that this little ritual is going to continue, giving you all the more reason to make it out to the next OPUS meeting on June 1st (shameless user group plug, I know!) We also had some great presentations such as Robert West’s ‘SAS & Excel Targets’ in the morning, a pair of very detailed book reviews, a great explanation and demonstration of how to use OLAP cubes by Benoit Morin (I especially liked the NHL sample data he used) and a phenomenal panel discussion around the ‘Challenges of BI’ moderated by SAS’s Tara Holland in the afternoon.

As OPUS began to wind down at around a quarter-to-four I was suddenly struck by feelings of sadness. My on-the-road user group experience had just begun and it was already time to go home! The people I had met that day and the whole trip to Ottawa had been such a fun and educational experience that it didn’t feel right to just up and leave. It wasn’t until I was in the car on the way back to the airport did the excitement from the day begin to fade away and tiredness settled in.

I’m not sure where I’ll be next, but I’ve been told that I may get to experience more user group meetings on the road in the spring time. Will I get to experience the mountainous West, or possibly an ocean-side city in the East? Only time will tell. In the meantime I just want to let my new-found friends in Ottawa know that I am extremely grateful for the warm wishes and friendliness you showed me. Not only did you give me an experience I will never be able to repeat, it was also something I will never be able to forget.

Until next time…


Thanks for that great contribution, Kerry: I had no doubt you'd have a warm reception in Ottawa. Those two groups are standard bearers for community and support: thanks John and Joel for being yourselves and for once again surpassing expectations.

My brief hiatus from this space will resume a little later this week. As I mentioned earlier, I'll be writing about the Health user group meeting which took place last week within a few days... but my manager, Wally Thiessen, is headed out to the east coast with SAS legend Peter Eberhardt for some SHRUG-style user support: I have to admit, I'm incredibly jealous! I'm sure he'll have great tales to tell upon his return as well, and I've asked him to contribute an upcoming post as well.

Stay tuned, lots more to come!

Sunday, November 21, 2010

Rain, Sunshine, Sleet and Fog: Just Another Day in Vancouver

Vancouver strikes me as a bit of an abnormality on the west coast, at least in one sense. With its frantic, hurry-up, always-changing weather patterns it reminds me in some ways of the pace of life here on the east coast which is so markedly different from the more relaxed, outdoors-focused way of life we generally associate with BC. OK, so maybe it's just the weather that reminds me of the east and I'm likely stretching that comparison just a teensy bit too far, but the weather analogy is also useful as it serves to reflect my general inner-state of being upon landing in Vancouver.

I've stated many times in this blog how fortunate and grateful I am to be able to do what I do. Travelling from one end of the country to the other for the purpose of sharing experiences and supporting SAS users is a fantastic opportunity to broaden my horizons culturally and socially. However, it's not just my horizons being stretched: it's also my constitution and health! Adjusting to time zones and constantly looking at my watch are both minor irritants to what is an otherwise amazing occupation. The constant stress on my body systems does eventually take it's toll, unfortunately, and I was a sorry sight stepping off the helicopter upon our landing in Vancouver. Thankfully, and unbeknownst to me at the time, I was about to have an energizing and revitalizing encounter courtesy of former SAS Customer Value Award winner and past-President of TASS, Rupinder Dhillon.

This is yet another great example of SAS users supporting SAS users. One of Rup's best friends from her school years now lived as an actor and presentation coach in Vancouver. Knowing full well the importance - as well as the challenge - of encouraging and supporting new presenters from within the user group community, Rup had suggested that we take the time to connect in hopes that we could pick her brain. It was certainly worthwhile! Colleen McGahan and I chatted at length with her about common fears and limitations which presenters deal with and also put on themselves as well as some suggestions on how best to approach a presentation. This was incredibly valuable insight for myself as someone who presents quite often in front of large groups, and even moreso in terms of recognizing how to support new presenters. Thanks for the introduction, Rup: if I could give you the CVA again, I would... ;)

The meeting the next morning was truly outstanding. the VanSUG executive committee are an incredibly engaged and innovative group. I was meeting some of them for the same time, and they definitely lived up to the exceptional feedback I'd heard. Sharon Relova - a relatively new member of the team - drafted one of her colleagues and faithfully manned the registration table (without complaint, might I add!). Mei Chong the new president was omni-present, socializing and helping out where she could. Of course, perennial dynamos Colleen McGahan and Nate Derby - in addition to presenting once again - ensured that the catering was set-up, that the networking functioned smoothly, and that all possible logistic issues were dealt with far in advance. I need to single out Colleen here. Dealing with some difficult home issues which had suddenly sprung up, Colleen pushed on to both support the group and deliver her presentation flawlessly. My respect for her - which was already very high - has gone through the roof.

Content-wise, the meeting was a great one. As I mentioned, Colleen and Nate reprised their talks to exceptional acclaim - with Nate somehow managing to populate his presentation with some small coding errors in the 12 hours between deliveries. Nate is a master at dealing with adversity and the group really engaged around his transparency and willingness to admit and address his errors. Of course, the content was exceptionally valuable as well! Colleen's talk found a receptive audience able to grasp the complex concepts she was illuminating. And yes, Cheryl Sivertson's demo went off fantastically this time (albeit with her working in a version of Enterprise Guide she was unfamiliar with: version 4.3). She's a natural with the software, though, so it went off without a hitch.

I'm saving some of my biggest praise for David Dobson. The Vancouver community has been wrestling for some time with what type of interesting, new content to deliver to their members. Coming primarily from a health, academic and telecommunications background, there seemed to be diverging ideas of how best to support everyone. Enter David, our willing guinea pig! An additional session was added on to the user group meeting with David delivering an hour long talk on the importance and future of business analytics within Canadian industry... and more than 50 people stayed to hear the talk! It was extremely well delivered and generated a lot of questions afterwards. I think it's safe to say that we'll be seeing a lot more business analytics-themed talks taking place in Vancouver in the near future. As always, all of these presentations will be posted over the course of this week on the VanSUG website as well as a VanSUG newsletter update and more.

Finally, a word or two about the Vancouver SAS user community: what a warm and welcoming group. I'd like to first give a hat-tip to Mr. Howard Cherniack. Howard is familiar to many in the SAS world in Vancouver; a long-time user and supporter, Howard has presented and been an active supporter of VanSUG since it's inception and before! At any rate, Howard is the first person to answer a challenge I often throw out to the user groups. I have one prize in particular which has been a mystery to me: it's full of strange, seemingly unrelated components and I've been utterly flummoxed. Without instructions, it seemed that the item would remain shrouded in confusion. I've made the commitment to every group I've offered it to that if it can be deciphered, I will be happy to ship one of every single other item I have to the lucky solver of the 'mystery prize' riddle. I'm happy to report that Howard has done so! Thanks, Howard! Just in case there are other entrants reading this, I'm going to keep your solution a mystery for now...

I'd also like to share a little about the community itself. In the span of the morning, I connected with a young lady from BC Hydro looking for some Enterprise Guide help, a recent UK transplant hoping to connect with other SAS users with an overall goal of finding SAS employment, a faux-celebrity (great to see you, Mr. Mel Gibson!) and a wonderful gentleman from TELUS who - to my absolute shock - used to pack 5 double Americano's into his body EACH EVENING... and then he would go to sleep! I'm also pleased that I've already had a few members of the community connect and start discussions within the VanSUG LinkedIn group. If you haven't yet joined, please feel free!

Although my second-last roadtrip of this user group season has come to a close, there's still lots more to report from last week. As I was in Vancouver, my colleague Kerry was experiencing her first user group meeting in Ottawa. She's been good enough to write a guest-blog post at my request, and I'll be sharing that with you in the next few days. Finally, I still have to tell all of you about the Health User Group meeting which featured impossibly long titles, sublime SAS tricks and one very happy quasi-epidemiologist... but more on that in the next few days!

Thanks again, VanSUG: sorry to leave but looking forward to the spring meetings already.

Friday, November 19, 2010

The Penultimate Road Trip

This past week was the busiest of the fall 2010 Canadian SAS User Group season... and it certainly didn't disappoint in any way! To be honest, I hardly know where to begin. There are so many tales to tell and people to recognize it makes my head spin a little. Actually, I think that spinning is due to this blasted cold I just can't get rid of! Something tells me cruising at 35,000 feet across the country twice in three days may have contributed to this.

But you're not here to metaphorically paddle a canoe down the stream of my tears, are you? Rather than complain, allow me to celebrate the first of this week's meetings in beautiful Victoria, British Columbia.

One of the reasons I enjoy travelling to the BC-based groups so much is because it affords me the opportunity to spend time with the executive committees. In many ways, these groups have embraced the concepts of community and mutual support since their earliest days. I expounded for some time in my presentation about how the executive committee members and in fact some of the regular attendees have become friends as well as colleagues. The professional relationship remains the same, but it's undeniable that we have a great time together when we're able to interact outside of the more structured confines of a user group meeting!

I must admit a wry smile just flashed across my face as I try to associate the word 'structured' with the SUAVe user group. One of it's most endearing and valuable qualities is that it is so informal. In the meetings I have attended, side debates have become points of general discussion and the networking sessions are so popular, it's a challenge to pull everyone back to the presentations. The point of the meeting is not only to learn, but also to connect with a colleague and a stranger. Academia is well-represented amongst the attendees as are a variety of provincial ministries and even a few retirees who attend simply for fun and fellowship. In the words of one of these individuals, 'it's nice to see everyone and keep up with what's going on with their work and with SAS. It's fun. I'll see you next time'. What better testimonial can there be for the positive impact of the user group community?

In terms of the content itself, Mike Atkinson and Cheryl Sivertson - SUAVe executive committee members - were partially thwarted in their attempt to work through their demo and presentation around tweaking graphics generated by Enterprise Guide and SAS/GRAPH by a complaining remote CPU connection... something SAS users are completely unfamiliar with, right? ;) Mike did a fantastic job of elaborating upon his portion of the presentation while we attempted to troubleshoot Cheryl's computer unsuccessfully. I hate to tell you this, SUAVe-ites, but Cheryl was able to deliver her demo the next day at VanSUG after a re-work and moving it to my machine. Hopefully we can convince her to give it another shot at the next meeting.

I have previously mentioned the 'user group executive exchange' taking place between VanSUG and SUAVe. Colleen McGahan and Nate Derby had converged from Vancouver and Seattle respectively to deliver presentations around Proc LOGISTIC and ROC curves in the case of Colleen and with Nate delivering a talk on Proc SQL. Suffice it to say, all presentations will be made available shortly on the SUAVe website. Without minimizing the interesting case study and thorough walkthrough offered by Colleen, I have to single out Nate for delivering one of the most entertaining and engaging presentations I've seen this fall and winter. He alternated between hilarious and forgetful with a heavy dash of genius thrown in the middle. The audience was stunned both by his tremendous knowledge and his willingness to engage them in what can only be called a 'group participation presentation'. Great stuff, Nate!

One of my absolute favourite elements of any user group meeting across the country is SUAVe's 'Open Problem'. In a nutshell, the executive committee posts a problem on their sascommunity.org website. Submitters then present their answers to the problem at the meeting and they all receive a small gift - and thunderous applause - for doing so. It's really fun to watch four or five individuals attack a problem in different ways and give some tremendous insight into how robust SAS can be as a solution.

Finally, it would be remiss of me to not recognize Peter Ott for his tremendous work. My colleague from the SAS Canada offices in Calgary who was meeting him for the first time asked me 'is he really 6'8"?'. I just smiled. Peter was not only an outstanding MC and inquisitive audience member, but he also submitted one of the solutions to the 'Open Problem'. His energy and dynamism are a fundamental reason the meetings are so successful and I thank him for it.

After the meeting, it was a quick scramble to the Helijet port for a quick helicopter ride over to the mainland. I have to admit, the inner child in me felt like a member of G.I. Joe! Colleen and Nate had left the meeting early to catch the car-carrying ferry back to Vancouver and Cheryl and Mike were doing the same afterwards to fulfill their part of the executive exchange by presenting at VanSUG the following day. But first, all of our forces would converge again that evening in Vancouver to meet for dinner, drinks and a fantastic encounter with a presentation coach - but these are all stories for my next post. Until then, thanks to the 45 members of the Victoria SAS user community who attended the meeting: it was great to see you!

Monday, November 15, 2010

To Tall Pines & Temperate Climes

I'm sipping my morning coffee and preparing for my last truly big push of the user group season... and boy oh boy, it's a big one. In just a few hours time I'm headed off to beautiful British Columbia for the Victoria (SUAVe) and Vancouver (VANSUG) user group meetings. It's always a real pleasure for me to head to the left coast and spend time with two truly tremendous executive committees. This time, they've managed to dazzle me once again; even before the meetings themselves take place!



In the spirit of growing and connecting the SAS community in British Columbia, several of the executive committee members have committed to an 'executive exchange' of sorts. Nate Derby and Colleen McGahan of VANSUG will be travelling to Victoria to deliver two technical presentations and then Cheryl Sivertson and Mike Atkinson of the SUAVe executive will repay the favour the following day in Vancouver. This spirit of collaboration is fundamental to the success of my desire to further grow and connect the network of SAS users, especially here in Canada. While executives sometimes do take part in this type of travel, this situation is a 'first' I believe: I can't recall ever seeing members support each others groups in such numbers and with such fervor.... awith pologies to all the groups in the Greater Toronto Area, of course, who have geography on their side and are able to pick and choose where to go much more easily!



I've previously mentioned how I feel very lucky in my role here at SAS. Not only do I get to travel this beautiful country but I get to meet many of the wonderful people who inhabit it. From Halifax to Whitehorse, there are tremendous SAS users everywhere. I must admit, however, that the BC groups never let me down in terms of connecting with SAS users, learning new SAS tricks and, critically, laughing. Yes, we have fun together: a lot of fun. Remind me to tell you all the story of 'The Big Cookie' incident in Victoria at a previous meeting sometime: the Cole's notes version is that I was (almost) bested by an enormous virtually-raw cookie the size of a dinner plate, with both executive committee members and the kitchen staff taking bets on when I would give up. I could also tell you about the time that 6 of us gathered around a tiny table at the trendy restaurant Guu in Vancouver, eating tiny plates of food and drinking large saké-flavoured mojitos until our laughter was the only thing you could hear in the otherwise noisy restaurant.


I could also tell you tales of incredibly dynamic and engaged meetings. I've seen the SUAVe group erupt into fierce - yet friendly - debate around the virtues of a variety SAS programming techniques in the 'Solution To the Posed Problem' element of their meetings... and I've grinned in Vancouver as Colleen McGahan tells the 75+ attendees the rules of their famous ice-breakers: an extremely effective technique for bringing together strangers into the common bonds of SAS-founded friendship. I have no doubt that the next two days meetings will be just as amazing. If you're in the area and can attend, please do use the registration links found on the websites I've linked above: I'd love to see you!



Two more quick notes from me before I scramble to complete my packing. First, my colleague - and SAS rookie! - Kerry Blanchard will be headed to Ottawa for their massive user group meetings on Wednesday. She'll be 'guest posting' her experiences and impressions shortly after that, so do stay tuned! There's truly no rest for the wicked (or for me either! ;) ): I land back in Toronto around 11:30pm on Wednesday, my head touches the pillow for a few minutes, and I'm off to help with the Health User Group in Toronto on Thursday, November 18th. I hope that Kerry or I will see you at one of the four meetings this month!



Time to fly, so I'll say so long for now. Here's hoping you all have a fantastic week and I'm looking forward to posting lots over the next few days... now, where's my passport?

Tuesday, November 9, 2010

MONSUG the Magnificent!

Sitting back at my desk in Toronto, I can't help but wish I was still in beautiful Montréal. There's something magical about that city... whether it's the warm people or the wonderful food, I find myself consistently sad to leave. I suppose it's a Québec thing moreso than simply a Montréal phenomenon: I recall being just as wistful when departing Québec City a week ago! Ah well, at least I'll have one more chance to visit Montréal on December 1st for the Forum analytique d'affaires SAS de Montréal so I suppose I shouldn't complain. You'll find the agenda for that meeting - featuring Vice-President of Credit Risk Data Solutions at CIBC, Mr. Rick Miller, reprising his incredible 'Supercharged Analytics' talk from last year's SAS Global Forum - on the link I just provided.

Meanwhile, I have stories to tell of MONSUG!

The meeting was extremely well attended considering that the executive committee and I were forced to settle on a Monday morning due to venue availability. Almost 100 individuals turned up for a fantastic morning of conversation and presentations. Éric Lacombe and Mathieu Gaouette are the two gentlemen who do such a fantastic job of maintaining the MONSUG website, finding and supporting local guest speakers and helping to spread the message about the meeting to their contacts in the Montréal community: and it truly is a community in every sense of the word. Allow me to illustrate by referencing yesterday's meeting.

Éric and Mathieu made themselves completely accessible to the community by MCing the meetings and working at the registration desk. I watched the two of them greet colleagues and acquaintances from a whole host of industries and SAS environments as old friends. It was great to see people connecting through the common bond of SAS once again! The camraderie and open conversation between the SAS community and the many representatives of SAS Canada who were on hand put an exclamation mark on the sense of collaboration which clearly exists between SAS users and SAS employees.

This sense of collaboration really came to bear during the meeting itself. I need to single out Rupinder Dhillon of Toronto for really stepping up to the plate at a difficult time during the meeting. Some confusion around the MONSUG meeting date meant that our keynote speaker was unavailable: we needed to deliver a valuable presentation to the room, we had an hour of agenda time to fill, and we needed to figure out what to do over the break.

'No problem', said Rupinder.

Fortunately I had a presentation I've previously delivered at other user group meetings on the topic of formatting and reporting using Enterprise Guide on my machine. Working quickly during the break, Rupinder began tweaking the data in order to demonstrate both how to move older EG presentations to a newer version as well as how to take advantage of parameters within EG 4.3 to facilitate users accessing the right type and amount of data in the most efficient way possible. Within 30 minutes, a new presentation had been born! Unbelievably impressive. This willingness to step into the breach is partially why Rupinder won the Customer Value Award last year: nominations are now being accepted for NEXT year, might I add! I'm looking forward to getting one lucky individual down to this year's SAS Global Forum in Las Vegas from April 4-7th.

I would also like to take a moment to salute Nadia King of the Banque Laurentienne. She delivered her first ever presentation, and to glowing reviews, might I add! I couldn't tell she was a novice at public speaking and given the reaction of the audience, nor could they. Great job, Nadia! I hope we can see more presentations from you moving forward.

You'll find the presentations from the MONSUG meeting on their website within the next week or so. If you weren't able to attend, I invite you to join us for the spring meeting. We already have a few presenters lined up to deliver some incredibly interesting talks. Once we have full details around the date and agenda, you'll be able to find information in the MONSUG LinkedIn group, Facebook group and of course, on the MONSUG site itself.

Special thanks to both presenters and to both executive committee members. Adversity was overcome and the attendees left happy which is always the most important goal! I'm very much looking forward to my return to Montréal for my last road trip of the year in about a month's time.

In the meantime the blog posts will be coming fast and furious over the next few days. I have lots to tell you about. Next week features 4 separate meetings spread from one of the country to the next. I'll be in Victoria and Vancouver for their respective meetings on Tuesday and Wednesday and flying home to facilitate the Health Users Group meeting here in Toronto next Thursday. My colleague Kerry will be attending her first solo user group meetings in Ottawa at the same time: you're in great hands Kerry, the Ottawa groups are incredibly well organized and full of wonderful people. The following week, my manager Wally will be attending the Halifax meeting which is rapidly growing in attendance... what a flurried frenzy of frenetic activity! I wouldn't have it any other way.

Until next time...

Sunday, November 7, 2010

A Fall Day in Montréal

One slightly uncomfortable - yet thankfully short! - plane ride and I've landed in Montréal for a whirlwind tour. I'm very grateful and excited to be travelling with Rupinder Dhillon from Toronto as the featured speaker at tomorrow's MONSUG meeting! Rup is well-known and admired by SAS users in the greater Toronto area for her expertise of SAS Enterprise Guide and coding techniques as well. This time, Rup will be exploring Enterprise Guide 4.3! I'm very excited to see what she does and how it works.... excited and a bit nervous. She'll be using my machine and I had EG 4.3 installed on Monday! Let's hope we're bug-free... :)



Tomorrow's meeting also features Jean Hardy reprising the talk he gave on passing results to and from Excel last week in Quebec City as well as Nadia King who will be looking at the A.I.D.E. methodology. It promises to be a great meeting with around 130 registered. I'm looking forward to an energetic, boisterous room as per usual.



I'm also very excited to see the MONSUG executive committee, M. Eric Lacombe and M. Mathieu Gaouette. The last two SAS Global Forum's I've attended have been punctuated by having a fantastic time with both of them. Lots of laughs and great meals, to be sure! I'm looking forward to more of the same following tomorrow's meeting.



Speaking of SAS Global Forum, I would be remiss if I didn't point out that registration officially opens this Monday, November 8th. This year's edition is taking place in beautiful Las Vegas, Nevada from April 4-7, 2011. I will be attending and will be hosting the (in)famous Canadian Night Out... this year's theme, TBD (we're moving away from the Canadian Trivia model: while lots of fun, it's getting a little too dangerous!). the conference is a tremendous opportunity for learning, networking and socializing with the greater SAS global community: don't miss out if you can help it.



My next few weeks are going to be really hectic ones. There are a whole host of meetings taking place across the country: I'll be in British Columbia next week while my colleagues attend the Ottawa and Halifax meetings which are right around the corner. I'll be running the Health User Group in Toronto as well, and I'll have one last trip in me: back to Montréal for the Business Analytics Forum with Rick Miller of CIBC on December 8th. With one final Toronto Area SAS Society meeting in mid-December, I'll be poised to wish everyone tiding's of the season and enjoy a well-earned break myself... but in between now and then, I'll have lots to say in this space, so do stay tuned!



I'll hopefully be able to get my thoughts on paper tomorrow following the meeting to tell you all about it; if not tomorrow than certainly very soon. For now though, my mind and my stomach are one and the same; I can't wait to go out with Rup for some delicious food and drink and talk SAS for a while...

Until then!

Tuesday, November 2, 2010

There and Back Again

I must offer apologies to J.R.R. Tolkein for appropriating the title of the book authored by his character Bilbo Baggins as my own. However, I think it's appropriate for a few reasons. This has indeed been a whirlwind trip to Québec City for the last time in 2010 for the Club d'Utilisateurs SAS de Québec: it truly has been a 'there and back again' experience... a little surreal and a little disappointing from my perspective. A 7:00am flight out, a lunch/meeting/dinner and an 8:20pm flight home again: whew! This is made even more painful because I absolutely LOVE Québec City. As I told several of the attendees, I first fell in love with la belle ville de Québec at the tender age of 12. Yes, it was actually a girl moreso than the city itself, I must admit: ah, young love... for those who have been to QC, you know exactly what I'm talking about! It truly is the Paris of North America and it's hard to not give in to one's romantic inclinations especially in my advancing years (I'm not telling) when appreciating the architecture, the culture and the people in this amazing city.

The title 'There and Back Again' could also refer to the amazing consistency of this group. Once again, Louis-René Rheault and the executive team have led the way to a phenomenal meeting. 108 people attended today's gathering at the Université de Laval, a meeting which is an example of collaboration in its purest form. Each member of the committee has an agreed-upon role which is executed to perfection given the strengths of the individual in question. Our invitation was sent out to SAS users known to myself, to the Québec City executive committee, and through the SAS offices in Montréal and QC. The agenda itself was pulled together by local support and featured first-time presenter Ishmael Coulibaly who presented on data mining fundamentals in an Enterprise Miner context. Great job, Ishmael: the audience sure didn't comment upon your relative 'newness'. I hope we'll see many more presentations coming forward from you! There are many moving parts here, and all work flawlessly with each other. This is in many ways a model for others to be sure.

Speaking personally, 'There and Back Again' refers to my determination to improve my French language skills. La langue du Molière est tellement belle et je suis determiner à retrouver mon grammaire et mon vocabulaire. I studied intensive French for 11 years in school including half-days spent in immersion... and every time I return to QC, it pains me that I'm not communicating as effectively with everyone as I could. Everyone is so incredibly patient with me as I fumble through conjugations, verb tenses and meanings in my head... and I have yet to hear someone cast aspersions on my efforts. Thank you, QC, for your patience!!! I make you this promise. Within 2 years, I will give a 45 minute technical presentation on Enterprise Guide, completement en francais.

Québec in general is a special place: a community unto itself in many ways. Fiercely - and rightly! - protective of the beautiful culture and language which continues to be celebrated here, there is still an openness and willingness to entertain a poor guy from English Canada which I find heartening. In some ways, this acknowledgement of our differences actually results in a celebration of our similarities. We are all SAS users or supporters, and despite the occasional communication barrier with words, we can always make our SAS-based thoughts and questions ring with clarity through a simple code node or process flow. In many ways, the executive committee and their willingness to collaborate and enter into dialogue is a model for what I hope to continue to grow between SAS users across the country. I hope QC can be an example of the great results which can be achieved when superficial differences are put aside and we all revel in speaking the common language of SAS.

I'd also like to single out M. Jean Hardy and M. Sylvain Tremblay for their outstanding contributions to this meeting. Sylvain is a close friend and SAS Education stalwart. He's a road warrior like myself and one of my first choices for travelling companions - and not just by me, I should add! Sylvain's students are constantly asking after him and he never leaves a meeting without making new, great connections and helping out a SAS user with an issue they might be having, no matter how small. Jean Hardy is a legend in Québec City: teaching SAS and supporting the user community since before SAS existed as an entity in the province, Jean will also be presenting on the topic of moving results into and out of Excel at next week's MONSUG meeting in Montréal on November 8th. Jean also presented in the midst of some difficult circumstances for himself personally and I want to take a moment to both thank him and offer him the support of not only myself but the SAS user community in general.

All in all, I'm flying home to Toronto sad to be leaving QC and my friends on the executive committee so rapidly, but thrilled with the growth and strength of the community I leave behind. With dates already planned for 2011, I already have the next meeting of the Club d'utilisateurs SAS de Québec circled on my calendar. Beyond that, I've already made plans to travel here in the summer with my girlfriend to spend some time off-work with some of the executive members.... and what more can a Community Manager ask for than to be welcomed so fully into this wonderful culture and group?

Looking forward to continuing my adventures in this beautiful province next week and as they say here in Québec City: à la prochaine!

Sunday, October 31, 2010

Of Cold Temperatures and Warm Hearts in Edmonton

As I mentioned in my earlier post, the two Alberta meetings were truly inspiring. The Edmonton SAS Users Group (eSUG) has quickly grown in size and in engagement over the past few years and given the handshakes and smiling faces I saw at last week's meeting, the sense of fellowship and familiarity amongst the SAS users is growing just as quickly.

I must admit that upon arriving, my joints did start to creak like the Tin Man in 'The Wizard of Oz'. No, I wasn't trying to get an early start on Hallowe'en... although I will neither affirm nor refute any rumours of the lengths I will go to in order to satisfy my sweet tooth. Rather, it was the -12C temperature and snow which was falling through the air that caused my body to seize. My first taste of winter since... oh, last winter. I must admit, I wasn't prepared. However after a brief adjustment period it actually became quite refreshing: pleasant, really. I have a good feeling there's much more where that came from in the near future like it or not.

Earlier I alluded to the sense of familiarity between attendees at the user group meeting. I had a good feeling upon arriving at the meeting that this would be the case. A few members of the SAS community joined the eSUG LinkedIn group which had been fairly quiet up until that point and the eSUG Facebook group - as it was rightly pointed out to me by one of the contributors - actually had several commenters besides myself: a nice positive in these early days! I hope we'll see more activity in both places as we begin to offer more and more valuable content for Edmonton users. I was further buoyed by the knowledge that at the time, almost 80 people had taken in the video interview I conducted with guest speaker Marje Fecht. Given her reception in Calgary the day before, I was quite sure the Edmonton audience would be just as enthusiastic. All the signs pointed to a fantastic meeting, and I wasn't let down.

If one individual can personify the temperment of this group, it would have to be Doug Dover. The President of the group, Doug is hardworking, personable, dedicated, approachable and considerate. He demonstrated why he's been instrumental along with the other executive committee members in helping to grow and bring together the SAS user community in Edmonton. Doug arrived at the meeting with an enormous box full of agendas, evaluation forms and the other staple of a meeting: 100 notepads and pens. The box also held the prizes traditionally awarded at random by way of conclusion as well as speaker gifts for the 2 guest speakers. Sadly, the box didn't contain a few of the most important elements of the meeting. Longtime eSUG supporter and executive committee member Rick Watts was missing his first meeting in 5 years as he was under the weather, and his wife Liz was staying close at hand. Neither did the box contain the voice of Doug Dover, callously stolen by illness a few weeks earlier and mysteriously missing since.

Doug asked to introduce the meeting regardless of his vocal challenges, with one specific request. He held up two cards he had bought and asked everyone to come up at the break to sign them. They were get well cards for Rick Watts from the eSUG community. The break did see a steady stream of attendees coming to the table to sign the card, a real testament to the strength of the sense of togetherness of the group. Here's to you, Rick.

I also couldn't help but remark that the eSUG group had (almost) reached the 100 attendee level! Large groups of friends and strangers clustered together around circular tables and exchanged pleasantries and contact information. This is in no small way thanks to the work of a fantastic executive committee. Taking a little time out of their schedules to help me co-ordinate local presenters, reach out to their colleagues about the meeting and to address other details is of immense assistance. Frankly, it would be difficult to pull off meetings successfully without them! Thanks a million, guys.

My final thoughts on the meeting:
- the presentations were of course tremendous. Marje Fecht once again fostered robust discussion through her talks, and local SAS guru John Kirtz of Snowy Owl software almost had too much to share with his demo and presentation on ODS statistical graphics and the graphics template language new in version 9.2. For those of you unable to attend, have no fear: the presentations will be made available here imminently.
- it was great to see SAS users of all different levels at the meeting. I myself chatted with someone who was a re-energized lapsed SAS user, a woman just starting out with Enterprise Guide, two potential presenters for SAS Global Forum, a discussion around social media resources from a SAS perspective, and a few technical discussions of a variety of types to boot! It's always great to converse with users on the ground, and I sure did get to do a lot of it.
- post-meeting, I think we may have experienced a first. Our traditional user group executive committee lunch was held at what has to be the most inland lighthouse in western Canada; a surreal experience on the outskirts of the Prairies!

I mention on the LinkedIn group page as well as in the Facebook group that I have a set of notes which were left behind at the meeting. I'm happy to scan and send them to you if they're yours: I'd hate to see all the work go to waste. Connect with me, and they're yours again.

Thanks again Edmonton for a great meeting. It was wonderful to meet and see so many of you and I'm very happy to see the group growing closer together even as it grows larger.

Next up for me: the return to Quebec City! Mais oui, I'm headed there and back in a single day for lunch, a user group meeting, dinner, and a flight home. What a whirlwind! I'll be sure to have more in the coming days.

Friday, October 29, 2010

New Friends and A Growing Community: The CSUG Experience

How do I sum up the experiences I've just had succinctly? Well, those of you who are regular readers know that I am rarely succinct. So I suppose I'll just let it all out, as I normally do.

I'm sitting at the Calgary airport waiting to board a flight to head back to Toronto. These two Alberta-based meetings were truly excellent in terms of energy and engagement. For the sake of doing both justice, I'll speak to each of them in individual posts. Let's start in Calgary, shall we?

Around 30 people attended the meeting on Tuesday at the SAS offices in Calgary. On the logistics side, I need to acknowledge a very important person in my world: Ms. Jessica Saviskoff. Jess always goes above and beyond in terms finding outstanding venues and providing amazing support through logistics and registration. A cheese plate at a user group: really? AMAZING. The users notice, comment and appreciate these touches.

The meeting itself featured my good friend and SAS legend Marje Fecht. Marje is a real dynamo. Her presentation skills are second to none, and her SAS knowledge is beyond extensive. Nowhere was this more visible than in the CSUG meeting itself: questions were flying, white boards were being written upon and the room was buzzing!!! In fact, the demand for Marje's talks was so great than she connected immediately with 2 individuals who required the presentations for projects they were working on at that time. She was more than happy to oblige! Her talks - on optimizing SAS coding and bridging the gap for programmers struggling with Enterprise Guide - will be posted today here. Beyond the presentations, the success of Marje's talks was rivalled only by the tremendous engagement on the user side.

One of my goals in building, supporting and connecting the SAS user community across the country is to engage people who haven't been aware of the richness and value of connecting in our world. Perhaps this is because they're new SAS users, or perhaps it's because they didn't have any insight into the options that were available. I was very pleased that two of these individuals chose to help support the Calgary community by joining the executive committee. Thanks, Mussie and Malcolm!!! We had a wonderful lunch conversation about SAS, how we can support SAS users in Calgary through social media, and much more. I can't wait to get rolling with you gentlemen on planning the next meeting.

My final thoughts on Calgary: what wonderful engagement through social media. I have a new friend, Asif, who began following me through Twitter in mid-meeting! He's already made some suggestions around content for the next meeting, and we'll certainly dialogue about it further. The CSUG LinkedIn group has seen a jump in members, and I'm excited to start delivering great content to them. This is the true value and power of social media in my opinion. We can now carry on our conversation beyond the 2 meetings a year. We can support each other, help each other grow professionally and really start to build each SAS users personal 'brand'. And what a valuable brand it is!

Coming up this evening: my thoughts on the Edmonton meeting. Perhaps I'll even post some pictures from my day-trip to Banff afterwards: would you guys like to see what a wild herd of about 150 elk can do to a golf course? I'd be happy to share it with you.

More this evening after I touchdown in Toronto, but for now, see you soon Alberta!

Sunday, October 24, 2010

To Alberta!

As I sit here at Pearson Airport in Toronto, I'm grinning from ear to ear. Perhaps it's because of the long-overdue free WiFi that's available at my home airport... but more likely, it's anticipation of the Alberta user groups which is giving me such glee.

Featuring Marje Fecht - SAS legend and good friend - these meetings promise to be extraordinary. If you haven't met Marje or heard her speak before, you're in for a real treat. She truly is amazing. To get a sense of her and what she can bring to the table, have a look at the YouTube video interview I recorded with her a few weeks ago.

Tuesday's meeting of CSUG at the Calgary offices (details can be found here) is causing me minor anxiety... for all the right reasons! With 40 people registered, I'm worried we won't have enough space for everyone. No problem: I'll hang out the window by my fingernails if I have to. This prospect frightens me greatly not because of the height, but because of the cold (I hear there was snow on the ground in Calgary this morning: yikes!). I'm going to be delivering my 'SAS and Social Media: What's in it for Me??!?' presentation for both the Calgary and Edmonton groups and if the Greater Toronto Area groups are any indication, the presentation should hopefully be well-received. At the very least, I hope it stimulates some robust conversation.

On Wednesday, Marje and I will be in Edmonton, where registration has almost hit 100 for the eSUG meeting! It's hard to believe that a few years ago, the executive committee was down to a solitary individual and the group was having a tough time coming together. Amazing what the power of the SAS community can achieve when it has a common goal and direction. I hope I can capture some of this energy and sense of common purpose at the meeting and really give our social media initiatives a boost of supporters.

Following the meetings, I'll be taking an extra day and a half to relax in nearby Banff with Marje and her husband Rob. I've never been to Banff, but I hear it's gorgeous. Something tells me I'm really going to enjoy sitting in an infinity whirlpool trying to decide what's bubblier: the champagne in my glass, or the water in the tub. Ah, if only we could all have such tough questions to answer all the time, life would be grand, no?

I'll have feedback from Calgary within a few days, and on the horizon, I see 'Quebec City: The Return!' as an upcoming post...

Hope to see you in Calgary or Edmonton!

Thursday, October 21, 2010

Stand & Be Counted: Data Miners Weigh In On the Long-Form Census Debate

I had high hopes for the Data Mining Forum on Wednesday, and I wasn't disappointed. I was absolutely fascinated by Stephane McGee and Obaid Rahman's presentation on how statistics are used in the insurance industry: incredibly appropriate fare for World Statistics Day! The 100+ attendees were buzzing with questions as we pushed deeper and deeper into break time. It's always great to see such interest generated out of a presentation: great job, Stephane & Obaid!

Victor Zurkowski then told a story of how he came to be aware of the possibilities of net lift and return optimization. A slow smile spread across my face as a slide of the SAS Tech Report was splashed across the screen. Edited by Waynette Tubbs (I highly recommend following her on Twitter, by the way: she always seems to have interesting things to say) it's full of SAS tips & tricks, news and developments in the SAS world and a whole host of user support options to boot! In no small way is our own insights newsletter a reflection of this resource. It was a mention of net lift in Waynette's editorial of an issue of the Tech Report which generated his interest in maximizing net lift and return, and he applied the concept in a fascinating way... you can find out more once his presentation is posted!

I'd been looking forward with baited breath for the panel discussion. As an admitted data junkie, I've been a little too obsessed with this topic since it came to the media's attention in June. In fact, the panelists and executive committee of the Toronto Data Mining Forum could easily attest to this by sharing the four pages of background resources I provided to help prepare for the discussion. A little overkill, perhaps.

At any rate, the Managing Director of Redwood Data Sciences, Mr. Chris Osborne, skillfully directed questions around the loss of long-form census data to members of the direct marketing, financial services, health information and consulting verticals. We hope to make some of the highlights of the discussion available soon, so stay tuned!

The presentations are being cleaned up a little as we speak and should be posted sometime next week on the Toronto Data Mining Forum website. If you can't wait, I've posted my social media presentation on SlideShare within LinkedIn: feel free to have a look, I welcome your feedback.

Next up for me: a week-long trip to the west. Calgary and Edmonton, I'm incoming! To get some insight into our guest speaker - the legendary Marje Fecht - feel free to check out this video interview I conducted with her a few weeks ago.

Thanks again to the fantastic executive team of the Toronto Data Mining Forum. They are truly emblematic of the sense of community and support we've been striving to build between groups of data practitioners. Without their help, the presentations and panel discussion would not have been as compelling. Thanks once again, team!

Until the next time, I'd like to present the same question here that I posed to the Data Mining LinkedIn group. Will your organization be impacted by the potential loss of demographic data caused by making the long-form census voluntary? If so, how? Let's not limit it to your own organization either: what do you think some of the ramifications might be?

I look forward to your thoughts!

Saturday, October 16, 2010

What Superpower Would YOU Choose?

This was the question which occupied the 42 attendees at the Golden Horseshoe SAS User Group meeting on Friday morning during their networking break. As I walked around the room speaking with people, I caught snippets of SAS-related conversations being discussed with as much passion as the icebreaking topic. Champions of a variety of abilities struggled to convince their peers that their power provided the most advantage, for example, the convenience of teleporting versus the majestic power of flight. At the same time, the utility and ease of use of macros was a hot topic in certain corners as well!

I myself argued for invisibility for my superpower... how great would it be to go anywhere, do anything? Hours of operation would be meaningless: I could hop a flight to Paris, sit in an empty seat unnoticed, and drive the poor security guards at the Louvre absolutely batty as I set off alarms on a self-guided, private tour of the museum after hours! Given my deep love of archaeology, paleontology and history, I might be there for quite some time.

While we couldn't agree upon a universally-desired superpower, one thing I think we all can acknowledge is that yesterday's meeting was extremely successful. I was so pleased to see members of the Golden Horseshoe community connecting with each other at the meeting, and even more pleased to find a few messages waiting for me in the Golden Horseshoe LinkedIn Group. I'm optimistic that I managed to hit some of the right notes during my 'SAS and Social Media: What's in it for Me?!?!?' presentation, given the feedback I've had already. Speaking of which, I've posted that presentation in .pdf form on LinkedIn: if you'd like it or have questions, feel free to connect with me!

I'd like to single-out Debbie Weisensee of McMaster University and Ron Kaine of Bell Canada for their amazing presentations as well. Debbie reprised the talk she gave at TASS, once again opening up the hood and demonstrating how McMaster is using SAS for reporting, analyzing and distributing information. The demo went extremely well, and I think more than a few people were impressed by what she was able to do! In his presentation, Ron Kaine made it clear that as a business user of SAS, he enjoyed leveraging the power of the analytical and reporting capabilities of Enterprise Guide. In what will hopefully be the first in a series of small talks, Ron demonstrated how a commonly utilized procedure - PROC FREQ - could be run through Enterprise Guide, and why. Great stuff, Ron! These presentations will be posted this week on the GHSUG website for those interested in more information. Better yet, join us at the spring meeting on April 15th, 2011! That gives you plenty of time to figure out which superpower would best suit you.

Have a great weekend, everyone, and I'll be posting mid-week to give you feedback around the highly-anticipated Toronto Data Mining Forum!

Thursday, October 14, 2010

World Statistics Day Meets Toronto Data Mining

Sometimes, if we step back and take a moment, it's easy to appreciate how disambiguous the universe can be. As many statisticians will tell you, synchronicity occurs all the time in the world around us: unique cause and effect layers upon unique cause and effect, weaving a complex tapestry of correlation and interaction between seemingly disparate variables. I've often felt the thrill and shiver of discovery when exploring data in this way... and I find that the same principle can be happily applied to next week's Toronto Data Mining Forum.

As you might imagine, planning user group meetings requires a lot of thought and collboration in particular around logistical issues such as dates, times and venues. Planning for this fall season actually began in June! I can assure all of you that while I would LOVE to take credit for having had the foresight to suggest that October 20th - World Statistics Day - was the ideal day for a data mining symposium, but sadly, I cannot. There's that conspiratorial universe again... and this truly is a fortunate accident of synchronicity. Who better to celebrate World Statistics Day with than a room full of some of the best and brightest data miners in the greater Toronto area?

The date and sense of occasion play a distant second in terms of the most compelling of reasons forattending this meeting. As you can see here on the Toronto Data Mining Forum webpage (an opportunity to register for free appears with the agenda), we have a topical and intriguing morning of data mining-themed discussion to be delivered to you for your digestion!

Many of you may be aware that the Government of Canada recently made a decision to repeal the mandatory long-form census. As data miners, this must raise some eyebrows in concern and cause cold sweats to break out on a few foreheads. What will be the ultimate outcome: will we see no negligible change in the quality and amount of public data? Or, will this have negative effects on planning for social assistance programs, sociodemographically-reliant programs, marketing campaigns, and other data-driven initiatives? How about the health industry: will this impact their ability to administer programs and processes which are heavily data-driven? It's an exciting topic which I think lends itself extremely well to this forum.

I'm very pleased to announce that we'll have a very strong panel of senior data miners to help explore this topic. Featuring representatives of the financial services, marketing intelligence, health and business analytics verticals, I'm really, REALLY excited to listen in! I hope that you'll be able to join us and lend your voice and opinions to the conversation as well.

In addition to the panel discussion, I'm also thrilled that Obaid Rahman of Intact Insurance will be giving the group some insight into how statistics are used in the insurance industry. We don't often have insurance-based talks at our user group meetings, so don't miss this presentation. Finally, Victor Zurkowski will be referencing some of his own work at one of the major banks in his presentation on maximizing net lift and return.

I'll be in Hamilton tomorrow for their user group meeting and reporting back on it shortly. I do hope that the amazing synchronicity which happily married the Toronto Data Mining Forum with World Statistics Day also means that you and I will connect on October 20th as well!

Tuesday, October 12, 2010

En Route to Steeltown North!

I don't know about you folks, but Thanksgiving has to be one of my favourite holidays - in terms of food for sure! I like to think of it as a dry-run for the huge family feasts which inevitably define the December holiday season around my household. This years' lessons learned: you can never have enough mashed potatoes and gravy, yams and cinnamon-flavored apple slices are a heavenly combination, and nothing - but nothing - beats a long walk on a beautiful cottage trail to take the edge off of tryptophan overload. I hope you had a great long weekend remembering all the people in your life for whom you are truly thankful.

High on my list of people I'm thankful for in the SAS world are the amazing individuals behind the Golden Horseshoe SAS Users Group (GHSUG). This innovative and approachable executive committee have consistently delivered exceptional value to their attendees, and the meeting taking place this Friday, October 15th, will be no different, I'm sure! Meeting out of the ArcelorMittal/Dofasco offices on Burlington St. East in Hamilton (you can find a map at the bottom of this page), this small but tremendously engaged group always features some of the most enjoyable and informative presentations in the SAS world... and the conversations which take place afterwards are truly inspiring. These are also some of the most accessible SAS user group meetings for individuals new to the SAS world. Graduate students are often featured presenters, and this is balanced by presentations from the manufacturing sector by SAS users with over 20 years of experience on average! Truly, it's the best of both worlds.

In fact, GHSUG is one of the leaders in terms of nurturing and growing the SAS user community. The executive committee members support new presenters by mentoring them through their build process: making suggestions, giving hints, and being generally supportive. It's also a forum for brand new SAS customers to get a sense of what the user group community offers. I recall that a year ago, one of our sales executives sent representatives of a new SAS customer to the meeting. Brand-new to the SAS world, their questions were quite broad and general. The other attendees and executive committee not only made them feel welcome and addressed all of their questions, but several individuals offered to assist the group beyond the meeting with some areas of confusion. It's this spirit of collaboration and support which makes me happiest: SAS users helping other SAS users, there's very little more rewarding in my world than when that type of connection is made.

If you're in the Greater Toronto Area and would like to benefit from the outstanding connections which can be made at GHSUG, feel free to check out their webpage for agenda details and an invitation to register. Remember, it's always free to attend!

The one thing my post-Thanksgiving stomach is NOT looking forward to right now? The traditional massive lunch with the executive committee at King's Buffet following the meeting. Oh, my aching stomach...

Stay tuned for a post later this week with more detail around the exciting Toronto Data Mining Forum taking on October 20th at the SAS offices.

Friday, October 1, 2010

SAS, Hockey and Prairie Life

What do these three things have to do with each other? Hockey fans are definitely awaiting the onset of the new NHL season, and the Winnipeg and Sasktoon user groups are rapidly approaching: but other than that, what's the connection? Speaking personally, these words trigger one of the earliest memories I have of my early days here at SAS Canada.

My colleague Tim Trussell - who formerly occupied my role - is a pretty amazing guy. Sharp as a knife and young as our sun, Tim shines just as brightly in the SAS universe. In my early days, I looked up to him immensely for his ability to offer presentations to user groups of a slightly different flavour. It's great to have case studies. Insight into how SAS is used in banks, universities, health organizations and government branches is always valuable and interesting. But Tim added an interesting wrinkle, one which I've tried to adopt in my day-to-day work here at SAS: fun.

Yes, fun. It's fun to play with data. It's even more fun to analyze and derive insight from it! True, this is my technical side talking, but I would be lying if I said I didn't feel a thrill of electric excitement run up my spine when opening a raw data set for the first time... oh boy, my inner SAS-user is definitely coming out to play!

I bring up the connection with Tim and the prairies because he delivered one of the most interesting presentations I've ever seen a few years ago at the Saskatoon and Winnipeg user groups. Entitled 'Selecting NHL Teams Using Linear Regression With SAS' , this talk married two of Tim's great passions together in one, fun-filled presentation. Tim demonstrated complex statistical processes and models based on actual National Hockey League data . This basically opened the kimono on his hockey pool selection strategy! Given that Tim is always at or near the top of his pools, all of you hockey junkies out there may want to give his presentation a look before the launch of the season next week.

Better still, join us in Saskatoon and Winnipeg on October 13th and 14th respectively for the user group meetings. We have dynamic agendas for each, featuring SAS Canada's Rob Wilson with an updated version of his very popular 'tips & tricks' presentation, and a variety of local presenters. I'd also like to mention that my friend and colleague Jamie Farnell, SAS' Education Program Manager for colleges and universities, will be attending and presenting as well. For all of you University of Saskatchewan and Manitoba readers, I'd highly recommend connecting with Jamie! He will be able to give you good insight into the recent SAS On Demand for Academics initiative, which provides complimentary SAS software to teaching institutions which qualify. He'll also be delivering some great content around how to get the most out of social media as a SAS user, a presentation build by yours truly!

I hope everyone has a great weekend, and that you hockey fans are strapped in and excited for the start of a new season. Hopefully, with Tim's help, you'll be able to achieve success in your own hockey pools this year... and if you want to say thank-you, I understand he's very partial to ginger-flavoured beer.

Thursday, September 23, 2010

Quebec City Analytics Forum: What A Launch!

I'm sitting here at Lesage airport in beautiful Quebec City, as Lady Gaga's 'Pokerface' - the Muzak version - wafts gently out of the Duty Free store. And as I look around, I see a few others with raised eyebrows as they recognize the tune and the STRANGENESS of this version! I mean, a harp: really?

I truly do have magpie-like tendencies sometimes. Easily distracted by the music, I've now wandered off on a tangent. Where was I? Oh yes...

I sit here in the beautiful sunshine a mere 90 minutes after one of the most successful SAS user forum launches that I've seen. What a meeting! There were just over 30 attendees for the new 'ville de Quebec forum analytique de SAS'. Building on the incredible success of the existing 'club d'utilisateurs SAS de Quebec', the creation of this group represents a commitment to supporting and celebrating the wide diversity of SAS users. The 'club' has done a phenomenal job of supporting base SAS coders and programmers for many years now: yet as SAS has continued to develop and new solutions have hit the market, new types of users have also emerged. Data miners are using Enterprise Miner to plumb the depths of their information. Analysts are using Enterprise Guide to leverage powerful analytics in a visual setting and report on it with confidence. DataFlux users are up to their elbows in dirty data, trying to make sense of it all.

The meeting I just attended featured legendary SAS instructor Sylvain Tremblay (OK, a legend to his students, and to me). Sylvain showcased JMP for a very intrigued audience. He was followed by Sylvain Haince of the Ministry of Health and Social Services, who connected to his environment and demonstrated how SAS was being used at the Ministry to slice data, analyze and report. Powerful stuff! The audience was very engaged, asking many questions of the presenters and validating the importance of this new forum. No further proof is needed than the fact that 2 indivduals immediately stepped forward as volunteers for the new group's executive committee! Amazing!

I have to take a moment to comment on QC itself. What an unbelievable city. An opportunity to practice my French skills in the Paris of North America? Sign me up, anyday. In fact, why don't you join me? If you're in QC or Quebec in general, the next opportunity to engage with the SAS user community will come on November 1st with the semi-annual 'club d'utilisateurs' meeting. Also coming up in Quebec: MONSUG on November 8th and the Montreal Business Analytics Forum on December 1st. I hope to see you at one, if not all, of the meetings!

So what's next on the list? Well, you may see a surprise celebrity blogger shortly! One of my colleagues is going to the Saskatoon and Winnipeg groups in a few weeks time, and I'm curious to get his feelings. As for me? I'm looking forward to the Golden Horseshoe SAS Users Group meeting on October 15th in Hamilton...

I'll have more coming your way soon, SAS users! Until my next post, I hope all is well with you and yours, and hope to see you at a meeting in your area..

Tuesday, September 21, 2010

Goodbye, Summer!

Well, SAS Users, I continue to recover from what can only be described as a roller-coaster of a week! 2 major user group meetings, a SAS-sponsored charity soccer tournament and a wedding: all in the span of 6 days.

The Toronto Management Exchange meeting took place last Tuesday. This invite-only event has become a real incubator for frank, open discussion by executives around SAS enterprise-wide solutions and services. The most recent meeting featured Aiman Zeid who works for SAS Global Practices in the Business Intelligence space. Aiman's particular gift is quite remarkable. He and his team will assess an organization's BI strengths, assets, shortcomings and requirements and suggest insititutional changes which might help realize an improvement in overall business processes. A small but engaged group of individuals from the financial services industry were able to learn through Aiman thanks to a Business Analytics Competency Centre mini-workshop. It was extremely exciting to listen to the robust discussion which took place!

The first TASS meeting of the year was held last Friday. I must admit, this event is a little more up my alley than the Management Exchange. I have personal relationships with many of the users in the greater Toronto area, and TASS is always a wonderful opportunity for me to get together with all of them. This meeting was no exception! Around 150 people attended over the course of the day, enjoying incredible presentations from a variety of presenters. Some were quite technical, like Dragos Capans' talk on 'Using the Descriptor Portion of a SAS Data File'. Others were incredibly in-depth examinations of front-to-back processes, such as Debbie Weisensee's amazing talk on how they used stored processes to make life easier at McMaster University. This was a truly amazing presentation. Debbie spoke about the business reasons behind building their environment, as well as acknowledging some of the roadblocks they had to overcome. Both technical and business-oreinted, this was really fascinating stuff!

Finally, the hit of the morning TASS session had to be Wayne Levin's presention entitled 'JMP & SAS: 1+1= ∞'. I've been fortunate enough to see Wayne present a few times, and I'm always floored. He's a naturally gifted speaker and is without question the greatest authority on JMP (in my mind) here in Canada. Wayne's breakout session was absolutely overflowing, a testament to the audience's interest. Wayne was also good enough to leave behind some information which might benefit you as well! If you're curious about JMP, Wayne has offered - for a very limited time! - free JMP e-learning. I can tell you that more than a few people wrote down the information Wayne provided, and I'm happy to pass it on to you as well. Simply go to http://predictum.com/elearning/ and click on the 'buy now' link. At this point, enter the following coupon code: 4A49E0D7D4. That's it! I hope you enjoy it as much as the good folks at TASS...

On a related note, I'd like to take this opportunity to single out a member of the TASS executive committee for recognition: Shan Ali Rasul. Shan has been an enthusiastic and indispensible member of the TASS Interfaces Executive Committee, and has also taken on the role of webmaster for the entire TASS group: no small task! Shan has earned my undying respect. With little java and .html background, Shan has created a fantastic website for the TASS group. You can see his handywork here at www.torsas.ca In building this site, Shan has taken time out of his evenings and weekends - in a volunteer capacity - to try and help out the SAS community in Toronto and beyond. It's this kind of selfless action that characterizes the SAS users in my world. You'll find all the presentations from the most recent TASS meeting and an archive of past presentations here.

Finally, on a cheery note, the annual King St. Kicks soccer tournament was held last week. Featuring 8 teams, a rainstorm of biblical proportions and starring Carl Farrell playing goal to rave reviews - if not stiff joints afterwards - the tournament was a great success, raising over $5000 for a local school. Carl was definitely the surprise of the tourney: he can really move!!! Watching him dive for well-struck soccer balls - and getting to them in time - is an image I won't soon forget.

That's all for this quick update. I'll have LOTS more to write a little later in the week, as I prepare to fly to Quebec City for the first meeting of a brand-new initiative in the city: the QC Analyics Forum! I'll be sure to have an update on that and other upcoming events shortly...

Wednesday, September 15, 2010

Serendipity In the SAS World

I think I've been fairly transparent in my unabashed love for my role here at SAS. For those who know me, I'm a pretty loud person in general: I'm not shy in the least, and one of my favourite things is meeting new and interesting people. And in the SAS world, there's no shortage of interesting people!

I wanted to share two stories which really drive home the amazing reach and reputation of SAS, and to highlight how a fortuitous encounter between strangers can sometimes lead to bigger and better things.

My personal computer recently imploded, necessitating a trip to my phenomenal PC guru. I recalled that about 6 months ago, I had visited the same shop to upgrade my machine. That day, I ended up chatting with the owner as he completed his work. Within the course of our conversation, a wonderful moment of serendipity took place. As I chatted about my career and role at SAS, his eyes lit up. It turned out that his fiancé had recently became SAS certified and was looking for an employment opportunity... and I happened to have a TASS user group meeting the following week! There are few places which are more conducive to making great connections in the SAS world than a user group meeting, particularly TASS, the oldest and largest of them all. Long story short, I was put in touch with the young lady and I met up with her at the user group meeting. After a great conversation, I introduced her to a few people. It was great to hear from my computer guru that less than 6 months later, she was able to connect with someone at the TASS meeting and is now working at a major bank, predicated by an innocent conversation between strangers!

Along a similar vein, last Friday I was braving end-of-week rush hour traffic on our subway system here in Toronto. For those who ride it often, I don't have to describe what an exercise in patience, tolerance and restraint this can be! Rudeness and selfishness seem to be personnified by the average rush hour commuter on the TTC. I happened to have a set of SAS course notes that I was reviewing in my lap: SAS Programming for Experienced EG Users, as I recall. A gentleman tapped me on the shoulder: in rush hour traffic, I instantly put up my conversational defences preparing for a pointed, tense exchange. Imagine my pleasant surprise when the gentleman only wanted to ask about the book I was reading. Within the context of a wonderful 30 minute conversation, I came to connect with him in terms of his skills set, his curiosity around SAS, and his personality. Once again, I was fortunate enough to make a new friend and a possible SAS advocate, just because of my clear public association with the company.

I bring forward these stories not to pat myself on the back: the take-away is not that I'm a gifted conversationalist or an unnaturally charming individual. Rather, it's that the SAS community is larger and more prevalent than we can imagine. It's amazing to see where SAS users can pop up! In this case, I think that the 'The Power to Know' refers to the willingness to take a chance, start a conversation and let nature take its course. It's the promise of relationship-building and being given the opportunity to assist and support SAS users that really motivates me to get out of bed everyday.

This Friday, the TASS meeting is taking place once again. I wonder who I might meet this time? What interesting conversations will I have? What will the ultimate outcome of this be down the road? I'll be sure to update you all in the coming weeks.

I encourage all of you in the Toronto area to come by the SAS offices for the TASS meetings on Friday. As always, it's free to attend, and the agendas are very solid. I hope to see you there: perhaps it's you and I who will be connecting this time!