Hi @ybz12003 .. it will be something like below , data test; infile datalines dsd; input Group RR; obs=_n_; datalines; 372, 9.78, 840, 10.2, 320, 10.87, 341, 11.02, 341, 11.02 370, 11.18, 320, 11.61, 322, 11.63, 340, 11.85, 346, 11.97, 343, 12.47, 371, 13.51, 620, 13.89, 830, 16.98, 350, 26.8, 145, 29.9, 830, 32.53, 510, 36.05, 180, 40.64, 181, 46.82, ; run; proc sort data= test out=test1; by descending obs; run; data test2; set test1; oops1=_n_; run; proc sql; create table first_20 as select group,RR from test having obs/ Max(obs) <=0.2; create table last_10 as select group,RR from test2 having oops1/ Max(oops1) <=0.1; quit;
... View more