Hi Two ways are there to execute the task....
1. by proc sql;
proc sql;
create table season as
select d.*,t.year as yeart, t.season as seasont,temp as tempreture from daily d,temp t
where d.year=t.year and d.season=t.season;
quit;
2. in dataset by merge keyword
proc sort data=daily;
by year season;
run;
proc sort data=temp;
by year season;
run;
data final;
merge temp daily(in=ind);
by year season;
if ind=1;
run;
... View more
