lab13 - Statistics 440: Lab Exercises 13 Before you begin:...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Statistics 440: Lab Exercises 13 1 Before you begin: Login to Illinois Compass (compass.uiuc.edu) and download the SAS data files from the Data/Lab13 folder. Save them in D:\ netid ’ (or folder of your choice). When you reference the SAS data sets, use the library ‘ st ’. 1. Performing Queries Using PROC SQL The SAS table rduschedule has one row representing each time a flight attendant or pilot is scheduled to fly into RDU (Raleigh/Durham) airport. It contains the flight number, the date of the flight, and the employee’s identification number. Partial Listing of rduschedule FltID SchDate EmpID IA03600 03JAN2000 E00075 IA03600 03JAN2000 E00434 IA03600 03JAN2000 E00481 IA02400 16JAN2000 E00082 IA02003 20JAN2000 E00082 IA02003 20JAN2000 E00485 IA02005 23JAN2000 E00481 a. Use PROC SQL to create a listing report of all observations from rduschedule. b. Produce a listing of all flights into RDU with the number of crew assigned on each day to each flight. Partial Output SchDate FltID NumCrew ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ 03JAN2000 IA03600 3 16JAN2000 IA02400 1 20JAN2000 IA02003 2 23JAN2000 IA02005 1 07FEB2000 IA02402 1 14FEB2000 IA02403 4 16FEB2000 IA02000 1 17FEB2000 IA02405 3 19FEB2000 IA02004 1 c. Alter the statement in b . to create a listing of all flights into RDU in February 2000 or earlier with the number of crew assigned on each day to each flight.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 10/31/2011 for the course STAT 440 taught by Professor Muyot,m during the Fall '08 term at University of Illinois, Urbana Champaign.

Page1 / 3

lab13 - Statistics 440: Lab Exercises 13 Before you begin:...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online