s-news
[Top] [All Lists]

[no subject]

To: s-news@wubios.wustl.edu
From: Cavenaugh <sjcav@aros.net>
Date: Wed, 24 Feb 1999 22:32:09 -0700
Sender: owner-s-news@wubios.wustl.edu
Hi,

        I have two data frames X and Y, X is as the following:

                Column1         Column2 Column3
                   1                       a             X1
                   2                       a                X2
                   3                       a               X3
                   1                       b               X4
                   2                       b               X5
                   3                       b               X6

        Data frame Y is as the following

                Column1         Column2 Column3
                   1                       a               Y1
                   3                       b               Y2

I want to compare column1 and column2 of data frame X and Y. When the
elements in both columns in the two data frames are the same, I want to use
the content in column3 of Y to replace the corresponding one in column3 of
data frame X.  The results of the above example should look as the following:

                Column1         Column2 Column3
                   1                       a             Y1
                   2                       a                X2
                   3                       a               X3
                   1                       b               X4
                   2                       b               X5
                   3                       b               Y2

Thanks for your help in advance.

---Sharon



-----------------------------------------------------------------------
This message was distributed by s-news@wubios.wustl.edu.  To unsubscribe
send e-mail to s-news-request@wubios.wustl.edu with the BODY of the
message:  unsubscribe s-news

<Prev in Thread] Current Thread [Next in Thread>
  • [no subject], Cavenaugh <=