MVSFORUMS.com

[Bharath.AK]

Hi,

I have two datasets:

Dataset A:
Key: Misc:
AMC WIRE
AMC WIRE
AMC WIRE
ABD XXXX

Dataset B:
Key: Misc:
AMC NETTING

I need to merge these two datasets BY the variable KEY so that the output dataset should contain all the observations in Dataset A and the matched observations should have MISC variable updated to what we have in Dataset B:

Output:
Key: Misc:
AMC NETTING
AMC NETTING
AMC NETTING
ABD XXXX

I am doing the merge as below:

[expat]

I'm not sure that you can do what you want with the two variable names being the same.

I would change the variable name on one file and then use the code below
The code assumes that the SAS dataset already exists, if not then just create it with the different variable name.