topic Id in solution output from random statement in PROC MIXED in SAS Procedures

Id in solution output from random statement in PROC MIXED

Boni — Mon, 06 Feb 2012 13:00:21 GMT

Hi,

I wonder if it is possible to retain the original identification (Here: unikdyr) from the dataset in the solution output from the random statement in PROC MIXED.

SAS code:

ods output solutionR=sol;

ods trace on;

PROC MIXED data=b covtest ratio;

id unikdyr;

model ekm = dimund60 dimov60 / s ddfm=bw outp=predicted;

random dimund60 dimov60 int / type=un subject=unikdyr solution;

run;

odc trace off;

In the Solution output (sol) each individual now got a subject number, but I would like to be able to link that subjectnumber to an animalnumber (=unikdyr) because I want to use the random estimates in another model.

Any good ideas??

Thanks - Bodil

Id in solution output from random statement in PROC MIXED

SteveDenham — Mon, 06 Feb 2012 15:01:38 GMT

Add a CLASS statement (I changed the ID statement to a CLASS statement, but you may need both for your outp= option statement):

PROC MIXED data=b covtest ratio;

class unikdyr;

model ekm = dimund60 dimov60 / s ddfm=bw outp=predicted;

random dimund60 dimov60 int / type=un subject=unikdyr solution;

run;

The dataset sol should have what you are looking for.

Steve Denham

Id in solution output from random statement in PROC MIXED

Boni — Mon, 06 Feb 2012 19:07:25 GMT

Thanks Steve!

How simple... Sometimes I tend to complicate things... ;o)