Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: Database design for analysis


From   "Sergiy Radyakin" <serjradyakin@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: Database design for analysis
Date   Tue, 12 Feb 2008 10:39:50 -0500

Yes. And if you have multiple examinations within one visit - have
them in a yet another file, examinations, and have patientid and
visitdate as ids there.
you can always merge the files to obtain one wide file, but relational
storage is most space efficient.

Best,
   Sergiy

On 2/12/08, Ziad El-Khatib <Ziad.El-Khatib@ki.se> wrote:
> > I would suggest having two files: patients and visits, and have
> > patientid in each of them.
> >
> > Best regards, Sergiy
>
> Thank you! do you mean in the visits file to have new record for every
> visit then?
> Thank you in advance and best regards
> ziad
>
> On Feb 12, 2008 7:28 AM, Sergiy Radyakin <serjradyakin@gmail.com> wrote:
> > On 2/12/08, Ziad El-Khatib <Ziad.El-Khatib@ki.se> wrote:
> > > Dear STATA-lister,
> > > I am preparing database in EpiData then to move it into STATA. I will
> > > be reviewing patients' records over different visits time.
> > > Would it better to design it as relational database if later on I can
> > > rearrange observations* in rows using STATA.
> > > or
> > > better to enter every observation* as new records?
> >
> > I would suggest having two files: patients and visits, and have
> > patientid in each of them.
> >
> > Best regards, Sergiy
> >
> >
> >
> > >
> > >
> > >
> > > *New observation = new visit for the same patient
> > >
> > >
> > >
> > > Thank you in advance and best regards
> > > ziad
> > > *
> > > *   For searches and help try:
> > > *   http://www.stata.com/support/faqs/res/findit.html
> > > *   http://www.stata.com/support/statalist/faq
> > > *   http://www.ats.ucla.edu/stat/stata/
> > >
> > *
> > *   For searches and help try:
> > *   http://www.stata.com/support/faqs/res/findit.html
> > *   http://www.stata.com/support/statalist/faq
> > *   http://www.ats.ucla.edu/stat/stata/
> >
>
>
>
> --
> Ziad El-Khatib
> AIDS Unit
> National Institute for Communicable Diseases (NICD)
> 1 Modderfontein Road
> Private Bag X4, Sandringham, 2131
> Johannesburg, South Africa
> Mobile: +27 (0) 72-52 39 716
> Phone: +27 (0) 11-386 6433
> Fax (NICD): +27 (0)11 386 6453
> Fax (alternative): +27 (0)866 18 2871
> http://www.nicd.ac.za/
>
> Division of International Health (IHCAR)
> Karolinska Institutet
> www.phs.ki.se/ihcar
> *
> *   For searches and help try:
> *   http://www.stata.com/support/faqs/res/findit.html
> *   http://www.stata.com/support/statalist/faq
> *   http://www.ats.ucla.edu/stat/stata/
>
*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index