Vlookup question

[Dougie Jones]

Hi. This is a simple question but somehow I cant figure out the code. I want to transform the following dataset:

input id1 volume_productx id2 volume_producty
1 100 2 150
2 300 4 400
3 50 2 150
4 600 5 400
5 200 3 250
end

Into this format:

input id1 volume_productx volume_producty
1 100 .
2 300 150
3 50 250
4 600 400
5 200 400
end

I have looked at the vlookup package and have tried merging but to no avail.

[Dougie Jones]

Fixed this already..

vlookup id1, gen(vol_prody_new) key(id2) value(volume_producty)
drop id2 volume_producty