Presentation Archive

The Inner Workings of the Data Step: Matieu Gaouette, Prospective MG Inc.

Data Simulation Methods: A Bayesian Approach: Amr Shalaby, Pong Studios Corporation  

Top 10 SAS Functions in 2017: Flora Fang Liu

That Macro Talk: Mathieu Gaouette, Prospective MG Inc.

Extracting GIT Repository from a SAS Enterprise Guide 7.1 Project: Shahriar Khosravi, Bank of Montreal  

SAS Debugger in Enterprise Guide: Charu Shankar, SAS Canada  

Tips & Tricks:
     Keep, Drop, Rename - Order of Execution?: John Lam
     Accessing my Stuff in Linux/Unix: Debby Gear, DG Consulting
     DLCREATEDIR recursive macro

SAS Studio and SODA: Tom Kari, Kari Consulting & Andrew Farrer, Consentient Inc.

SAS Quiz

SAS Quiz Answers

SAS Certification - What's in it for you?: Stephen Keelan, SAS Education

Generating Test Data: Tom Kari, Kari Consulting

Update from SAS: Sean Robson, SAS Canada

Working with Sparse Matrices in SAS: Andrew Kuligowski, HSN

Quick Tip 3: John Lam, CIBC 

Quick Tip 2: Andrei Krautsou, Financial Risk Group 

Quick Tip 1: Lisa Eckler, Lisa Eckler Consulting Inc. 

SGF International Professional Program: Michael Chu, TD Bank Group 

December 2017

SAS Studio and SODA: Tom Kari, Kari Consulting & Andrew Farrer, Consentient Inc.

SAS Quiz

SAS Quiz Answers

SAS Certification - What's in it for you?: Stephen Keelan, SAS Education

Generating Test Data: Tom Kari, Kari Consulting

Update from SAS: Sean Robson, SAS Canada

Working with Sparse Matrices in SAS: Andrew Kuligowski, HSN

Quick Tip 3: John Lam, CIBC 

Quick Tip 2: Andrei Krautsou, Financial Risk Group 

Quick Tip 1: Lisa Eckler, Lisa Eckler Consulting Inc. 

SGF International Professional Program: Michael Chu, TD Bank Group 

Moving Data and Results Between SAS and Microsoft Excel: Harry Droogendyk, Stratia Consulting

Edit and Editor - Creating Keyboard Macros in SAS Enterprise Guide: Christopher Bost, SAS Consultant 

Fuzzy Matching and SAS - Data Analysts Tool to Cleaner Data: Josh Fogarasi, Superior Propane 

SAS Global Forum 2017: Anita Measey, BMO Financial 

So You Think You Can Combine Data Sets?: Christopher Bost, SAS Consultant

Your Database Can Do Complex String Manipulation Too!: Harry Droogendyk, Stratia Consulting

Simple Data Automation Using Base SAS In A Windows Environment: Jennet Gambino, Bond Brand Loyalty

Creating Maps with SAS Enterprise Guide: Stephanie R. Thompson, Datamum

Explanatory Model for Fatal Vehicle Accidents in the US: Sunny Giroti

Tips, Tricks and Oddities: Chris Battison, Eva Filep, and Anita Measey 

SAS Academic Program - Collaberation, Innovation and Research: Mark Morreale, SAS Canada 

Update from SAS: Matt Malczewski, SAS Canada 

Managing your SAS Assets / Evaluating Sample Code for an Interview: Stephanie R. Thompson, Datamum

SAS Does Objects with DS2: Peter Eberhardt, Fernwood Consulting Group Inc. 

Point and Click Your Way to Easy Forecasting: Chris Battiston, Women's College 

SAS and Open Source with Enterprise Miner: Pat Valente, SAS Canada 

Becoming a Unicorn, a Leprechaun, or a Good Marketing Analyst: Emma Warrillow, Data Insights Group

Passwords and Authdomain: Debby Gear, DB Consulting

Cognitively Enriched Reports: Zoran Jovicic & Alexandra Jovicic, Yozoki Consulting 

Be More Productive! SAS Tips and Tricks: Marje Fecht, Prowerk Consulting LLC 

Enterprise Guide Tips and Features: Marje Fecht, Prowerk Consulting 

