## RANKS

Solved
Super Contributor
Posts: 1,041

# RANKS

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

Accepted Solutions
Solution
‎01-22-2013 12:49 PM
Posts: 5,543

## Re: RANKS

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

PG

All Replies
Solution
‎01-22-2013 12:49 PM
Posts: 5,543

## Re: RANKS

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

PG
🔒 This topic is solved and locked.