topic Re: consulta merge in SAS Programming

consulta merge

Lopes — Thu, 02 Jan 2014 20:15:23 GMT

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

Re: consulta merge

NaveenSrinivasan — Thu, 02 Jan 2014 20:28:31 GMT

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

Re: consulta merge

Lopes — Thu, 02 Jan 2014 20:47:17 GMT

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

Re: consulta merge

Astounding — Thu, 02 Jan 2014 21:48:42 GMT

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;