SAS Halifax Regional User Group

Presentations

Meeting date: 20091126

• Words of Welcome, Agenda:
  Presenter: John Fahey, Reproductive Care Program of Nova Scotia
  
  Agenda_20091126.doc: MS Word
  
• An Introduction to PCCF+: Using the Postal Code Conversion File to Geocode SAS Datasets
  Presenter: Ron Dewar, Cancer Care Nova Scotia
  
  pccf_presentation.ppt: Powerpoint slides
  
• SAS Global Forum 2009: A first time attendee gives his impressions of SGF in Washington, DC, March 2009
  Presenter: Barry Campbell, Reproductive Care Program of Nova Scotia
  
  SGF_2009.ppt: Powerpoint slides
  
• A Brief Introduction to PROC TRANSPOSE: A detailed look at data transposition including SAS syntax and real life examples from the power utility industry
  Presenter: Voytek Grus, Nova Scotia Power
  
  A_Brief_Intro_to_PROC_TRANSPOSE.ppt: Powerpoint slides
  
• Hash Objects: Why Bother?: An introduction to hash objects in comparison with other SAS table lookup techniques
  Presenter: Barb Crowther, SAS Canada Technical Training Specialist
  
  Hash_Objects_Why_Bother.pdf: PDF slides
  
• Combining Data Sets Containing Character Variables of Different Lengths: Demonstration of a SAS macro that solves the problem by automatically generating the appropriate SAS code
  Presenter: Martha Cox, Cancer Outcomes Research Program, Cancer Care Nova Scotia
  
  Combining_Data.ppt: Powerpoint slides
  
  union.sas: SAS code
  
  Combining_Data_Sets_Handout.doc: How the macro works, MS Word
  
• A Macro for Loading Excel sheets into SAS: How to import, sort and plot data from a multi-sheet Excel file
  Presenter: Pantelis Andreou, Dalhousie University
  
  importing_excel_data.sas: SAS code
  
  importing_excel_data.xls: MS Excel file
  
• Don't Import It!: Setting up a Libname to an Excel spreadsheet or Access database
  Presenter: Kevin Druhan, Nova Scotia Dept of Health
  
  Dont_Import_It.ppt: Powerpoint slides
  

Meeting date: 20090206

• Words of Welcome, Agenda:
  Presenter: John Fahey, Reproductive Care Program of Nova Scotia
  
  Agenda_20090206.doc: MS Word
  
• Using Enterprise Guide to Derive Insights From the Passenger List of the RMS Titanic: Demonstration of reporting techniques in the SAS Enterprise Guide environment.
  Presenter: Matt Malczewski, SAS Canada
  
  Titanic_1.ppt: Powerpoint slides
  
  Titanic_2.zip: Zip archive containing passenger data in Excel file and Enterprise Graph file
  
• Data Quality Assurance with SAS: Tips and Tricks: Approaches to data management, data quality assurance, and reporting healthcare data.
  Presenter: Kevin Druhan, Nova Scotia Department of Health
  
  Basic_Data_QA_using_SAS.ppt: Powerpoint slides
  
• Techie Tip: PROC TRANSPOSE or Data Step: Comparison of two techniques
  Presenter: Dr. Pantelis Andreou, Dalhousie University
  
  Techie_Tip_PROC_TRANSPOSE.zip: Two files in zip archive
  
• Techie Tip: If you have a DATE, SAS has the TIME: How to parse date/time data from Excel into a SAS data set.
  Presenter: Bev Lawson, Lecturer and Senior Research Associate, Family Medicine, Dalhousie University
  
  Techie_Tip_Datetime.ppt: Powerpoint slides
  
• Time Series: An Introduction:
  Presenter: Voytek Grus, Nova Scotia Power Inc., John Fahey, Reproductive Care Program of Nova Scotia
  
  Time_Series_Analysis_1.ppt: Voytek's Powerpoint slides
  
  Time_Series_Analysis_2.zip: John's slides: zip file containing raw data in PRN file, SAS data file, SAS code and log, GIF images, and PDF document
  

