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
Content-Type: text/plain; format=flowed
>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.
>a xx 25
>a yy 30
>c tt 25
>d tt 35
>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?
David L. Cassell
3115 NW Norwood Pl.
Corvallis OR 97330
Find a local pizza place, music store, museum and more…then map the best