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;
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: