consulta merge

[Lopes]

Consulta:

Como se puede hacer un merge entre 2 tablas y que tome los valores de la tabla 2 en caso que en la tabla 1 tenga en esos lugares un valor especifico.

Muchas gracias

Maria

[NaveenSrinivasan]

Hola Maria,

lo siento,un poco espanol pero no mucho-Soy Naveen de la india,

por favor explique su pregunta, dando mas detalles!!

gracias,

Naveen

[Lopes]

Hi Naveen,

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

Maria

[Astounding]

Well, if certain conditions are in place ... like both tables contain at most one observation per ID ... you could try it like this:

data table1_revised;

  set table1;

  if name='Specific Value' then name=' ';

run;

data want;

  update table2 (in=in2 keep=id name) table1_revised (in=in1);

  by id;

  if in1;

run;