Date:         Thu, 14 Aug 2003 09:09:47 -0400
Reply-To:     Ian Whitlock <WHITLOI1@WESTAT.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Ian Whitlock <WHITLOI1@WESTAT.COM>
Subject:      Re: merge two datasets
Comments: To: Howard Schreier <Howard_Schreier@ITA.DOC.GOV>
Comments: cc: "Mai.To@UTH.TMC.EDU" <Mai.To@UTH.TMC.EDU>
Content-Type: text/plain

And the use of AMT in both data sets will cause trouble sooner or later.
Rename one of the variables before the merge.

IanWhitlock@westat.com
-----Original Message-----
From: Howard Schreier [mailto:Howard_Schreier@ITA.DOC.GOV]
Sent: Wednesday, August 13, 2003 9:03 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: merge two datasets


Right.

The LOWCASE or UPCASE function can be used to standardize. That in turn may
lead to the need to re-sort.

On Wed, 13 Aug 2003 15:29:53 -0700, Prasad S Ravi
<prasad.s.ravi@HOUSEHOLD.COM> wrote:

>Sig:
>
>   No wonder she is not finding a match  since the vender values are in
>different 'case'.
>
>
>
>Prasad Ravi
>
>
>
[snip]
>-----Original Message-----
>From: Mai To [mailto:Mai.To@UTH.TMC.EDU]
>Sent: Wednesday, August 13, 2003 4:35 PM
>To: SAS-L@LISTSERV.UGA.EDU
>Subject: merge two datasets
>
>
>I have two datasets:
>
>1st set (trans)
>Transaction             vendor  amt
>01                      e115            15.00
>
>
>2nd set (vend)
>vendor  transaction             amt
>E115            01                      15.
>E115            02                      30.
>
>I used;
>
>What I'm trying to do is just to find the one from 2nd set match the
>first set.
>
>I used:
>
>Data step1;
>  Merge trans(in=t) vend(in=v);
>   By vendor;
>   If t;
>
>But it doesn't work.  I also tried:  if v and not t then delete;  And
>still doesn't work.
>
>Any ideas?
>
>Thanks.
>
>Mia