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 (June 2007, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Fri, 15 Jun 2007 04:40:03 -0400
Reply-To:   Annie Lee <hummingbird10111@HOTMAIL.COM>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   Annie Lee <hummingbird10111@HOTMAIL.COM>
Subject:   picking the most performed procedure

Hi,

I have a data set with doctor's id (multiple records for each doctor) and procedure_codes. I would like to pick the most performed procedure (one code) for each doctor. I would appreciate any help. Thank you. -Annie

Results I would like to have:

docid procedurecode

001111 21740 001112 50240 001113 48140 001114 53500 001115 21045

data set:

docid procedurecode

001111 21740 001111 21740 001111 21740 001111 21740 001111 21740 001111 20680 001111 20680 001112 50240 001112 50240 001112 50240 001112 52601 001112 52601 001112 55845 001113 48140 001113 48140 001113 48140 001113 48140 001113 48140 001113 48150 001113 48150 001113 47130 001113 47135 001114 53500 001114 53500 001114 53500 001114 53450 001114 53450 001115 21045 001115 21045 001115 21045 001115 21040 001115 21040

Back to: Top of message | Previous page | Main SAS-L page
listserv.uga.edu
Enterprise Information Technology Services
The University of Georgia
listhelp@uga.edu