MAE in enterprise Miner

statman123 — Thu, 17 May 2018 14:20:55 GMT

hello

Im running continuous Response (y) models in EM using Decision tree, NN, Reg

I need to compare the mean absolute error (mae) from another system....I cant find the mae in the model comparison output

how can I easily get that from the neural network data set since that is the winning model

thanks

george

Re: MAE in enterprise Miner

WendyCzika — Thu, 17 May 2018 16:24:20 GMT

Since it looks like EM doesn't calculate that measure, you could do the following in a SAS Code node after the Model Comparison node (not sure if this is the best way, but I think it should work):

data mae;
   set &em_import_data end=last; /* you can use another partition here: &em_import_validate or &em_import_test */
   retain sae nobs 0;
   sae + abs(R_target); /* R_target is the residual.  Put the name of your target in for target */
   nobs + 1;
   if last then do;
      mae = sae / nobs;
      output;
   end;
run;
 
proc print data=mae; 
run;

topic Re: MAE in enterprise Miner in SAS Data Science

MAE in enterprise Miner

Re: MAE in enterprise Miner