Meeting date: 20081024

• Agenda: What happened and who spoke.
  Presenter: John Fahey, Reproductive Care Program of Nova Scotia
  
  Agenda_20081024.doc: MS Word file
  
• Reporting Face-off 1: PROC FREQ
  Presenter: Dr. Pantelis Andreou, CH&E, Dalhousie
  
  Proc_Freq_Example.sas: SAS code
  
  Proc_Freq_Output.pdf: PROC FREQ output
  
• Reporting Face-off 2: PROC TABULATE
  Presenter: Jill Casey, Dept. of Health
  
  PROC_Tabulate.PPT: Powerpoint presentation
  
• Reporting Face-off 3: PROC REPORT
  Presenter: John Fahey, RCPNS
  
  PROC_REPORT.sas: SAS code
  
  PROC_REPORT_Examples.pdf: PROC REPORT output
  
• Tips and Tricks 1: Drill-down with ActiveX
  Presenter: John Fahey, RCPNS
  
  ActiveX.zip: ZIP file contains HTML files demonstrating embedded ActiveX component
  
• Tips and Tricks 2: Denormalizing data with PROC SQL
  Presenter: Barry Campbell, RCPNS
  
  Denorm_SQL.ppt: Powerpoint presentation
  
• Fitting Structural Equation Models using the (T)CALIS Procedure: Today's Featured speaker presents on modeling using Covariance Analysis of Linear Structural Equations
  Presenter: Dr. Yiu-Fai Yung, SAS Institute, Cary, N.C.
  
  SEM_Halifax_2008.pdf: PDF presentation
  
• A Preview of SAS/STAT in 9.2: What's coming in the next version?
  Presenter: Tim Trussell, SAS Canada
  
  Whats_New_SAS_Stat.pdf: New features in SAS/STAT 9.2. PDF presentation.
  
  SAS_Fall_Update.pdf: Updates on SAS Global Forum, Customer Value Award, a contest, Insights newsletter and other subscriptions, new SAS communities and more.
  

Meeting date: 20080222

• Agenda: What happened and who spoke.
  Presenter: Alex Filimon, Novus Consulting (emcee)
  
  Agenda 20080222.doc: MSWord version of what happened when
  
  Bios.doc: Short introductions for the speakers
  
• PROC REPORT for Dummies: An introduction to SAS' very powerful reporting procedure.
  Presenter: John Fahey, RCPNS
  
  PROC_REPORT.zip: See readme.txt in zipfile for descriptions
  
• Using SAS to answer the question: Where have all the meat buyers gone? : Using SAS Enterprise Miner to explore meat purchase behaviour based on two years transaction data.
  Presenter: Chen Chen, Masters of E-Commerce Student, Dalhousie University
  
  Where_Meat_Buyers_Gone.ppt: PowerPoint slides from presentation
  
• Techie Tips: Using simulation to find the 87th percentile in your data. An audience member also pointed out that PROC UNIVARIATE might be able to answer your question.
  Presenter: Prof. Pantelis Andreou, Comm. Health & Epidemiology
  
  quantiles.sas: SAS Code for simulation with built-in output
  
• Data Visualization: Some Introductory Thoughts: Some Thoughts on Effective Data Display
  Presenter: Bill Droogendyk, Quality Systems, ArcelorMittal
  
  SHRUGDVHandout.pdf: Adobe Acrobat version of four-page handout
  
  digmove1_e0.gif: For the hearing impaired
  
• Customer Value Plan Update: Christy provided information on activities of the Customer Value Team at SAS Canada
  Presenter: Christy Hobley
  
  CVP update Feb08.ppt: PowerPoint slides
  

Meeting date: 20071019

• JMPing Into the Data Mine: JMP is SAS software designed for dynamic data visualization
  Presenter: Alex Filimon, Novus Consulting
  
  Novus_JMP.ppt: Powerpoint slides
  
• Data Makes the Difference: Decision Support using SAS in Continuing Care: How can we use data to make the best decisions about how we fund health care services?
  Presenter: Kevin Druhan, NS Dept of Health
  
  DataMakestheDifference.ppt: Powerpoint slides
  
