lab12 - Statistics 440: Lab Exercises 12 Before you begin:...

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

View Full Document Right Arrow Icon
Statistics 440: Lab Exercises 12 1 Before you begin: Login to Illinois Compass (compass.uiuc.edu) and download the SAS data sets from the Data/Lab 12 folder. Save them in ‘ D:\ netid ’ or folder of your choice. 1. Concatenating SAS Data Sets The goal is to create a second-quarter data set for International Airlines’ Vienna hub. Combine target information for April, May, and June into one data set. This data is currently stored in separate data sets by month as follows: st.aprtarget st.maytarget st.juntarget a. As a first step, browse the descriptor portion of each data set to determine the number of observations, as well as the number of variables and their attributes. How many observations does each data set contain? st.aprtarget st.maytarget st.juntarget What are the names of the variables in each data set? st.aprtarget ______________________________________________________________ st.maytarget ______________________________________________________________ st.juntarget ______________________________________________________________ b. Concatenate the three data sets and create a new data set called work.q2vienna . Rename any variables necessary. c. Browse the SAS log. There should be no warning or error messages. How many observations are written to the new data set? How many variables does the new data set contain?
Background image of page 1

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

View Full DocumentRight Arrow Icon
Statistics 440: Lab Exercises 12 2 d. Submit a PROC PRINT step to verify the data. Partial Output (First 9 of 307 observations) The SAS System D e s F t l i F E i n T T g a a a h t D r r F E O t i a g g R R b I o t e e e e s D n e t t v v 1 IA06100 CDG 01APR2000 8 85 $3,328.00 $11,730.00 2 IA05900 CDG 01APR2000 8 85 $2,392.00 $8,415.00 3 IA07200 FRA 01APR2000 10 97 $1,720.00 $5,432.00 4 IA04700 LHR 01APR2000 14 120 $2,576.00 $7,320.00 5 IA06100 CDG 02APR2000 8 85 $3,328.00 $11,730.00 6 IA05900 CDG 02APR2000 8 85 $2,392.00
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 5

lab12 - Statistics 440: Lab Exercises 12 Before you begin:...

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

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