topic Re: Merge two different period sample in SAS Programming

Merge two different period sample

hkim3677 — Tue, 27 Mar 2018 18:56:47 GMT

Hi,

I need to merge two different period samples.

For example,

The first data set is like..

Data example1;

input id year c1 c2;

datalines;

1 1990 1 0

1 1991 1 1

1 1992 0 1

1 1993 0 0

2 1992 0 1

2 1993 0 0

;

run;

Data example2;

input id year c1 c2;

datalines;

1 1994 0 1

1 1995 0 1

2 1994 0 0

2 1995 0 0

3 1995 0 1

3 1996 1 0

;

run;

After merging two data sets, I need to have the following dataset.. like..

Data want;

input id year c1 c2;

datalines;

1 1990 1 0

1 1991 1 1

1 1992 0 1

1 1993 0 0

1 1994 0 1

2 1992 0 1

2 1993 0 0

2 1994 0 1

2 1995 0 0

3 1995 0 1

3 1996 1 0

;

run;

How can I merge two different period samples?

Re: Merge two different period sample

Reeza — Tue, 27 Mar 2018 19:01:23 GMT

This isn't a merge exactly, it's an append or union.

You can use PROC APPEND or a SET statement in a data step.

data combined;

set example1 example2;

run;

You can then use PROC SORT to get the desired order.

Re: Merge two different period sample

ChrisNZ — Tue, 27 Mar 2018 22:40:47 GMT

Or use a BY statements to avoid re-sorting if the tables are already sorted.

data combined;
  set example1 example2;
  by id year;
run;