Date:         Fri, 14 Jan 2011 13:51:00 +0000
Reply-To:     Samuel Escarigo <Samuel.Escarigo@DUNNHUMBY.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Samuel Escarigo <Samuel.Escarigo@DUNNHUMBY.COM>
Subject:      Re: Merge with same var name in both datasets
Comments: To: Arthur Tabachneck <art297@ROGERS.COM>
In-Reply-To:  <201101141342.p0EBkYtU005952@wasabi.cc.uga.edu>
Content-Type: text/plain; charset="us-ascii"

Hi Art,

Thanks, yes it's what I want.

But why the original code, even including "if ina;" doesn't creates that output? Isn't it supposed to get the values from the second dataset when the variable is present in both tables?

Many thanks,

Sam


-----Original Message-----
From: Arthur Tabachneck [mailto:art297@ROGERS.COM]
Sent: 14 January 2011 13:43
To: SAS-L@LISTSERV.UGA.EDU; Samuel Escarigo
Subject: Re: Merge with same var name in both datasets

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...
The contents of this message and any attachments to it are confidential and may be legally privileged.
If you have received this message in error you should delete it from your system immediately and advise the sender.
dunnhumby may monitor and record all emails. The views expressed in this email are those of the sender and not those of dunnhumby.