Français

Older Presentations

Pictures!

SAS OPUS

SAS Links

Contact us

SAS is proud to support SAS users groups

Presentations from earlier meetings

Thursday November 26, 2015

8:30 AM – 9:00

Registration and Breakfast


Come network with your SAS Ottawa peers, and enjoy a free Continental Breakfast hosted by SAS Ottawa.

9:00 – 9:05

Welcome & Introduction

Greg Ludwinski, Statistics Canada SAS Project Leader, SAS OASUS President

9:05 – 9:10

Presentation: SAS Canada News

Warren Woermke, SAS Institute (Canada) Inc. - Toronto


     Presentation (PPT)

9:10 – 9:15

SAS OPUS (SAS Ottawa Platform Users Society)

Joel Orr, Statistics Canada, SAS OPUS President

Get a preview of the SAS OPUS meeting that will be held right after lunch.

9:15 – 9:40

Presentation: Benchmarking

Tom Kari, Tom Kari Consulting


Introducing benchmarking concepts, techniques and tools.

     Presentation (PPT)

9:40 – 10:05

Presentation: Q & A Session

Yves DeGuire, Statistics Canada SAS Technology Centre Chief


Answers to your SAS questions from the previous meeting will be presented.

     Presentation (EGP)

10:05 – 10:20

Break, Networking & Job Exchange Table

10:20 – 10:35

Presentation: Put Data in the Driver's Seat

Andrew Clapson, MD Financial Management


A Primer on Data-Driven Programming. This presentation reviews three ways of building a SAS program to create Microsoft Excel reports; one method using hardcoded variables, another using SAS keyword macros, and the last using metadata.

     Presentation (PPT)

10:35 – 10:50

Presentation: You Deserve Arrays

Kate Burnett-Isaacs, Statistics Canada


Practical applications of arrays.

     Presentation (PDF)

     Presentation (PPT)

10:50 – 11:15

Presentation: Hash Objects

Vincent Martin, Statistics Canada


Improving the performance of your SAS programs using the Hash Object.

     Presentation (PPT)

11:15 – 11:30

Presentation: SAS Grid and Stored Processes

Carmine Verrelli, SAS Canada - Ottawa


An overview of how to effectively use stored processes in a grid environment.

     Presentation (PPT)

11:30 – 11:45

Closing Remarks and Door Prize(s)

11:45 – 1:00

Lunch (on your own)

1:00

SAS OPUS – SAS Ottawa Platform Users Society meeting.
www.sasopus.ca

Thursday May 28, 2015

8:30 AM – 9:00

Registration and Breakfast


Come network with your SAS Ottawa peers, and enjoy a free Continental Breakfast hosted by SAS Ottawa.

9:00 – 9:05

Welcome & Introduction

John Ladds, Statistics Canada Technical Consultant, SAS OASUS President

9:05 – 9:10

Presentation: SAS Canada News

Matt Malczewski, Communities manager, SAS Institute (Canada) Inc. - Toronto

9:10 – 9:15

SAS OPUS (SAS Ottawa Platform Users Society)

Joel Orr, Statistics Canada, SAS OPUS President

Get a preview of the SAS OPUS meeting that will be held right after lunch.

9:15 – 10:00

Presentation: SAS Accessible Analytics

Ed Summers, SAS Institute


An overview of the accessibility program at SAS including motivation, priorities, process, demonstration of recent ground-breaking projects including collaboration with the Space Telescope Science Institute and NASA, as well as future plans.

     Presentation (PPT)

     Accessibility at SAS

     SAS Accessibility Youtube channel

10:00 – 10:30

Presentation: Q & A Session

Yves DeGuire, Statistics Canada SAS Technology Centre Chief


Answers to your SAS questions from the previous meeting will be presented.

     Presentation (EGP)

10:30 – 10:50

Break, Networking & Job Exchange Table

10:50 – 11:10

Presentation: Accessibility Tips and Tricks for SAS Programmers

Ed Summers, SAS Institute


A hands-on presentation providing practical examples and guidance for SAS programmers to use to produce accessible SAS output.

     Presentation (PPT)

11:10 – 11:30

Presentation: Localized Messages

Lihsin Hwang, Statistics Canada


STRING EXTERNALIZATION is the key to making your SAS applications speak multiple languages, even if you can't. Using the new features in SAS 9.3 for internationalization your SAS applications can be written to adapt to whatever environment they are found in.

     Presentation (PPT)

11:30 – 11:45

Closing Remarks and Door Prize(s)

11:45 – 1:00

Lunch (on your own)

1:00

SAS OPUS – SAS Ottawa Platform Users Society meeting.
www.sasopus.ca

Thursday November 20, 2014

8:30 AM – 9:00

Registration


Come network with your SAS Ottawa peers, and enjoy light refreshments hosted by SAS Ottawa.

