Date:         Tue, 16 Oct 2007 03:37:33 +0000
Reply-To:     toby dunn <tobydunn@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         toby dunn <tobydunn@HOTMAIL.COM>
Subject:      Re: Matching Variables
Comments: To: Randy <randistan69@hotmail.com>
In-Reply-To:  <200710160333.l9G32U5m021967@mailgw.cc.uga.edu>
Content-Type: text/plain; charset="iso-8859-1"

Randy ,

Im slighly confused your example data has only 4 variables and you are saying have 6.  Also I dont see where VarB and VarC have the same value in your emaple data set.


Toby Dunn

Compromise is like telling a lie, it gets easier and easier. Each compromise you make, that becomes your standard.

Perfection doesnt exist, once you reach it, its not perfect anymore. It means something else.

> Date: Mon, 15 Oct 2007 23:33:44 -0400
> From: randistan69@HOTMAIL.COM
> Subject: Matching Variables
> To: SAS-L@LISTSERV.UGA.EDU
>
> Dear all:
> Here is my question. I need to match values for VarB with the values
> for VarC. Also, for those values i need to extract values of VarA, VarD
> and VarE. So for eaxample
>
> VarA VarB VarC VarD VarE VarF
> 1 101 412.25 2
> 1 102 45.32 3
> 1 102 25.76
> 1 103 34.4 7
> 2 102 12.22 .
> 1 104 75.23 11
> 2 102 6.23 .
> 2 102 7.12 .
> 2 103 5.23 .
>
> so my data set should look like
> VarA VarB VarC VarD VarE
> 1 102 45.32
> 1 102 25.76
> 1 103 34.4
> 2 102 12.22
> 2 102 6.23
> 2 102 7.12
> 2 103 5.23
> So VarB = 102 = VarC = 102
> Similarly VarB = 103 = VarC = 103
> Please Help.
>
> Randy

_________________________________________________________________
Help yourself to FREE treats served up daily at the Messenger Café. Stop by today.
http://www.cafemessenger.com/info/info_sweetstuff2.html?ocid=TXT_TAGLM_OctWLtagline