Victoria SAS Users Group

From sasCommunity
Jump to: navigation, search

The SAS Users Association of Victoria, eh? (SUAVe) is based in Victoria, BC, Canada, and meets semi-annually. Anyone with an interest in SAS® software is welcome to attend.

Presentation Archive

Some previous presentations are available here: SUAVe on SAS Canada site

Next SUAVe (SAS Users Association of Victoria, eh?) Meeting

Tuesday, May 28, 2013, 12:15-4:30
Aud A & B (basement)
Ministry of Health
1515 Blanshard St
Victoria BC

Take on the SUAVe Open Problem and walk through your solution at the May SUAVe meeting! Details below!


Agenda for next SUAVe (SAS Users Association of Victoria, eh?) Meeting


Start Mins Speaker Topic
12:15pm 45 --- Registration & Networking ---
1:00pm 5 Peter Ott (BC Ministry of Forests, Lands & NRO) & Matt Malczewski (SAS Canada) SUAVe meeting kick off
1:05pm 20 Matt Malczewski, SAS Canada SAS Visual Analytics (or, Learning to Love the Drag & Drop)
1:25pm 50 Marje Fecht, Prowerk Consulting Quick Hits: My Favourite SAS Tricks
2:15pm 30 Local users! Solutions to the Open Problem
2:45pm 15 --- Networking Break ---
3:00pm 20 Catherine Bealle Statland, BC Ministry of Forests, Lands & NRO Experiences from SAS Online Training with Proc Glimmix
3:20pm 10 Mike Atkinson SAS Global Forum Debrief
3:30pm 30 Marje Fecht, Prowerk Consulting Getting the Right Dates
4:00pm 20 --- Prize Draw & Closing Remarks ---
4:20pm Done



Open Problem for May 28th SUAVe Meeting

The open problem for the upcoming SUAVe meeting is to write a SAS program that reads-in the data provided below, summarizes it, and then writes-out the summarized data to an Excel spreadsheet. The data below represents Air Canada’s current fleet of aircraft:

Airline or Subsidiary   Manufacturer    Aircraft        Quantity
Air Canada              Boeing          777-300               12
Air Canada              Boeing          777-200                6
Air Canada              Airbus          A330-300               8
Air Canada              Boeing          767-300               28
Air Canada              Airbus          A321-200              10
Air Canada              Airbus          A320-200              41
Air Canada              Airbus          A319-100              35
Air Canada              Embraer         190                   45
Air Canada              Embraer         175                   15
Air Canada Express      Bombardier      CRJ 705               16
Air Canada Express      Bombardier      CRJ 100/200           34
Air Canada Express      Bombardier      Q400                  26
Air Canada Express      Bombardier      Dash 8-300            26
Air Canada Express      Bombardier      Dash 8-100            34
Air Canada Express      Beechcraft      1900D                 17
Air Canada Rouge        Boeing          767-300                2
Air Canada Rouge        Airbus          A319-100               2



How you get this data into your SAS program is not important (e.g. you may copy and paste it into a datastep, save it first as a file, etc).

What is important is that you summarize it as shown below, and then export it to Excel, or at least a file type that is read-able to Excel. You are not allowed to use features such as “Copy Contents to Clipboard” or “View In Excel” within the SAS Explorer Window. Here is a depiction of the required spreadsheet (copied from Excel so we don’t have to attach a separate*. xlsx file):

SUAVe OpenProblem May2013.jpg

Bonus marks will be given to those solutions that are able to match the formatting (e.g. cell colours, fonts, etc.) of the Excel spreadsheet using only SAS statements and options.

Good luck! Please let one of the SUAVe executive know by May 21st if you'd like to share your solution at the SUAVe meeting.


Cheryl Sivertson, Mike Atkinson, Joel Choy, Gord Nigh, Steve Gibbs, Peter Ott