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

Occasional Contributor
Posts: 9

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

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

PROC Star
Posts: 1,217

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

What have you tried so far?

Occasional Contributor
Posts: 9

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

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

Super User
Posts: 9,431

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

As @draycut 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.

Occasional Contributor
Posts: 9

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

`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;`
Discussion stats
• 4 replies
• 105 views
• 0 likes
• 3 in conversation