Desktop productivity for business analysts and programmers

Join tables

Reply
Contributor
Posts: 30

Join tables

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.

Super User
Posts: 11,134

Re: Join tables

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.

Super User
Posts: 19,171

Re: Join tables

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.

PROC Star
Posts: 1,146

Re: Join tables

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

Tom

Contributor
Posts: 30

Re: Join tables

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!

Ask a Question
Discussion stats
  • 4 replies
  • 286 views
  • 0 likes
  • 4 in conversation