consulta merge

Reply
Contributor
Posts: 31

consulta merge

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

Occasional Contributor
Posts: 18

Re: consulta merge

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

Contributor
Posts: 31

Re: consulta merge

Posted in reply to NaveenSrinivasan

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

Super User
Posts: 5,498

Re: consulta merge

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;

Ask a Question
Discussion stats
  • 3 replies
  • 203 views
  • 0 likes
  • 3 in conversation