Create one observation for each year

Assignment Help Applied Statistics

Reference no: EM13844405

SAS question. Need the code.1.Your company payroll department must project total employee costs (wages, retirement, benefits, and medical benefits) through future years based on assumed increases.

Create a SAS data set named future with four variables: Year and the three variables (Wages, Retire, Medical ) shown below.

Variable Current Value Estimated annual increase

Wages $1,284,000 6.0%

Retire 1,765,000 1.4%

Medical 649,000 9.5%

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.

Use SAS date functions to guarantee that the value of Year in the first observation is the upcoming year, regardless of the current year. (i.e., the current year is 2007, the value of Year in the first observation will be 2008).

Print the data set to verify your results.

2. Modify the previous program to create a new variable named TotCost that is the sum of the wage, retirement, and medical costs for each year. Print the data set.

3. Corporate income for last year was $50,000,000. Income is projected to increase at 1 percent per year. Modify the previous program so that the DO LOOP stops when the year's total costs exceed the year's income.

Print the data set to verify that total costs exceed income after 26 observations.

Reference no: EM13844405

Questions Cloud

Explain the meaning of polymorphism : Explain the meaning of polymorphism

Store sells a particular brand of monochrome : A small retail store sells a particular brand of monochrome and color television sets. Each monochrome set that is sold earns a profit of $100, while each color set earns $200 profit. The manager of the store estimates that the weekly demands for eac..

Discussion and critical thinking : 1. Which sentence is the better topic sentence, the first or the third? Explain why.

Develop excel spread sheet to analyse operations of business : Develop and excel spread sheet to analyse the operations of the business you have chosen over a three year period, use ratio analysis, trend analysis and other qualitative information to undertake the analysis.

Create one observation for each year : 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;..

What do you mean by operator overloading : What do you mean by operator overloading

The recommended daily allowance rda : The recommended daily allowance (RDA) of cobalamine (Vitamin B12) for growing teens is 2.4 μg(micrograms). My brother takes it upon himself to make sure that everyone gets the message. It is generally believed that growing teens are getting less than..

Write short notes on nested class : Nested class

Find interval on which function is increasing and decreasing : Find the intervals on which the function f(x) = x2/3(10 - x) is increasing and decreasing.

User Account

All Pages