Re: EpiData-list Digest, Vol 90, Issue 2
My English is bad and I apologize for that.
My research instrument contains 21 questions to be answered for 12 disciplines in a course. The number of respondents is approximately 100 people.
Each question will be answered for all disciplines. I am attaching an example with three questions (one question for each file.)
When finished entering the data of 12 disciplines in question 3, I want go to the file Quest which is the first issue, data entry of a new student.
Note that I used the RELATE command in questions 1 and 2.
FQ2 AFTER ENTRY IF fq2=1 THEN RELATE QUEST q3 ENDIF END END
-------------------------------------- Silvano Cesar da Costa Departamento de Estatística Universidade Estadual de Londrina Fone: 3371-4346 -------------------------------------- ----- Original Message ----- From: epidata-list-request@lists.umanitoba.ca To: epidata-list@lists.umanitoba.ca Sent: Thursday, April 21, 2011 2:00 PM Subject: EpiData-list Digest, Vol 90, Issue 2
Send EpiData-list mailing list submissions to epidata-list@lists.umanitoba.ca
To subscribe or unsubscribe via the World Wide Web, visit http://lists.umanitoba.ca/mailman/listinfo/epidata-list or, via email, send a message with subject or body 'help' to epidata-list-request@lists.umanitoba.ca
You can reach the person managing the list at epidata-list-owner@lists.umanitoba.ca
When replying, please edit your Subject line so it is more specific than "Re: Contents of EpiData-list digest..."
EpiData-list mailing list ___________________________________
Today's Topics:
- Re: Multiple files (epidata-list@lists.umanitoba.ca)
- Re: Multiple files (epidata-list@lists.umanitoba.ca)
- Re: Multiple files (epidata-list@lists.umanitoba.ca)
Message: 1 Date: Wed, 20 Apr 2011 20:11:32 +0200 From: epidata-list@lists.umanitoba.ca Subject: Re: [EpiData-list] Multiple files To: epidata-list@lists.umanitoba.ca Message-ID: 4DAF21D4.9080203@epidata.dk Content-Type: text/plain; charset=ISO-8859-1; format=flowed
You should look at the command "relate" in the help file.
To see a specific implementation I suggest you download these three and look at the check files: *1 Relate example - Clinical Study with four forms **2 Relate example - Multilevel, Village, Family, Person - Nutritional survey of region in Burkina Faso **3 Relate example - hospital infections - 3 examples*
You find it all at http://www.epidata.dk/examples.php
Let us know how it works at the end - your example could be added to the examples page. (without proper data obviously)
regards Jens Lauritsen EpiData Association
On 2011-04-20 16:26, epidata-list@lists.umanitoba.ca wrote:
Hi,
I have a main file (Quest) and 21 related files.
At the end of the input data file 21 that want to go back to the file Quest for new entry. How?
I tried:
FQ21 AFTER ENTRY IF FQ21=1 THEN GOTO WRITE ENDIF END END
and
FQ21 AFTER ENTRY IF FQ21=1 THEN GOTO QUEST ENDIF END END
Silvano Cesar da Costa Departamento de Estatística Universidade Estadual de Londrina Fone: 3371-4346
EpiData-list mailing list EpiData-list@lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list
Message: 2 Date: Wed, 20 Apr 2011 19:52:08 +0200 From: epidata-list@lists.umanitoba.ca Subject: Re: [EpiData-list] Multiple files To: epidata-list@lists.umanitoba.ca Message-ID: 4DAF1D48.7010801@tbrieder.org Content-Type: text/plain; charset=ISO-8859-1; format=flowed
You probably mean "records" rather than files?
If so, it is simple, no commands are needed in the CHK file of the related file, just press F10 to return to the parent file, whenever you have entered the last of the child records belonging to one given parent.
Hans
On 20:59, epidata-list@lists.umanitoba.ca wrote:
Hi,
I have a main file (Quest) and 21 related files.
At the end of the input data file 21 that want to go back to the file Quest for new entry. How?
I tried:
FQ21 AFTER ENTRY IF FQ21=THEN GOTO WRITE ENDIF END END
and
FQ21 AFTER ENTRY IF FQ21=THEN GOTO QUEST ENDIF END END
Silvano Cesar da Costa Departamento de Estatística Universidade Estadual de Londrina Fone: 3371-4346
-- Hans L Rieder, MD, MPH Jetzikofenstr 12 3038 Kirchlindach Switzerland
Tel: +41 31 829 4577 Mob: +41 79 321 9122 Web: http://www.tbrieder.org
Message: 3 Date: Thu, 21 Apr 2011 07:54:51 +0100 From: epidata-list@lists.umanitoba.ca Subject: [EpiData-list] Re: Multiple files To: epidata-list@lists.umanitoba.ca Message-ID: BANLkTimQxHVydfC2buhj=We2vtM4MiXSjw@mail.gmail.com Content-Type: text/plain; charset=ISO-8859-1
Dear Silvano Cesar da Costa, One reliable way to approach this is to close the files in reverse order until the edit pencil is pointed to the start(in your case may be file 1). *As general rule*: To enter data in relational database you must either move down the tree through the field that contains the Relate command, or move up the tree by closing the rec.files. On closing file21.rec the cursor should go back to file20.rec so on. Pressing F10 or CTRL+R ( return key) closes the file and moves the cursor/edit pencil back one level to the data files that called RELATE.
Hope this would help.
Tieble
On 20 April 2011 18:13, epidata-list-request@lists.umanitoba.ca wrote:
Send EpiData-list mailing list submissions to epidata-list@lists.umanitoba.ca
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.umanitoba.ca/mailman/listinfo/epidata-list or, via email, send a message with subject or body 'help' to epidata-list-request@lists.umanitoba.ca
You can reach the person managing the list at epidata-list-owner@lists.umanitoba.ca
When replying, please edit your Subject line so it is more specific than "Re: Contents of EpiData-list digest..."
EpiData-list mailing list ___________________________________
Today's Topics:
- Multiple files (epidata-list@lists.umanitoba.ca)
Message: 1 Date: Wed, 20 Apr 2011 11:26:20 -0300 From: epidata-list@lists.umanitoba.ca Subject: [EpiData-list] Multiple files To: epidata-list@lists.umanitoba.ca Message-ID: 77996779913E437DA44EEBB3B0E9F6FA@ccePC Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response
Hi,
I have a main file (Quest) and 21 related files.
At the end of the input data file 21 that want to go back to the file Quest for new entry. How?
I tried:
FQ21 AFTER ENTRY IF FQ21=1 THEN GOTO WRITE ENDIF END END
and
FQ21 AFTER ENTRY IF FQ21=1 THEN GOTO QUEST ENDIF END END
Silvano Cesar da Costa Departamento de Estatística Universidade Estadual de Londrina Fone: 3371-4346
EpiData-list@lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list
End of EpiData-list Digest, Vol 90, Issue 1
--
http://www.vet2011.org/calendrier3.phphttp://vet2011.org Vet for health, Vet for food, Vet for the planet !
EpiData-list@lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list
End of EpiData-list Digest, Vol 90, Issue 2
The file structure seems to be more complicated than is necessary. If all of the files Q1, Q2, ... are exactly the same structure, just add another field to indicate the discipline and enter all of the discipline questions (12 x 21) in a single file (I'll call this DISCQ).
In QUEST, you have the relate the way you do now.
You can actually program the chk file for DISCQ to change the discipline and question numbers automatically if you want, provided that the data are always in exactly the same order. Or you can use REPEATS to repeat the discipline number until all of the questions for that discipline are answered.
When you have finished entering all of the 12x21 questions, just hit <F10> to go back to the QUEST file. The way your files are structured now, I think you have to hit <F10> 12 times to go back from Q12.rec to QUEST.rec.
Jamie
On 2011-04-25, Silvano wrote:
My research instrument contains 21 questions to be answered for 12 disciplines in a course. The number of respondents is approximately 100 people.
Each question will be answered for all disciplines. I am attaching an example with three questions (one question for each file.)
participants (1)
-
epidata-list＠lists.umanitoba.ca