Date:         Tue, 22 May 2001 10:23:28 -0700
Reply-To:     Sharon Well <peach71_us@YAHOO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Sharon Well <peach71_us@YAHOO.COM>
Subject:      Need help in merging
Content-Type: text/plain; charset=us-ascii

Hi Everybody
     I have two datasets as follows

data a

pt  visit  qt  qtc pr

101   1    23   43  54
102   1    23   45  34
103   1    45   23  43

data b

pt visit abnml    parm

101  1    ab   right atrophy
101  1    ab   left atrophy
102  1    nm   misc
103  1    nm   blah

I want the merged datasets to look like this

pt  visit qt  qtc  pr   abnml       parm

101   1    23   43  54    ab    right atrophy
                          ab    left atrophy
102   1    23   45  34    nm    misc
103   1    45   23  43    nm    blah

When I do a merge using pt and visit as by variables I
get the following output

pt  visit qt  qtc  pr   abnml    parm
101   1    23   43  54   ab   right atrophy
101   1    23   43  54   ab   left atrophy
102   1    23   45  34   nm   misc
103   1    45   23  43   nm   blah

I don't want the common values to repeat for the
second time in pt 101.  I know I cannot accomplish
this using merge statements since it retains those
values.  Any other alternative ways to accomplish
this?Thanks in advance.

Sharon





__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/