s-news
[Top] [All Lists]

Re: split data set by two variables

To: Zheng_Jenny <Zheng_Jenny@Allergan.com>
Subject: Re: split data set by two variables
From: calzola@cox.net
Date: Wed, 21 Jan 2009 14:43:47 -0500 (EST)
Cc: s-news@wubios.wustl.edu
User-agent: Laszlo Mail 2
It would help to know how you are intending to use these subsets. Many S-Plus functions provide a subset argument that allow you perform the analyses on only the subsets you are interested in. If this is the case, you wouldn't need to create additional datasets.

Best regards,

Carlos Alzola


On Wed, Jan 21, 2009 at 2:39 PM , Zheng_Jenny wrote:

Hi, Dear all,


I have dataset including 4columns and I would like to subset the data
set into 16 tables based on V2 and V3 .  The data is given below:

V1  V2 V3    V4

 1  A 100 -0.276080217

 2  D 100 -0.755085249

 3  D 300  0.070568229

 4  D 100 -0.034123587

 5  C 300 -0.783312701

 6  B 200 -0.009916936

 7  C 100  0.121634851

 8  A 300  1.179237171

 9  A 300 -0.082016520

10  D 100 -0.354451950

11  C 400 -0.380629658

12  B 100 -1.086790089

13  B 400 -1.193285781

14  B 100  1.256262475

15  A 300  2.601771332

16  B 400  0.486331159

17  C 100 -0.657802222

18  D 200  0.187357840

19  D 100  0.984822191

20  B 100  0.993325648

21  C 300 -0.122128302

22  A 200  0.653194345

23  D 200 -0.941139519

24  B 300 -0.962417052

25  B 200 -0.868492638

26  D 400 -1.369687541

27  A 300 -1.137516488

28  B 100  1.257390239

29  B 400  0.717791479

30  A 200 -0.668566890

31  C 200  0.406858215

32  C 300  0.082724360

33  A 300 -0.083015690

34  C 200 -0.040329438

35  C 200  1.308646392

36  C 200 -0.481138082

37  A 100  0.691464187

38  D 300 -0.843482695

39  C 200 -0.625104873

40  A 400 -0.141905432


I would like to have table 1 include V2=A and V3=100, table 2 including
V2=A and V3=200, and so on.  What would be most effective way of doing
that?  Thanks,


Jenny




</pre><P><FONT face="Verdana" color=blue size=1><SPAN style="FONT-SIZE: 8pt; COLOR: blue"> This e-mail, including any attachments, is meant only for the intended recipient and may be a confidential communication or a communication privileged by law. If you received this e-mail in error, any review, use, dissemination, distribution, or copying of this e-mail is strictly prohibited. Please notify the sender immediately of the error by return e-mail and please delete this message from your system. Thank you in advance for your cooperation.
</SPAN></FONT></P>

<Prev in Thread] Current Thread [Next in Thread>