Date:         Fri, 14 Jan 2011 08:42:56 -0500
Reply-To:     Arthur Tabachneck <art297@ROGERS.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Arthur Tabachneck <art297@ROGERS.COM>
Subject:      Re: Merge with same var name in both datasets
Comments: To: Samuel E <samuel.escarigo@DUNNHUMBY.COM>

Samuel,

I don't think you tried the code I suggested.  I get the following results:

           . A
           . B
         -12 A TEST
         -12 B TEST
         -12 C TEST
         -11 A TEST
         -11 B TEST
         -11 C TEST

Isn't that what you indicated you wanted?

Art
--------
On Fri, 14 Jan 2011 08:32:38 -0500, Samuel E <samuel.escarigo@DUNNHUMBY.COM>
wrote:

>If I include "if ina;" in the data merge I get the same results as without
>it.
>
>If I include "if ina and inb;" I don't get all observations from PROD,
>which I want, and neither I get the values of prod_desc from
>DUMMY_HIERARCHY.
>
>Eventually, a solution could be to use update instead of merge but
>sub_tpnb isn't unique, so it doesn't work here...