Help using Base SAS procedures

RANKS

Accepted Solution Solved
Reply
Super Contributor
Posts: 1,041
Accepted Solution

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
Respected Advisor
Posts: 4,925

Re: RANKS

Posted in reply to robertrao

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

View solution in original post


All Replies
Solution
‎01-22-2013 12:49 PM
Respected Advisor
Posts: 4,925

Re: RANKS

Posted in reply to robertrao

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.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 196 views
  • 0 likes
  • 2 in conversation