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;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.