Date:         Fri, 21 May 2004 16:06:42 +0300
Reply-To:     susan bander <susab@CNN.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         susan bander <susab@CNN.COM>
Subject:      reading library use data

an internal library records usage for publications
while each record contains lots of interesting bits, there are 2 variables
of
interest, catalog_title, date_checked_out

each day contains some 10000 to 50000 records

what might be a simple way to locate the top 10 titles repeatedly checked
out during a month?

I can of course use brute force and start from each record in day1 and build
a lookup dataset which then need to scan each remaining day (day2-day31) and
report something like
catalog_title : How-To-Cook-with-SAS, dates checked out: 1, 7, 22, 29
..and then repeat the process for remaining days and each records

doing it this way will of course take a supercomputer and lots of time

what might be some alternate ways of organizing this?