topic Re: combine SAS DATA SETS in SAS Programming

combine SAS DATA SETS

cons — Fri, 02 Sep 2016 18:30:14 GMT

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 b

2 a

2 b

Which statement would I need to get the new data set

Regards,

Cons.

Re: combine SAS DATA SETS

ballardw — Fri, 02 Sep 2016 18:53:14 GMT

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;

Re: combine SAS DATA SETS

Ksharp — Sat, 03 Sep 2016 02:46:38 GMT


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;