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
What have you tried so far?
i was trying to put a loop for increment but each of the observation have different increment numbers so how should proceed
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.
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;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.