9:00 – 9:05

Welcome & Introduction

John Ladds, Statistics Canada Technical Consultant, SAS OASUS President

9:05 – 9:10

Presentation: SAS Canada News

Matt Malczewski, Communities manager, SAS Institute (Canada) Inc. - Toronto

9:10 – 9:15

SAS OPUS (SAS Ottawa Platform Users Society)

Joel Orr, Statistics Canada, SAS OPUS President

Get a preview of the SAS OPUS meeting that will be held right after lunch.

9:15 – 10:00

Presentation: Getting familiar with Proc DS2 and Proc FedSQL

Greg Ludwinski, Statistics Canada


Proc DS2 and Proc FedSQL are two great reasons to migrate to SAS 9.4. These procedures can help with the performance, precision and efficiency of your SAS code as well as enhance the structure of SAS solutions. This presentation will introduce these procedures and illustrate their benefits.

     Presentation (PPT)

     Presentation (EGP)

10:00 – 10:30

Presentation: Q & A Session

Yves DeGuire, Statistics Canada SAS Technology Centre Chief


Answers to your SAS questions from the previous meeting will be presented.

     Presentation (PDF)

     Presentation (EGP)

10:30 – 10:50

Break, Networking & Job Exchange Table

10:50 – 11:10

Presentation: SAS Studio and SAS University Edition

Issa Guindo, SAS Institute (Canada) Inc.


Learn about SAS Studio and SAS University Edition and how it can complement your existing environment or modernize it.

     Presentation (PDF)

11:10 – 11:30

Presentation: Proc du Jour: PROC TRANSPOSE

Tom Kari, Tom Kari Consulting


Edit an EXCEL spreadsheet? Create a data warehouse? Guess what you can do with PROC TRANSPOSE!

     Presentation (PPT)

11:30 – 12:00

Closing Remarks and Door Prize(s)

12:00 – 1:00

Lunch (on your own)

1:00

SAS OPUS – SAS Ottawa Platform Users Society meeting.
www.sasopus.ca

Thursday June 12, 2014

8:30 AM – 9:00

Registration and Breakfast


Come network with your SAS Ottawa peers, and enjoy a free Continental Breakfast hosted by SAS Ottawa.

9:00 – 9:05

Welcome & Introduction

John Ladds, Statistics Canada Technical Consultant, SAS OASUS President

9:05 – 9:10

Presentation: SAS Canada News

Matt Malczewski, Communities Manager, SAS Canada - Toronto

9:10 – 9:15

SAS OPUS (SAS Ottawa Platform Users Society)

Joel Orr, Statistics Canada, SAS OPUS President

Get a preview of the SAS OPUS meeting that will be held right after lunch.

9:15 – 10:00

Presentation: Grid – The Evolution from Parallel Processing to Modern Day Computing

Vecdet Mehmet-Ali, Statistics Canada, Greg McLean, Statistics Canada


Grid computing is becoming more and more integral to the SAS System. Processing larger amounts of data in shorter periods of time has become a necessity. However, grid computing is not necessarily something new. The concept and the ability to process data in a parallel fashion have been available to SAS users for the past 20 years. In our presentation we will give a brief history and evolution of SAS/Connect software discussing some of the important concepts related to grid or parallel processing. We will also demonstrate a Tabulation System highlighting the issues that pertain to a modern day SAS Grid system.

     Presentation (PPT)

10:00 – 10:20

Presentation: Q & A Session

Yves DeGuire, Statistics Canada SAS Technology Centre Chief


Answers to your SAS questions from the previous meeting will be presented.

     Presentation (PDF)

     EG Project (EGP)

10:20 – 10:40

Break, Networking & Job Exchange Table

10:40 – 11:10

Presentation: Growing your SAS Team

Howard Hurley, Statistics Canada


This presentation will discuss how Health Statistics Division came to build their own SAS resources sharing community.

     Presentation (PPT)

11:10 – 11:30

Presentation: Get Certified as a Base and Advanced SAS Programmer

Pinchao Ma, Statistics Canada


In this presentation, the presenter will generally introduce the SAS Certified Professional Program, as well as review the benefits of becoming a SAS Certified Programmer. Also the presenter will talk about the coverage and the registration of the certification exams. In addition, the presenter will share his experience and strategies in preparing for these two exams.

     Presentation (PPT)

11:30 – 11:45

Closing Remarks and Door Prize(s)

11:45 – 1:00

Lunch (on your own)

1:00

SAS OPUS – SAS Ottawa Platform Users Society meeting.
www.sasopus.ca

Wednesday November 20, 2013

8:30 a.m. – 9:00 a.m.

Registration and Breakfast


Come network with your SAS Ottawa peers, and enjoy a free Continental Breakfast hosted by SAS Ottawa.

