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.
 Fall '08
 Muyot,M
 Statistics

Click to edit the document details