topic Re: merge tables in SAS Procedures

merge tables

sasphd — Tue, 11 Jun 2019 18:47:40 GMT

I have

data A;

input id caldt ret;

datalines;

1 01-2019 9

1 02-2019 10

2 03-2018 2

2 04-2018 4;

data B;

input id caldt tna;

dataline;

1 01-2020 12

1 02-2021 11

2 03-2019 3

2 04-2019 2;

want

id tna ret

1 12 9

1 11 10

2 3 2

2 2 4

Re: merge tables

Reeza — Tue, 11 Jun 2019 19:24:55 GMT

What have you tried? SQL or Data step?

If you're not familiar with merges at all, the documentation has a full set of examples here (with code and data examples):

https://documentation.sas.com/?docsetId=lrcon&docsetTarget=n1tgk0uanvisvon1r26lc036k0w7.htm&docsetVersion=9.4&locale=en

You want to look at one to one merging or match merging section.

@sasphd wrote:

I have

data A;

input id caldt ret;

datalines;

1 01-2019 9

1 02-2019 10

2 03-2018 2

2 04-2018 4;

data B;

input id caldt tna;

dataline;

1 01-2020 12

1 02-2021 11

2 03-2019 3

2 04-2019 2;

want

id tna ret

1 12 9

1 11 10

2 3 2

2 2 4

Re: merge tables

sasphd — Tue, 11 Jun 2019 19:47:36 GMT

sql

Re: merge tables

Reeza — Tue, 11 Jun 2019 19:50:04 GMT

Can you post the code you tried?

Re: merge tables

Astounding — Tue, 11 Jun 2019 21:00:30 GMT

Here's the simplest program that might work:

data want;
   set A;
   set B;
   keep id tna ret;
run;

If you were to actually describe your intentions, a better program might be possible. This program just matches observation by observation: first from A with first from B, second from A with second from B, third from A with third from B, etc. Perhaps that is what you want, but if not you will have to do more of the work.