Search arrays based on similar values
On Apr 5, 2011, at 6:34 PM, mjdubya wrote:
Hey folks,
I have two arrays: "A" (1X100) with non-ordered values ranging 1-14
"B" (2X14) containing 14 decimal values.
I would like to create a new array (1X100) that contains only the
decimal
values from array B by associating the integers from A and B. In
other
words, for each value of A find the same integer value of B, select
the
associated decimal value of B.
Sounds like a job for merge(). Tested solutions offered when reproducible examples are provided.
A B newarray 1 1 0.1 0.1 1 2 0.3 0.1 1 3 0.14 0.1 2 4 0.2 0.3 3 5 0.82 0.14 3 6 0.21 0.14 4 . . 0.2 7 . . . 14 . . . 4 14 0.03 . 3 . 5 . . . . .
David Winsemius, MD West Hartford, CT