Victoria SAS Users Group
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
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
|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 ---|
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):
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