Help using Base SAS procedures

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

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 19
Accepted Solution

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

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;

 


Accepted Solutions
Solution
‎01-27-2016 06:47 PM
Super User
Posts: 10,460

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

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

View solution in original post


All Replies
Super User
Posts: 17,734

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

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.

 

 

Occasional Contributor
Posts: 19

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

Dear @Reeza,

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

 

Kind Regards

Sohel

Super User
Posts: 17,734

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

[ Edited ]

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

Occasional Contributor
Posts: 19

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

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.
Super User
Posts: 17,734

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

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. 

Solution
‎01-27-2016 06:47 PM
Super User
Posts: 10,460

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

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

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 6 replies
  • 565 views
  • 3 likes
  • 3 in conversation