Hello. I need to sort the variables by mif, ddstl, src_ref. But then I need to output from this dataset only the first variable by mif and src_ref. Can you help me? I tried this, but not the result which I want proc sort data=work.QUERY_FOR_ACTIVITY_0008 out=work.skuska;
by mif descending ddstl src_ref;
run;
data work.pokus;
set WORK.skuska;
by mif src_ref;
if first.src_ref then output;
run; Here is table - I want this yellow rows only: src_ref can be more then twice in the table, but only with very similar time- difference 40sec.
... View more