• Bayesian Methods in SAS : Demonstration of PROC BGENMOD
  Presenter: Dr. Pantelis Andreou, CH&E, Dalhousie
  
  Pan_Bayesian.zip: Zip File - Sample SAS program with html output
  
• Creating Custom HTML Output and ActiveX Graphs the easy way through EG : Get your report looking just how you want it, in half the time.
  Presenter: Tim Trussell, SAS Canada
  
  Trussell_EG.zip: Zip - PowerPoint, Excel and EG Project files
  
• Techie Tip: How to create a footnote that contains the date and the name of the program that generated it
  Presenter: Martha Cox, Population Health Research Unit
  
  AUsefulFootnote.ppt: PowerPoint slides
  
  UsefulFootnote.doc: MSWord document
  
• SAS Global Forum post-mortem: Fun and excitement at Disney World - including all the papers from the talks I saw.
  Presenter: John Fahey, RCP of NS
  
  SUGIPapers.pdf: Adobe pdf file - Conference Proceeding extract
  

Meeting date: 20070223

• SAS/Graph: PROC GReplay: Display multiple graphs simultaneously using this feature of SAS/Graph.
  Presenter: Cory Russell, N.S. Department of Health
  
  regreplay.zip: Zip file
  
• SAS/Connect: Accessing a DBMS Directly using SAS.
  Presenter: Dan Ricard, Dalhousie Department of Math and Statistics
  
  Ricard_SAS_ACCESS_SHRUGtalk.pdf: Adobe Acrobat portable document format file
  
• Regression using SAS: Multiple Options: Linear Regression Analysis with a focus on Influence Diagnostics using PROC REG
  Presenter: Voytek Grus, Nova Scotia Power
  
  regression.ppt: PowerPoint slides
  
  regression.sas: SAS code
  
  fueldata.sas7bdat: Dataset used by example SAS program
  
• Enterprise Miner - A case study on Organic Food Marketing in a Grocery Store : Contact the presenter directly.
  Presenter: Sue Walsh, SAS Institute Cary, NC, Susan.Walsh@sas.com
  
• BI Overview : SAS Business Intelligence tools and applications. Powerpoint presentation at http://www.sas.com/offices/NA/canada/downloads/presentations/Caribbean/BI_Overview.pdf
  Presenter: James Waite, SAS Institute (Canada), James.Waite@sas.com
  

Meeting date: 20061109

• Beyond Opportunity; Enterprise Miner: Exploring SAS Enterprise Miner with an example from Ronalda's consulting work.
  Presenter: Ronalda Koster
  
  Beyond_Opportunity Enterprise Miner.ppt: Powerpoint slides
  
• Techie Tip 1: Multiple Inputs, Mulitple Outputs - as seen at NESUG 2006 in Philadelphia.
  Presenter: John Fahey
  
  MIMO.zip: See readme.txt in zipfile for descriptions
  
• Techie Tip 2: Getting Data into and out of SPSS and Excel
  Presenter: Dr. Pantelis Andreou, Dept. of CH&E, Dalhousie University
  
  spss.sas: SAS code to create an SPSS dataset or Excel spreadsheet
  
  factor.xls: Excel spreadsheet created from within SAS
  
  factor.sav: SPSS dataset created
  
• Techie Tip 3: Taking Out the Garbage - A simple macro to clear out potential problems and nuisances when running multiple SAS programs.
  Presenter: John Fahey p.p. Adam LaManna
  
  Lets Restart.ppt: PowerPoint slides
  
  restart.sas: The actual macro
  
• POWER PLAY: Hockey Example of Proc Power - details available directly from Tim.Trussell (at) sas.com
  Presenter: Tim Trussell - SAS Canada
  

Meeting date: 20060224

• Welcome and Introduction:
  Presenter: John Fahey, President, RCPNS and Christy Hobley, SAS Canada
  
  Agenda_20060224.htm: HTML file
  
