combine SAS DATA SETS

[cons]

Hi everybody, 

I try to combine two data sets. 

Data Set A  and DATA SET B with the variables state and object_id. 

For example 

Set A 

state object_id

1 a

1 b

2 a 

SET B

state object_od

1 a 

1 b 

2 a 

2 b 

3 a

I want the new Data Set like 

SET 

state object_id

1 a

1 a

1 b

1 b 

2 a

2 a 

2 b

Which statement would I need to get the new data set 

Regards, 

Cons. 

[ballardw]

The easiest is set:

data want;

   set dataseta datasetb;

run;

(assuming object_od in set b was supposed to be object_id)

will combine then

proc sort data=want;

   by id object_id;

run;

[Ksharp]

data A ;
input state object_id $;
cards;
1 a
1 b
2 a 
;
run;
data B;
input state object_id $;
cards;
1 a 
1 b 
2 a 
2 b 
3 a
;
run;

data want;
 set a(in=ina) b;
 by state;
 retain in_a;
 if first.state then in_a=ina;
 if in_a;
 drop in_a;
run;