Hi,
I have a dataset with name 'Data_1' with four columns: 'Factory', 'Item', 'Date', 'Actual_Demand' & 'Prediction_Demand'.
I want to calculate MAPE and MSE that 'Prediction' via 'Actual' group by 'Factory' & 'Item' across 'Date'.
And my code is:
Proc Sql;
Create Table Work.Result_1 as
select distinct
Factory,
Item,
avg(abs((Actual_Demand - Prediction_Demand)/Actual_Demand)) as MAPE,
avg((Prediction_Demand - Actual_Demand)**2) as MSE
from Work.Data_1
group by 1, 2;
Quit;
So that I could obtain a new table with two new columns. Is the formula I have in the code correct to calculate 'MAPE' & 'MSE'?
Thank you very much!
Hi,
I have a dataset with name 'Data_1' with four columns: 'Factory', 'Item', 'Date', 'Actual_Demand' & 'Prediction_Demand'.
I want to calculate MAPE and MSE that 'Prediction' via 'Actual' group by 'Factory' & 'Item' across 'Date'.
And my code is:
Proc Sql;
Create Table Work.Result_1 as
select distinct
Factory,
Item,
avg(abs((Actual_Demand - Prediction_Demand)/Actual_Demand)) as MAPE,
avg((Prediction_Demand - Actual_Demand)**2) as MSE
from Work.Data_1
group by 1, 2;
Quit;
So that I could obtain a new table with two new columns. Is the formula I have in the code correct to calculate 'MAPE' & 'MSE'?
Thank you very much!
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.