• Using PROC LOGISTIC: Concepts and applications of logistic regression using SAS
  Presenter: Voytek Grus, Nova Scotia Power Inc.
  
  Logistic_Regression_Using_SAS.ppt: Powerpoint presentation
  
  Logistic_Regression_using SAS_examples.sas: SAS code
  
• "SAS Stored Processes - An analyst’s perspective: An overview of stored processes and how to create and distribute them for use with SAS Enterprise Guide and other applications
  Presenter: Sylvain Tremblay, SAS Canada
  
  Sylvain_Halifax_24FEB2006.ppt: Powerpoint presentation
  
• Techie Tips 1: Using Symput and Symget
  Presenter: Pantelis Andreou, Community Health and Epidemiology, Dalhousie University
  
  Pan_Symput_Symget.sas: SAS code
  
• Techie Tips 2: Superscripts in SAS Output, The Skip Macro
  Presenter: Martha Cox, Population Health Research Unit, Dalhousie University
  
  Superscripts.ppt: Powerpoint presentation
  
  Skip_Macro.ppt: Powerpoint presentation
  
• Final Jeopardy with Allegedly Fabulous Prizes: Quiz game fun
  Presenter: John and Christy
  
  SHRUG_Jeopardy.ppt: Powerpoint presentation
  

Meeting date: 20050311

• Introduction and Welcome: Acknowledgement of speakers, information on NESUG, preamble to meeting, agenda.
  Presenter: John Fahey, Reproductive Care Program of Nova Scotia (RCPNS)
  
  Welcome_20050311.ppt: Powerpoint presentation
  
  Agenda_20050311.doc: MS Word file
  
• Application of SAS Software at Nova Scotia Power: Balancing the use of SAS and Excel for analytical and information needs of marketing and regulatory departments.
  Presenter: Voytek Grus, Pricing Specialist, Marketing Dept., Nova Scotia Power
  
  SAS_Software_at_NSPI.ppt: Powerpoint presentation
  
• "What's wrong NOW?!: An introduction to debugging SAS programs for beginners
  Presenter: Martha Cox, Population Health Research Unit, Dalhousie University
  
• Creating Internet Applications with SAS/Intrnet Software: How to apply SAS programming knowledge to create dynamic SAS applications for the Internet
  Presenter: David Ghan, Education, SAS Canada
  
  SAS_Internet_Applications.pdf: Slides in Adobe PDF file
  
• Techie Tips: File listing, array usage, password hiding, and a boxplot demo
  Presenter: John Fahey, RCPNS
  
  TechieTips_20050311.zip: First three techie tips + SAS code
  
  BoxPlotDemo.zip: HTML files, GIF file
  

Meeting date: 20040227

• Welcome/Agenda: The Game Plan for SHRUG itself and for each meeting. xxx
  Presenter: John Fahey
  
  20040227_welcome_agenda.zip: Powerpoint slides, agenda
  
• Output Delivery System: Christie's presentation on ODS is available directly from her - Christy.Hobley (at) sas.com
  Presenter: Christie Hobley
  
• Techie Tips: Techie Tips are meant to be short presentations that provide a tidbit to make your life simpler when using SAS. They can be arcane or simple but all are meant to fit into the news you can use category.
  Presenter: John Fahey
  
  20040227_techie_tips.zip: See readme.txt in zipfile for descriptions
  
• Using FSEDIT for Data Entry : Pan's presentation on FSEDIT is available directly from him - Pantelis.Andreou (at) dal.ca
  Presenter: Christie Hobley
  
• Integration with Third-Party Tools : Luke's presentation on Third-Party integration is available directly from him, see http://www.lucastech.ca/info_contact.html
  Presenter: Luke Young
  
• SUGI Info: Christy provided information on SUGI 29 - see her Insights article: http://www.sas.com/offices/NA/canada/newsletter/insights/jan04/index.html
  Presenter: Christie Hobley
  

To post presentation files or other content for download please contact the website administrator .

Presentations from other SAS groups across Canada are available at the SAS Canada Customer Value site .