Hello,
I want to merge two datasets using a common "id" variable that is in both of them. However, the "id" variable is"string" and is a mixture of "Q" and some numbers such as Q2515789.
I tried to use this "id" variable with the command
, but it did not merge them and only put the second database below the first one like what the command
does.
Should I convert the "id" first to something else? How?
Please let me know how the command
works this kind of variables.
Thanks for your help.
Hossein
I want to merge two datasets using a common "id" variable that is in both of them. However, the "id" variable is"string" and is a mixture of "Q" and some numbers such as Q2515789.
I tried to use this "id" variable with the command
Code:
merge 1:1 id
append
Should I convert the "id" first to something else? How?
Please let me know how the command
merge
Thanks for your help.
Hossein
Comment