Error: "NOTE: The data set WORK.PRED has 0 observations and 0 variables

[sohelsayma]

Hello All,

I was trying to see the climate moisture trend over time for combined sites using proc mixed.   However, when I tried to model it with the following command than an error occurred. It said "NOTE: The data set WORK.PRED has 0 observations and 0 variables."  I have applied the same model for temperature and it was successful. But not for climate moisture data. Please note that The climate moisture data have both negative and positive value. Can you please help me to solve the problem? Thanks.

proc mixed data= import;
   class plot;
   model cmi =  plot plot*year;
run;

proc mixed data=import;
         class plot;
         model cmi = year /  ddfm=kr solution outp=pred;
         random int year / type=un subject=plot solution;
         run;

proc sort data=pred; 
         by year; 
         run;

      proc sgplot data=pred;  
         series y=pred x=year / group=plot;
         run;

[Reeza]

Post your log. 

Most likely you'll see that for some reason the PRED dataset wasn't created from PROC MIXED and then it doesn't flow through your process.

[sohelsayma]

Dear @Reeza,

Thanks for your reply. Please check the attahcment. You can find the log.

Kind Regards

Sohel

[Reeza]

Fix the error in the log before the error you mentioned....

[sohelsayma]

Dear @Reeza,
I have checked the input file. Variable plot and Year are available in the input data file. I have attahced the input data file in my post. Still couldnt figure out the problem.

[Reeza]

You noticed your procedure did not converge WARNING?

I don't know your data and you may want to post this under Statistical Procedures, but the issue is the fact that your model doesn't converge. Why? I don't know...check that your model is specified correctly and that you don't have any other issues. 

[ballardw · Accepted solution]

Your Plot 78p1 has values WAY different than the others and the model does converge when that data is excluded.