/* try this */

data test;         /* create a sample dataset */
   do PatientID = 1001 to 1200;
          value = int(ranuni(12345) *10);
    v1 = (uniform(12345) >=0.1);
    v2 = (uniform(12345) >=0.15);
    v3 = (uniform(12345) >=0.5);
    v4 = (uniform(12345) >=0.8);
    v5 = (uniform(12345) >=0.9);
    output;     end;
   drop i;
run;

data test_1;   
   length TypeID $7.;
   array v v1-v5;
      set test;
    TypeID = put(v1,1.)||put(v2,1.)||put(v3,1.)||put(v4,1.)||put(v5,1.);
      do i = 1 to dim(v);
       mix = sum(of v1-v5); end;
      drop i;
run;   

proc sql;     /* geting the results */
    create table comb_result (drop=TypeID) as
    select distinct typeID, count(*) as N_patient, v1, v2, v3, v4, v5, mix
    from test_1
    where mix>1
    group by TypeID
    order by Mix, v1 desc, v2 desc, v3 desc , v4 desc , v5 desc;
quit;

proc print data=comb_result; title 'comb_result'; run;