09-02-2016 02:30 PM
I try to combine two data sets.
Data Set A and DATA SET B with the variables state and object_id.
I want the new Data Set like
Which statement would I need to get the new data set
09-02-2016 02:53 PM
The easiest is set:
set dataseta datasetb;
(assuming object_od in set b was supposed to be object_id)
will combine then
proc sort data=want;
by id object_id;
09-02-2016 10:46 PM
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;