LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (May 2004, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Thu, 13 May 2004 10:32:18 -0700
Reply-To:     shiling zhang <shiling99@YAHOO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         shiling zhang <shiling99@YAHOO.COM>
Organization: http://groups.google.com
Subject:      Re: selecting top twovalues
Content-Type: text/plain; charset=ISO-8859-1

data t1; input Hospital $10. Patient1 Patient2 Patient3; cards; Hospital1 20 5 10 Hospital2 2 1 50 Hospital3 23 40 1 ;

data t2; length Patient_name_2nd Patient_name_1st $10; array p(3) Patient1 Patient2 Patient3; set t1; h1st=0; h2nd=0; do i = 1 to dim(p); if p(i) > h1st then do; h2nd=h1st; Patient_name_2nd=Patient_name_1st; h1st=p(i); Patient_name_1st=vname(p(i)); end; else if p(i) > h2nd then do; h2nd=p(i); Patient_name_2nd=vname(p(i)); end; end; run;

proc print data=t2; var Hospital Patient_name_1st h1st Patient_name_2nd h2nd; run;

*****************listing********************; Patient_ Patient_ Obs Hospital name_1st h1st name_2nd h2nd

1 Hospital1 Patient1 20 Patient3 10 2 Hospital2 Patient3 50 Patient1 2 3 Hospital3 Patient2 40 Patient1 23

Hope this helps

carter_51@HOTMAIL.COM (John Carter) wrote in message news:<200405130128.i4D1SjG00848@listserv.cc.uga.edu>... > Hi all, > Was wondering if someone could help me out on this: > > I have the following data (just an example): > > > Patient1 Patient2 Patient3 > Hospital1 20 5 10 > Hospital2 2 1 50 > Hospital3 23 40 1 > > Basically what I'm trying to do is to have a DATASET that has the highest > two Patients from each hospital: example. Looking for a dataset, not a > report output. > > Dataset: > > Hospital High Highnumvalue SecondHigh Secondhighvalue > > Hospital1 Patient1 20 Patient3 10 > Hospital2 Patient3 50 Patient1 2 > Hospital3 Patient2 40 Patient1 23 > > Any help would be great.


Back to: Top of message | Previous page | Main SAS-L page