topic Re: Join tables in SAS Enterprise Guide

Join tables

Lopes — Thu, 27 Feb 2014 20:00:46 GMT

How can I join to datasets and keep all the variables in dataset1 and from dataset2 only the ones that are not in dataset1.

This tables change all the time so if I do the query and join tables, the next time I do it the ones that where in dataset1 are no longer there and I need to get them from dataset2.

Thanks.

Re: Join tables

ballardw — Thu, 27 Feb 2014 22:53:10 GMT

Can you share some of the generated code?

It may be as simple as the order of listing your data sets in the join but some example code and input / output would clarify your issue and want.

Re: Join tables

Reeza — Thu, 27 Feb 2014 22:59:20 GMT

Do you join on all the fields that are match between the two files, or is there a chance that the same fields could differ between tables?

If they're all the same, then try doing a Natural Join, though you may have to code that, instead of using the Query Tool. I'm not sure.

Re: Join tables

TomKari — Thu, 27 Feb 2014 23:07:23 GMT

Does it have to be done using EG tasks, or can you use SAS code?

Tom

Re: Join tables

Lopes — Fri, 28 Feb 2014 12:10:04 GMT

I can use SAS code.

I need to join to tables, the columns in table 1 changes all the time and I need to get always all the columns from table 1 and the ones from table to that are not in table 1.

PROC SQL;

CREATE TABLE WORK.xxx(label="QUERY_FOR_CONTABILIDAD") AS

SELECT t1.xxx1,

t1.xxx2,

t1.xxx3,

t2.xxx11,

t2.xxx4

FROM WORK.QUERY_FOR_CONTABILIDAD_0001 t1

INNER JOIN WORK.COPIA_DE_LISTADO_DE_CUENTAS_CONT t2 ON (t1.Cuenta_contable = t2.CUENTA);

QUIT;

The idea es

I hope this more clear.

Thanks!