Date:         Mon, 13 Nov 2006 12:30:43 -0800
Reply-To:     David L Cassell <davidlcassell@MSN.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         David L Cassell <davidlcassell@MSN.COM>
Subject:      Re: Quick and hopefully easy question
In-Reply-To:  <1163330793.123699.11810@h54g2000cwb.googlegroups.com>
Content-Type: text/plain; format=flowed

alves.paulo@GMAIL.COM wrote:
>
>Hi guys.
>
>Need to make a stange merge, and having some problems how to do it (at
>least with datasteps).
>
>I have 2 datasets (treatment and no-treatment) and I need to merge the
>datasets in a way that each observation in the treatment dataset will
>be merged with all no-treatment patients with the same age. some
>treatments patients have the same age and when the age repeats I need
>again all no-treatment patients.
>
>Datasets are pretty big so I trying to find a way that optimises speed.
>
>example
>
>Dataset treatment
>a xx  25
>a yy  30
>c tt   25
>d tt   35
>
>Dataset no-treatment
>1  25
>2  25
>3  30
>4  35
>5  35
>6  25
>7  25
>8  30
>
>Result
>a xx 25 1
>a xx 25 2
>a xx 25 6
>a xx 25 7
>
>a yy  30 3
>a yy  30 8
>
>c tt   25 1
>c tt   25 2
>c tt   25 6
>c tt   25 7
>
>d tt   35 4
>d tt   35 5
>
>Thanks in advance.

What are you trying to achieve with this merge?

This looks like you want some sort of match-merge for
case-control analysis.  Is that right?  If so, what do you
*really* want to do with these data?

And big are your 'big' data sets?

HTH,
David
--
David L. Cassell
mathematical statistician
Design Pathways
3115 NW Norwood Pl.
Corvallis OR 97330

_________________________________________________________________
Find a local pizza place, music store, museum and more…then map the best
route!  http://local.live.com?FORM=MGA001