SAS Visual Analytics: Pat Valente, SAS Canada 

10 Things That Made Us Smarter: Harsha Kotian, RBC & Matt Malczewski, SAS Canada 

SAS Global Forum 2016: Anita Measey, BMO 

Missing Values, They are NOT Nothing: Amanda Lin, CIBC 

HASH Joins!: Lionel Teed,TD Bank 

Stratified Sampling: Adnan Alkhouri, Bank of Montreal 

SASUnit - Confidence in Coverage: Chuck Castillo, SAS Canada 

SAS & Open Source: Matt Malczewski, SAS Canada

Dealing with Duplicates: Christopher Bost, MDRC - New York 

(Power)Pointing Your Way to Excel(lence): A Word on SAS & Microsoft Office: Matt Malczewski, SAS Canada 

For Coders Only: The Enterprise Guide Experience: Christopher Bost, MDRC - New York 

To FREQ, Perchance to MEANS: Christopher Bost, MDRC - New York 

Tips for Preparing Data for Regression Analyses: Michael Lerner, Ontario Public Service 

Parallel Data Loading in SAS: Fulton Lee, Bank of Montreal 

Selecting All Observations When Any Observation is of Interest: Christopher Bost, MDRC - New York 

Update from SAS: Matt Malczewski, SAS Canada

Enterprise Miner: How Not to Use it in a Stock Portfolio Application: Leyla Imanirad, Bristol Gate Capital Partners 

A Gentle Introduction to an Idiot's Guide to SAS Simulation Studio for Dummies: Chris Battiston, Women's College Hospital 

Common Sense Validation Using SAS: Lisa Eckler, Eckler Consulting 

Working with Character Data: Andrew Kuligowski, HSN 

Quick Tips: Call Module: John Lam, CIBC Corporate Centre Technology 

SAS Tip Of The Day: How I Lost a Day at Work and Still Got Paid: Derek Montrichard, CIBC 

Beyond the Manual: Terms that SAS Users Throw Around That Have Nothing To Do With SAS Code: Andrew Kuligowski, HSN 

Update from SAS: Matt Malczewski, SAS Canada 

My Favourite Enterprise Guide Tricks: Marje Fecht, Prowerk Consulting 

Introduction to SAS & Hadoop: James Waite, SAS Canada 

Scraping and Mining XML Data with SAS: Herve Momo, Manulife 

Importing Excel into SAS: A Robust Approach for Difficult-To-Read Worksheets: Bill Sukloff, Environment Canada 

Update from SAS: Matt Malczewski, SAS Canada 

Snippets and Tasks in SAS University Edition: Christopher Battiston, Women's College Hospital

Getting Data Into SAS: INFILE and INPUT - Interactive Session: Andrew Kuligowski, HSN

Getting Data Into SAS: INFILE and INPUT: Andrew Kuligowski, HSN

Update from SAS: Matt Malczewski, SAS Canada

What's New in Enterprise Guide 7.1: Matt Malczewski, SAS Canada

Yes, SAS Can Do! Manage External Files: Justin Jia, TransUnion & Amanda Lin, CIBC 

A Conversion from Oracle to Netezza: Andrew Kuligowski, HSN 

Posed Problem Solutions: Various Individuals 

DIR in SAS: Anthony Chen, RBC Financial Group 

Array we do it: Lionel Teed, TD Financial Group

TASS Interfaces Posed Question Solutions: Various Individuals

Posed Problem Solution: Chris Battiston, Trillium

Update from SAS: Matt Malczewski, SAS Canada 

High Performance Analytics and the Challenges of Big Data: Charu Shankar, SAS Canada 

ODS Graphics Designer, the Ins and Outs: Chris Battiston, Trillium 

Entry-Level SAS Working With Excel: Matt Malczewski, SAS Canada 

Combining Data the EG Way: Anita Measey, BMO 

Reading Custom Details in C.I.S: Gabriela Nanau, Cornerstone Group of Companies

Posed Question Solutions: Various Individuals 

SAS Global Forum 2014

TASS Interfaces Posed Question

Learning to Love the Drag and Drop: Matt Malczewski, SAS Canada

TASS Update: Matt Malczewski, SAS Canada

ODS Graphics Designer: Christopher Battiston, Hospital for Sick Children

