As a new user, I have a problem. Then I discribe it in brief. data t1;
input id $;
cards;
A20152017
B20162018
C20152018
;
run;
data t2;
input year A B C;
cards; 2014 1 1 1
2015 2 1 3
2016 1 1 2
2017 3 2 3
2018 1 2 1 2019 2 3 3
;
run; I have 2 tables, t1 and t2. In t1, the first charactor(A, B and C) of id is name, the second to the fifth and the sixth to the ninth mean starting year and ending year respectively. In t2, there are points in these years for A, B and C. I want to get the average points during the years shown in t1 and merge them with set1. Thank you for your help!
... View more