Hi,
Given to dataset like below. I am trying to find a way to create a third dataset that is equal to dataset 2 but has
all the values of dataset 1 in injury when id_company is the same.
I would much appreciate any help.
/* Data set 1 */
data t2005;
input id_company injury;
datalines;
123 0
245 1
322 0
355 1
4 1
5 0
666 0
7 0
;
run;
/*Data set 2 */
data t2006;
input id_company injury;
datalines;
123 1
245 1
322 0
343 0
4 1
5 1
677 0
7 0
;
run;