Enterprise Guide 4.3 Programming Gains from Point and Click: Matt Malczewski, SAS Canada

Horizontal Data Sorting and Insightful Reporting: Justin Jia, CIBC & Amanda Lin, Bell Canada

TASS Interfaces Posed Question

Querying James Bond in SAS EG: Charu Shankar, SAS Canada

SAS Update: Matt Malczewski, SAS Canada

SAS Global Forum Update

TASS Posed Question Solution

Handling Missing Data with SAS: Timothy Gravelle, PriceMetrix

TASS Interfaces Posed Question

Top 10 SAS Coding Efficiencies: Charu Shankar, SAS Canada

CAR Tool Using Stored Processes: Anita Measey, BMO

Proc Tabulate Tool Extension: Justin Jia, CIBC & Amanda Lin, Bell Canada

My Journey with DataFlux: Garry D'Lima, Cornerstone Group of Companies

EG 5.1 Programmer's Paper: Marje Fecht, Prowerk Consulting

Hash: Peter Eberhardt, Frenwood Consulting Group Inc.

Modelling Process Review: Saaramaki, DataMaApp Inc.

ODS Graphics Designer: Barry Hong, United States Steel Corp.

Analytics with SAS Process Automation: Brian Sun 

SAS as Glue: Lionel Teed, TD Financial Group

SAS Update and Support Resources

PROC SQL: Battiston

Data Security in SAS OLAP Cubes and Reports: Chaitanya & Santhalingam, Infosys

Using PROC GPLOT to Produce PDF Files with Mouseover Text: Bill Sukloff, Environment Canada

What's New in SAS 9.4: Matt Malczewski, SAS Canada

Creating Graphics with Hyperlinks by PROC GBARLINE: Vivien Fan, Scotiabank

Cluster This!: Meera Das, RBC

EG, Statistics and Clustering: Laurent Josso, RBC

Macros in SAS EG: Rupinder Dhillon

How to go From Macro to a Stored Process Using EG: Chris Sammut, SAS Canada 

TASS Intro

Using Value Analysis to Guide Sales and Marketing: Darrin Wolter, Cotton Creek

Integrating SAS and Google API: Mahmoud Azimaee, University of Manitoba

Doubling Down on Doubling Out: Matt Malczewski, SAS Canada

Best of the SAS Communities: Matt Malczewski, SAS Canada

SAS 9.3 Support Options & More: Matt Malczewski, SAS Canada

Finding the Right Sized Model with Enterprise Miner: Lorne Rothman, SAS Canada

Enough Really Good SAS Tips to Fill a Book: Arthur Tabachneck, myqna.org

My SAS Global Forum: Fulton Lee

SAS Enterprise Guide 4.2 For Programmer's: Rupinder Dhillon, Dhillon Consulting Inc.

Reading XML Files with SAS: Debby Gear 

Looking Beneth the Surface of Sorting: Andrew Kuligowski, FCCI Insurance Group

Based on SAS-L Post by Paul Dorfman: Arthur Tabackneck

Stolen from a SAS-L Post by Mike Zdeb: Arthur Tabackneck

SAS Global Forum: Lauren Haworth, Genentech Inc. 

Various Ways of Performing Logistic Regression in SAS: Michael Lerner, Ontario Ministry of Education 

EG 4.2 Custom Add-In Create User Formats: Judy Orr Lawrence, SAS Canada 

Strategic Data Management: Kirby Sinclair, Clear Cell Canada Inc.

NESUG

How to Visually Communicate Patterns Using SAS EG

What's New in SAS 9.3: Steve Herslovits 

What's new in BASE SAS 9.2: Rupinder Dhillon, Dhillon Consulting Inc.

SAS Global Forum Recap: Natalie Forde

Look Both Ways: Arthur Tabachneck

SAS 9.2 What's in it for me?: Sylvain Tremblay, SAS Canada 

Dashboards With PROC GKPI: Barry Hong, Unites States Steel Corp. 

Using Inputn to Re-Format Data: Arthur Tabachneck 

Quickly Find all Your Project Code: Arthur Tabachneck 

Using Multiple DOW Loops: Arthur Tabachneck 

Which SASAUTOS Macros Are Available to My SAS Session: Harry Droogendyk, Stratia Consulting Inc. 

