Date: Mon, 16 Apr 2007 11:49:39 -0500
Reply-To: "Huang, JS" <Huang.JS@PRINCIPAL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Huang, JS" <Huang.JS@PRINCIPAL.COM>
Subject: Re: Quintiles
Content-Type: text/plain; charset="windows-1255"
I can think of two reasons that the group sizes are different:
(1) Your observation count is not a multiple of 5.
(2) There are ties in the ranking, you need decide on your own how to split them into different groups if needed.
Here is an example for (2) above:
airline Rank for
Row DATE (thousands) AIR
1 NOV49 104 1
2 JAN49 112 2
3 JAN50 115 3
4 DEC49 118 4.5
5 FEB49 118 4.5
6 OCT49 119 6
7 MAY49 121 7
8 FEB50 126 8
9 APR49 129 9
10 MAR49 132 10
11 JUN49 135 11.5
12 APR50 135 11.5
13 SEP49 136 13
14 MAR50 141 14
15 JUL49 148 15.5
16 AUG49 148 15.5
If the data is to be split evenly into four groups with four observations in each group, you need to decide which of the two observations with rank 4.5 to go to the first and the second group.
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of mcolowasth@YAHOO.CO.UK
Sent: Monday, April 16, 2007 10:58 AM
I am using proc rank to divide my sample based on quintiles of variable x but the groups created are not equal. Any suggestions on how to create equally sized groups?
This e-mail message is intended only for the use of the individual or
entity to which it is addressed, and may contain information that is
privileged, confidential and exempt from disclosure under applicable law.
If you are not the intended recipient, any dissemination, distribution or
copying of this communication is strictly prohibited. If you have
received this communication in error, please notify us immediately by
reply email to Connect@principal.com and delete or destroy all copies of
the original message and attachments thereto. Email sent to or from the
Principal Financial Group or any of its member companies may be retained
as required by law or regulation.
Nothing in this message is intended to constitute an Electronic signature
for purposes of the Uniform Electronic Transactions Act (UETA) or the
Electronic Signatures in Global and National Commerce Act ("E-Sign")
unless a specific statement to the contrary is included in this message.
While this communication may be used to promote or market a transaction
or an idea that is discussed in the publication, it is intended to provide
general information about the subject matter covered and is provided with
the understanding that The Principal is not rendering legal, accounting,
or tax advice. It is not a marketed opinion and may not be used to avoid
penalties under the Internal Revenue Code. You should consult with
appropriate counsel or other advisors on all matters pertaining to legal,
tax, or accounting obligations and requirements.