Help using Base SAS procedures

Id in solution output from random statement in PROC MIXED

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 6
Accepted Solution

Id in solution output from random statement in PROC MIXED

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


Accepted Solutions
Solution
‎02-06-2012 10:01 AM
Respected Advisor
Posts: 2,655

Id in solution output from random statement in PROC MIXED

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

View solution in original post


All Replies
Solution
‎02-06-2012 10:01 AM
Respected Advisor
Posts: 2,655

Id in solution output from random statement in PROC MIXED

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

Occasional Contributor
Posts: 6

Id in solution output from random statement in PROC MIXED

Thanks Steve!

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

☑ This topic is SOLVED.

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

Discussion stats
  • 2 replies
  • 133 views
  • 0 likes
  • 2 in conversation