{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

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

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

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.

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### 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
Ask a homework question - tutors are online