topic Re: Compute num of emp in each of the dept. after 10 year. in SAS Programming

Compute num of emp in each of the dept. after 10 year.

Karan_Dumbre — Wed, 13 Sep 2017 12:19:43 GMT

Write a SAS program to create a forecasting application to compute number of employees in each of the department of Orion Star after 10 years.

Below is the dataset

Re: Compute num of emp in each of the dept. after 10 year.

PeterClemmensen — Wed, 13 Sep 2017 12:29:33 GMT

What have you tried so far?

Re: Compute num of emp in each of the dept. after 10 year.

Karan_Dumbre — Wed, 13 Sep 2017 12:35:37 GMT

i was trying to put a loop for increment but each of the observation have different increment numbers so how should proceed

Re: Compute num of emp in each of the dept. after 10 year.

RW9 — Wed, 13 Sep 2017 12:38:31 GMT

As @PeterClemmensen has said, what have you tried? Post test data in the form of a datastep in the post using a code window - its the {i}. Post what the output should look like. Supply any code you have tried, or logic you may want included.

Re: Compute num of emp in each of the dept. after 10 year.

Karan_Dumbre — Wed, 13 Sep 2017 12:50:33 GMT

data g1;
set "/folders/myshortcuts/myfolder/Imarticus/prg2/growth.sas7bdat";
year = 0;
do while (year < = 10);
 if _N_ = 1 then 
  Total_employees + (total_employees * 0.25);
 else if _N_ = 2 then
  Total_employees + (total_employees * 0.3);
  else if _N_ = 3 then
  Total_employees + (total_employees * 0.1);
  else if _N_ = 4 then
  Total_employees + (total_employees * 0.2);
  else if _N_ = 5 then
  Total_employees + (total_employees * 0.3);
  else if _N_ = 6 then
  Total_employees + (total_employees * 0.1);
end;
run;