9:00 a.m. – 9:05 a.m.

Welcome & Introduction

John Ladds, Technical Consultant, Statistics Canada

9:05 a.m. – 9:10 a.m.

SAS News

Matt Malczewski, Communities Manager, SAS Canada

Catch up on news and recent events in the SAS world, both in Ottawa and world-wide.

     Presentation (PDF)

9:10 a.m. – 9:15 a.m.

SAS OPUS (SAS Ottawa Platform Users Society)

Joel Orr, Statistics Canada

Get a preview of the SAS OPUS meeting that will be held right after lunch.

09:15 AM –10:00 AM

Presentation: Hello SAS 9.4: How Will My Life Change?

Chris Hemedinger, SAS


Cloud computing, High-Performance Analytics, accessing SAS from a mobile devices, DS2 for in database processing, Reading ZIP files; SAS 9.4 will change how you do it whatever you do.

     Presentation (PowerPoint)

10:00 AM –10:20 AM

Presentation: Q & A Session

Yves DeGuire, Section Chief, Statistics Canada


Answers to your questions from the previous meeting will be presented.

     Enterprise Guide Project

     ZIP Archive

     Using SAS ODS Markup to Generate Custom PivotTable and PivotChart Reports

     Creating ZIP Files with ODS

     The Armchair Quarterback: Writing SAS Code for the Perfect Pivot (Table, That Is)

10:20 a.m. – 10:40 a.m.

Break, Networking & Job Exchange Table

10:40 AM –11:00 AM

Presentation: SAS Enterprise Guide 6.1: A Spotlight on the New Stuff

Chris Hemedinger, SAS


Get an early look at some of the new programmer productivity features such as the new Log Summary window, which lists all the errors, warnings, and notes that were generated when the program ran, as well as related line numbers and a sample of the affected code.

11:00 AM –11:25 AM

Presentation: Utilizing SAS Enterprise Guide as an IDE for SAS Systems Development

Cheryl Wang, Statistics Canada


In this presentation, the following topics will be discussed:
Using SAS EG to manage source repository
Using SAS EG and version control tool to modify code
Using SAS EG to conduct testing on different platforms
Using SAS EG to make and deploy releases to different platforms and operational environments

11:25 AM –11:40 AM

Presentation: Books by Users

Jeff Marchand, Health Canada


PROC TEMPLATE Made Easy: A Guide for SAS Users by Kevin Smith

     Presentation (PowerPoint)

     Materials (Enterprise Guide Project)

11:40 a.m. – 11:45 a.m.

Workshop Announcement


Get acquainted with SAS Enterprise Guide 5.1
SAS Institute Ottawa
Friday November 29th 2013
9:00 a.m. – 10:00 a.m.


SAS Enterprise Guide, with its friendly interface, has been very popular with SAS users, especially non-programmers. If you are completely new to SAS, there is even more reasons to be familiar with this point and click querying and reporting tool. You will see the value of what SAS Enterprise Guide has to offer; a multitude of tasks and wizards that will enable you to be productive in no time. Nobody will believe you are a novice user!

11:45 a.m. – 12:00 p.m.

Closing Remarks and Door Prize(s)

12:00 p.m.

Lunch (on your own)

1:00 p.m.

SAS OPUS – SAS Ottawa Platform Users Society meeting.
www.sasopus.ca

Wednesday June 12, 2013

8:30 a.m. – 9:00 a.m.

Registration and Breakfast


Come network with your SAS Ottawa peers, and enjoy a free Continental Breakfast hosted by SAS Ottawa.

9:00 a.m. – 9:10 a.m.

Welcome & Introduction

John Ladds, Technical Consultant, Statistics Canada

9:10 a.m. – 9:15 a.m.

SAS News

Matt Malczewski, Communities Manager, SAS Canada

Catch up on news and recent events in the SAS world, both in Ottawa and world-wide.

9:15 a.m. – 9:20 a.m.

SAS OPUS (SAS Ottawa Platform Users Society)

Joel Orr, Statistics Canada

Get a preview of the SAS OPUS meeting that will be held right after lunch.

09:20 AM –09:50 AM

Presentation: Techniques to invoke Web Services from SAS

Greg Ludwinski, Statistics Canada


After introducing basic web service concepts, this presentation will focus on how available web services can be integrated into SAS programs. One approach is to use Proc Soap to invoke a web service using SOAP over HTTP and then load the results into SAS dataset(s) using an XML Map. But did you know that custom Java solutions can be integrated into your SAS programs that leverage rich web service frameworks to call a web service?

     Presentation (PowerPoint)

09:50 AM –10:20 AM

Presentation: Q & A Session

Yves DeGuire, Section Chief, Statistics Canada


