# Lab11 - Statistics 440 Lab Exercises 11 Before you begin Login to Illinois Compass(compass.uiuc.edu and download the SAS data file ski from the

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

Statistics 440: Lab Exercises 11 1 Before you begin: Login to Illinois Compass (compass.uiuc.edu) and download the SAS data file ski from the Data/Lab 11 folder. We will also use the SAS data set donate used in Lab 10. Save them in D:\ netid (or folder of your choice). Performing Computations with DO Loops The payroll department must project total employee costs (wages, retirement, benefits, and medical benefits) through future years based on assumed increases. a. Create a SAS data set named future with four variables: Year and the three variables shown below. Initialize each of the variables below to their current values, and use a DO loop to calculate their estimated values for the next ten years. For example, next year's wage expense will be this year's wage expense plus 6 percent of this year's amount; in two years, the wage expense will be next year's amount plus 6 percent; and so on. Create one observation for each year. Variable Current value Estimated annual increase Wages Retire Medical \$12,874,000 1,765,000 649,000 6.0% 1.4% 9.5% Use SAS date functions to guarantee that the value of Year in the first observation is the upcoming year, regardless of the current year. (If the program is run in 2006 without any modifications, the value of Year in the first observation will be 2007.) Print the data set to verify your results. b.

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.

## 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 / 4

Lab11 - Statistics 440 Lab Exercises 11 Before you begin Login to Illinois Compass(compass.uiuc.edu and download the SAS data file ski from the

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

View Full Document
Ask a homework question - tutors are online