Date:         Mon, 19 Jan 2009 19:20:33 -0500
Reply-To:     Arthur Tabachneck <art297@NETSCAPE.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Arthur Tabachneck <art297@NETSCAPE.NET>
Subject:      Re: Merging Problem
Comments: To: J M <jasonm@UCLA.EDU>

Jason,

I have a couple of questions:

1. Were there any messages in your log?
2. Were files x and y sorted by cat?
3. Are you absolutely, positively knowledgeable that x doesn't contain any
duplicate cat records?

Art
-------
On Mon, 19 Jan 2009 15:56:15 -0800, J M <jasonm@UCLA.EDU> wrote:

>Does anyone know why these two datasets aren't merging correctly based
>on the following information.
>Should not having an Informat or Label make a difference?
>I have sorted both datasets by cat.
>
>In dataset Y cat is a unique identifier.
>#    Variable     Type    Len    Format    Informat    Label
>3    cat          Num      8       5.
>
>In dataset X cat is not a unique identifier.
>#    Variable     Type    Len    Format    Informat    Label
>4    cat          Num      8      5.           5.      cat_NO
>I used the following code to merge
>data new;
>        merge x y;
>        by cat;
>run;
>
>Thanks.