08-30-2017 01:21 PM - edited 08-30-2017 01:30 PM
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;
data final1(keep=tot _NAME_); set final;
08-30-2017 07:23 PM
Can you give us a sample of your data in the form of "have" and "want" data sets please? If it's difficult to advise you without knowing what your data looks like.