Date:         Thu, 9 Jul 2009 00:56:28 -0700
Reply-To:     Emanuela <MANUP9@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Emanuela <MANUP9@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: GROUPING FOR FULL SIBS OR HALF SIBS
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

On Jul 8, 2:06 pm, michaelrait...@WESTAT.COM (Michael Raithel) wrote:
> Dear SAS-L-ers,
>
> Emanuela posted the following:
>
>
>
>
>
> > Hello,
> > my data look like:
> > animal sire dam
> > 1 B C
> > 2 D C
> > 3 D E
> > 4 B C
> > 5 B C
> > 6 D C
>
> > Iwould like to know the number of animals that have same sire
> > and dam (=fullsibs) and the number of animals that have only
> > the same sire or dam (halfsibs).
>
> > Is there any one who knows the way to performe this operation?
>
> > thank you in advance
>
> Emanuela, what have you tried so far, or how do you think you should approach this task?  Please post.  Or, is this simply an assignment for the ever-helpful, ever-giving SAS-L first responders?
>
> Emanuela, best of luck in all of your SAS endeavors!
>
> I hope that this suggestion proves helpful now, and in the future!
>
> Of course, all of these opinions and insights are my own, and do not reflect those of my organization or my associates. All SAS code and/or methodologies specified in this posting are for illustrative purposes only and no warranty is stated or implied as to their accuracy or applicability. People deciding to use information in this posting do so at their own risk.
>
> +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Michael A. Raithel
> "The man who wrote the book on performance"
> E-mail: MichaelRait...@westat.com
>
> Author: Tuning SAS Applications in the MVS Environment
>
> Author: Tuning SAS Applications in the OS/390 and z/OS Environments, Second Edition
>
> http://www.sas.com/apps/pubscat/bookdetails.jsp?catid=1&pc=58172
>
> Author: The Complete Guide to SAS Indexes
>
> http://www.sas.com/apps/pubscat/bookdetails.jsp?catid=1&pc=60409
>
> +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> There is not a man of us who does not at times need a helping
> hand to be stretched out to him, and then shame upon him who
> will not stretch out the helping hand to his brother. - Theodore Roosevelt
> +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>
>
> - Hide quoted text -
>
> - Show quoted text -- Hide quoted text -
>
> - Show quoted text -

This is what I have tried s far:

proc sort data=PED
out=FullSibs NODUPKEY;
by sire dam;
run;
proc freq;
table animal/out=FullSibs1;/*number of full sibs animals*/
run;