01-02-2014 03:47 PM
Thanks for you reply.
I need to merge two data sets. The merge is between 2 tables and I need to take the values of Table 2 in case in Table 1 have in those places a specific value and in the rest of the cases take the values of Table 1.
Do you understand?
Thank you very much
01-02-2014 04:48 PM
Well, if certain conditions are in place ... like both tables contain at most one observation per ID ... you could try it like this:
if name='Specific Value' then name=' ';
update table2 (in=in2 keep=id name) table1_revised (in=in1);