Statalist


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

Re: st: Database design for analysis


From   "Ziad El-Khatib" <Ziad.El-Khatib@ki.se>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: Database design for analysis
Date   Tue, 12 Feb 2008 07:33:06 -0800

> 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/



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