04-18-2012 04:38 PM
I am using proc panel to do some analysis.
proc panel outest=parms data = comgasfinal2 ;
id pa year;
model cngc_fs = time1 gasprice gsp1 hddcon scgc sdgec pgep1 scgp1 sdgep1/ rantwo parks;
output out=panelout p=forecast;
I am not sure if its me or it's the procedure but I am not able to forecast the future values of the dependent variable. Procedures like proc reg allow automatic calculation of the future values of the dependent variable. Is this a limitation of proc panel? If so, is there a macro that I can use to automatically generate the final equation for the parameters estimated by proc panel?
04-18-2012 04:54 PM
Says in the doc :
If there are observations in the input data set with missing dependent
variable values but with nonmissing regressors, PROC PANEL can compute predicted
values and store them in an output data set by using the OUTPUT statement. Note
that the presence of such observations with missing dependent variable values
does not affect the model fit because these observations are excluded from the
So, all you need is some observations with the independent variable values for which you want predictions.
04-18-2012 05:00 PM
I have tried that but I get a error message saying you can't have any missing values in the dependent variable. Where did you read that it is ok to have missing values in the dependent variable?
04-18-2012 05:22 PM
Yes, wow it does say that but I get this is error when I include the missing values for the dependent variable and non missing values for the independent variables.
ERROR: Each observation for time point year=2011 has a missing value for at
least one variable in MODEL statement .
NOTE: The SAS System stopped processing this step because of errors.