Merge two different period sample

Reply
Contributor
Posts: 29

Merge two different period sample

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?

Super User
Posts: 22,525

Re: Merge two different period sample

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.

 

 

 

 

PROC Star
Posts: 2,133

Re: Merge two different period sample

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

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

 

Ask a Question
Discussion stats
  • 2 replies
  • 62 views
  • 2 likes
  • 3 in conversation