topic Does proc plm not work to score models built with proc genmod? in Statistical Procedures

Does proc plm not work to score models built with proc genmod?

RobertWF1 — Fri, 28 Jan 2022 00:57:53 GMT

For a work project I'm building a zero-inflated negative binomial regression model with proc genmod and then attempting to score the model on a test dataset using proc plm.

For example, using the Trajan dataset provided here:

proc genmod data=Trajan;
   class bap photoperiod;
   model roots = bap photoperiod / dist=zinb;
   zeromodel;
   output out=zinb predicted=pred pzero=pzero;
   ods output ParameterEstimates=zinbparms;
   ods output Modelfit=fit;
   store out=zinb_model;
run;

data test;
input roots bap photoperiod;
cards;
1 10 20
2 30 40
;
run;

proc plm source=zinb_model;
	score data=test out=preds_zinb pred=pred;
run;

The code runs fine, no errors in the log, but the output dataset preds_zinb contains missing values (".") in the pred column.

Is proc plm not compatible with proc genmod? It should work - there's a data scoring example on the SAS website here: https://support.sas.com/kb/33/307.html.

Re: Does proc plm not work to score models built with proc genmod?

StatDave — Fri, 28 Jan 2022 01:09:02 GMT

PROC PLM can score new data for this model as discussed and illustrated in this note. The reason that it doesn't work for your TEST data set is that your model has only CLASS predictors and with a CLASS predictor, the model contains only a parameter for each of the observed values in the data used to fit the model. The values in your TEST data set are not values in the observed data. If the variables were not in the CLASS statement, and therefore treated as continuous rather than categorical, then you would get predicted values.

See this note (particularly point 3) on why missing values occur when scoring new data.

Re: Does proc plm not work to score models built with proc genmod?

RobertWF1 — Fri, 28 Jan 2022 13:50:59 GMT

Beautiful! Thank you - I missed that detail about class variables.