Different Approaches to Maintaining Excel Reports: Amanda Bin Feng, ING Direct Canada 

SAS Web Report Studio

Worse, but Still Usable Data I've Confronted: Arthur Tabachneck 

Batch Processing and Sysparm

Using SAS Macro Language and PROC Report to Produce Formatted Excel Files: Nadeene Blanchard-Martin, MOHLTC

Discriminant Analysis in JMP and SAS: Eric Cai, Predictum Inc.

Overcoming Multicollinearity and Overfitting: Eric Cai, Predictum Inc.

Using the Descriptor Portion of a SAS Data File: Dragos Daniel Capan

Multiple Datasets Export into a Single Excel File: Anthony Chen, Norland Data System

QC Your RDBMS Data Using Dictionary Tables: Harry Droogendyk, Stratia Consulting Inc.

Creating Stored Processes: Harry Droogendyk, Stratia Consulting Inc.

PROC FCMP: Peter Eberhardt, Fernwood Consulting Group Inc.

How Generation Data Sets Can Help: Lisa Eckler, Lisa Eckler Consulting

TIFF and TASS: Lisa Eckler, Lisa Eckler Consulting

When Good Looks aren't Enough (NESUG): Lisa Eckler, Lisa Eckler Consulting

Unix Performance Benchmarking: Tom Kari, Andrew Farrer

Geospatial Data Analysis Tools in SAS: Timothy Gravelle, Independent Statistical Consultant

SAS North American Public Opinion and the 49th Parallel: Timothy Gravelle, Independent Statistical Consultant

More Than Doubled - Moving from 32-bit to 64-bit SAS on Windows: Chris Hemedinger, SAS Canada

Windows Powershell and SAS - Use them to Drive Each other Crazy: Chris Hemedinger, SAS Canada

SAS Functions By Example: Herman Lo, RBC Capital Markets

The Data Explorer in SAS EG 5.1: Chris Jiang, RBC

Data Visualization - Connecting the Dots with SAS Graph NV: Laurent Josso, RBC

SAS EG Options: Susan Jumper, Harsha Kotian

Macro Variables, Proc SQL and the Data Dictionary: Andrew Farrer, CIBC

Hypothesis Testing in SAS EG: Matt Malczewski, SAS Canada

Understanding Data Step Processing Using PDV: Mohamed Mehatab, Hewlett-Packard Canada

Data Extracts for Everybody: Gabriela Nanau, Cornerstone Group of Companies

SAS Macros are Just Text Substitutions: Dianne Piaskoski, Chinook Consulting Ltd.

An Introduction to Proc Transpose: David Rosenfeld, City of Toronto

Running SAS EG Locally: Rahman Sarker, RBC

Macro Overview: Mihaela Simion

SAS Macro Programming for Beginners: Susan Slaughter, Avocet Solutions & Lora Delwiche, University of California

Introdution to Summary Tables in SAS EG: Susan Slaughter, Avocet Solutions & Lora Delwiche, University of California

You Want to be a SAS Press Author?: Susan Slaughter, Avocet Solutions

What Common Data Step and Macro Messages are Trying to Tell You: Charley Mullin and Kevin Russell, SAS Canada

New and Updated System Options in SAS 9.4: Jan Squillace, SAS Canada

Using SAS to Build Web Pages Linking Photos with Google Maps: Arthur Tabachneck and Bill Klein

Copy and Paste from Word or Excel to SAS: Arthur Tabachneck

A Better Way to Flip (Transpose) a SAS Dataset: Arthur Tabachneck

Posed Problem: Arthur Tabachneck

A Poor/Rich SAS User's Proc Export: Arthur Tabachneck

SAS Text Miner: Tim Trussell, SAS Canada

Data Management Using SAS Arrays: Lavanya Vangala

Dancing in Fetters - Script is Key: Carl Wang, Indigo Books and Music

Searching For Variable Values with CAT Functions: Mike Zdeb, University of Albany School of Public Health

Driving Distances and TImes Using SAS and Google Maps: Mike Zdeb, University of Albany School of Public Health

An Easy Route to a Missing Data Report with ODS+PROC FREQ+A Data Step: Mike Zdeb, University of Albany School of Public Health