I'd like to keep 'age_in_days' in data plot which is obvisouly not distinct. Putting age_in_days after 'having' and before 'distinct' in select statement didn't work out.
My goal is to line graph 'age_in_days' against 'tot'.
proc sql;
create table plot as
select distinct id,a1, a2, a3
from temp1
where (0 <= age_in_days <= 10)
group id, a1, a2, a3
having date = min(date);
quit;
proc transpose data=plot out=final;
run;
data final1(keep=tot _NAME_); set final;
tot=sum(of Col:);
run;