Hi, I am working with PROC MIXED to test different treatments after removing the spatial autocorrelation effect by using the semivariogram parameters. Now, I want to export a dataset with the model estimates and residues for each observation but SAS is copying the same variable estimate for all the observations belonging to the same treatment. I am using the following code, any tip? I am using SAS 9.4. I have attached the database "A". Thanks proc mixed data=A;
class Treat_numb;
model DY=Treat_numb/ ddfm=kr s residual outp=resid;
repeated/ subject=intercept local type=sp(gau)(x y);
parms (2.58)(46.8)(0.0026)/ noiter;
LSMEANS Treat_numb / ADJUST=TUKEY ;
run;
PROC EXPORT
DATA=resid
dbms=xlsx
outfile= "D:\resid.xlsx"
replace;
quit;
... View more