I don't use any clinical system at the moment, but I used to use iSOFT Premiere, extracting the patients with an external SQL tool. 2009/5/19 Geoff Schrecker <[log in to unmask]> > Thanks John, > > Which clinical system do you use? I was hoping for something > straightforward in the clinical system, as it is for a research study > involving 40+practices and we need to be able to advise the practice > how to do it. > > Cheers Geoff > > 2009/5/19 John Clegg <[log in to unmask]>: > > I use Excel: > > > > 1) Export a cohort of patients to Excel > > 2) Add a column containing =RAND() > > 3) Sort both columns on the RAND column, ascending or descending > according > > to your (random) preference > > 4) Select the top (or bottom, or any) 10% > > > > 2009/5/19 Geoff Schrecker <[log in to unmask]> > >> > >> I have been asked how easy it is to get a random sample of 10% of a > >> given population of patients. In EMIS PCS which we use this is > >> straightforward, could users of other systems (especially SystmOne) > >> let me know how easy it is in your system? > >> > >> Thanks Geoff > >> > >> -- > >> Please avoid sending me Word or PowerPoint attachments unless by prior > >> arrangement. > >> See http://www.gnu.org/philosophy/no-word-attachments.html > > > > > > > > > -- > Please avoid sending me Word or PowerPoint attachments unless by prior > arrangement. > See http://www.gnu.org/philosophy/no-word-attachments.html >