Hi, Here is my try...Hope it meets the requirement... /*In Two Step*/ proc sql; create table reg_data(drop = temp) as select a.*,year(a.data) as temp,count(calculated temp) as tot_days from pop as a,pop as b where a.data= b.data group by a.year having tot_days GE 200 order by a.data; quit; proc sql; create table reg_data as select a.* from reg_data as a right join sample as b on a.firmid = b.firmid; quit; /*In one step*/ proc sql; create table reg_data(drop = temp) as select c.*,year(a.data) as temp,count(calculated temp) as tot_days from pop as a left join pop as b on a.data = b.data right join sample as c on a.firmid = c.firmid group by a.year having tot_days GE 200 order by a.data; quit; -Urvish
... View more