DATA Step, Macro, Functions and more

combine SAS DATA SETS

Reply
Contributor
Posts: 29

combine SAS DATA SETS

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. 

Super User
Posts: 10,483

Re: combine SAS DATA SETS

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;

Super User
Posts: 9,674

Re: combine SAS DATA SETS


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;

Ask a Question
Discussion stats
  • 2 replies
  • 223 views
  • 1 like
  • 3 in conversation