RANKS

[robertrao]

Hi,

I have 11 Questions for Timely and effective care from Different hospitals

Question   HOSPITAL     N          Percent    Estimated_Outcome( which is N*Percent)     

1                AAA             720           0.96         691

2                AAA

3                AAA

4                AAA

5               AAA

6               AAA

7              AAA

8              AAA

9             AAA

10           AAA

11          AAA               414        0.98       405.72   

1            BBB               389        0.97        377.33   

2            BBB

3            BBB

4            BBB

5            BBB

6            BBB

7            BBB

8             BBB

9             BBB

10           BBB

11           BBB                107        0.93       99.51

[PGStats · Accepted solution]

Something like this ?

proc transpose data=have out=haveT prefix=Q_;

by hospital category;

var percent;

id question;

run;

proc rank

     data=haveT(where=(category in ("OURS", "REGIONAL")))

     out=wantRegional(where=(category="OURS"))

     percent;

var Q_1-Q_11;

ranks R_1-R_11;

run;

proc rank

      data=haveT(where=(category in ("OURS", "NATIONAL")))

      out=wantNational(where=(category="OURS"))

      percent;

var Q_1-Q_11;

ranks R_1-R_11;

run;

PG