> 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 <[email protected]> wrote:
> On 2/12/08, Ziad El-Khatib <[email protected]> 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/
