Date: Mon, 19 Feb 2001 03:29:54 -0500
Reply-To: Gerhard Hellriegel <ghellrieg@T-ONLINE.DE>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Gerhard Hellriegel <ghellrieg@T-ONLINE.DE>
Subject: Re: Determine which variable is wrong
On Mon, 19 Feb 2001 08:16:59 +0100, ROTH Fabrice
>Content-Type: text/plain; charset=us-ascii
>I was wondering if it was possible to determine which variable was wrong
>in a merge statement.
>I Have that piece of code;
> merge rp011.imlist(in=a) imlist_cartec(in=b);
> by com qr loc im men;
> if a and not b then
> err="Men pas dans la CarteC";
>where both datasets are sorted by com qr loc im men (Their only
>What I want to find out now is why the "if-statement" resolved as true,
>whether the com-variable is different in both data-sets, or qr or loc
>Is there any way to do this ?
add a control variable for each variable of the datasets, which is unique
to the datasets:
The same for the other:
after the merge you have all the information you need. E.g. if acom is
missing and bcom not, it was not in a, but in b...