Answers to your questions from the previous meeting will be presented. Including the following topics: Organizing and managing an EG project; Migrating to SAS 9.3; Exporting to Excel; and The PROC DOCUMENT procedure.

     Presentation (PowerPoint)

     Examples (EG Project)

10:20 a.m. – 10:40 a.m.

Break, Networking & Job Exchange Table

10:40 AM –11:10 AM

Presentation: Scraping the Web with SAS

Tom Kari, Tom Kari Consulting


SAS now includes a number of tools for using data from the Internet and the World Wide Web. This presentation will show how the URL access option of the FILENAME statement, in conjunction with tools like the Perl Regular Expression functions and the Web Tools functions, can be used to retrieve web pages, to decipher the contents, and to structure the resulting data for analysis use.

     Presentation (PowerPoint)

     Examples (EG Project)

     Regular Expression Presentation (PowerPoint)

11:10 AM –11:25 AM

Presentation: Start Writing Your SAS Global Forum Paper Now

Peter Timusk, Statistics Canada


This talk will present how an author approached the task of writing a SAS Global Forum paper starting almost a year before the paper was presented. The scope of the paper and degree of difficulty of the topic will also be discussed and compared to an assessment of some papers presented at SAS Global Forum 2012. This assessment of papers presented in the past allowed the author to write a straight forward paper that in the end was accepted for SAS Global Forum 2013.

     Presentation (PowerPoint)

11:25 a.m. – 11:35 a.m.

Workshop Announcement


Visual Analytics 6.1 (Yes You Can!)
SAS Institute Ottawa
Friday June 14th 2013
9:00 a.m. – 10:00 a.m.


a. Exploration and Visualization

b. Modeling data, Dashboarding, Mobile & Consumer view

c. How VA works with your existing SAS environment

     Announcement (PowerPoint)

11:35 a.m. – 11:45 a.m.

Closing Remarks and Door Prize(s)

11:45 a.m.

Lunch (on your own)

1:00 p.m.

SAS OPUS – SAS Ottawa Platform Users Society meeting.
www.sasopus.ca

Wednesday November 14, 2012

8:30 a.m. – 9:00 a.m.

Registration and Breakfast


Come network with your SAS Ottawa peers, and enjoy a free Continental Breakfast hosted by SAS Ottawa.

9:00 a.m. – 9:10 a.m.

Welcome & Introduction

John Ladds, Technical Consultant, Statistics Canada

9:10 a.m. – 9:15 a.m.

SAS News

Matt Malczewski, Communities Manager, SAS Canada

Catch up on news and recent events in the SAS world, both in Ottawa and world-wide.

     Summary (PowerPoint)

9:15 a.m. – 9:20 a.m.

SAS OPUS (SAS Ottawa Platform Users Society)

Joel Orr, Statistics Canada

Get a preview of the SAS OPUS meeting that will be held right after lunch.

9:20 a.m. – 9:50 a.m.

Presentation: How to use PROC FCMP

Xiyun (Cheryl) Wang, IT Team Leader, Statistics Canada

     Presentation (PowerPoint)

9:50 a.m. – 10:20 a.m.

Presentation: Q & A Session

Yves DeGuire, Section Chief, Statistics Canada

     Session Notes (PDF)

     Examples (EG Project)

10:20 a.m. – 10:40 a.m.

Break, Networking & Job Exchange Table

10:40 a.m. – 11:05 a.m.

Presentation: Tips & Tricks (Tips for coders) Working with Dates and Times – Why does this have to be so difficult?

Paul Cripwell, Manager, NAV CANADA

     Presentation (PowerPoint)

11:05 a.m. – 11:25 a.m.

Presentation: Point & Click (Tips for non-coders) "Better SAS Graphs or 'I can't believe it's not PowerPoint'"

Jeff Marchand, Senior Analyst, Health Canada

     Presentation (PowerPoint)

11:25 a.m. – 11:30 a.m.

Workshop Announcement


Advanced Macros
SAS Institute Ottawa
Friday November 30th 2012
9:00 a.m. – 10:00 a.m.

11:30 a.m. – 11:40 a.m.

Door Prizes

11:40 a.m. – 11:45 a.m.

Closing Remarks

11:45 a.m.

Lunch (on your own)

1:00 p.m.

SAS OPUS – SAS Ottawa Platform Users Society meeting.
www.sasopus.ca

June 6th 2012

November 16th 2011

June 1st 2011

November 17th 2010

June 9th 2010

November 18th 2009


June 22nd 2009, Statistical Modeling Workshop

June 3rd 2009

November 19th 2008

June 11th 2008

November 14th 2007

May 9th 2007

November 22nd 2006

May 3rd 2006

November 1st 2005

May 11th 2005

November 16th 2004

April 7th 2004

November 12th 2003

click here to download the SAS program on ODS from the presentation by Christie Hobley of the Toronto SAS office