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 <[email protected]> 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 <[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/
>
*
* 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/
