Dear Aiso,
I haven't familiarised myself with the latest version of EpiData Manager yet, but may have a solution to your problem using EpiData Entry (see attached database). In the CHK file you'll see that I hide and unhide the v17 and v18 fields depending on the value entered into the v16 fields. By hiding a field you are effectively skipping it during the entry process and the order in which the fields appear is irrelevant - provided hidden fields are after the "controlling" field. In my example I've used -1 as the code for missing. When I set up databases I use a value (such as -1) that is not a legitimate value for any of my fields. In Stata I then convert -1 to a Stata missing value.
v16a AFTER ENTRY IF v16a=0 THEN LET v17a=-1 LET v18a=-1 HIDE v17a HIDE v18a ENDIF IF v16a<>0 THEN LET v17a=. LET v18a=. UNHIDE v17a UNHIDE v18a ENDIF END END
Cheers,
Suzanna Vidmar Senior Research Officer Clinical Epidemiology and Biostatistics Unit
Murdoch Childrens Research Institute Royal Children's Hospital Flemington Road Parkville Victoria 3052 Australia
telephone: +61 3 9345 6372 facsimile: +61 3 9345 6000 email: suzanna.vidmar@mcri.edu.au www.mcri.edu.au
-----Original Message----- From: epidata-list-bounces@lists.umanitoba.ca [mailto:epidata-list-bounces@lists.umanitoba.ca] On Behalf Of epidata-list@lists.umanitoba.ca Sent: Wednesday, 30 May 2012 12:55 PM To: epidata-list@lists.umanitoba.ca Subject: RE: [EpiData-list] Skip and fill
Dear Jens,
Thank you for your reply. I asked this question since in days long gone (late eighties), this option was possible in SPSS/Data Entry for DOS.
Of course it depends on the design philosophy of a questionnaire. Mine is that the questionnaire is central and that the data entry should follow the questionnaire. Your philosophy is that the data entry is the crucial aspect and that the design of the questionnaire should follow the data entry form.
But perhaps you can think of introducing these options in future versions.
Regards,
Aiso
-----Oorspronkelijk bericht----- Van: epidata-list@lists.umanitoba.ca [mailto:epidata-list@lists.umanitoba.ca] Verzonden: dinsdag 29 mei 2012 20:16 Aan: epidata-list@lists.umanitoba.ca Onderwerp: Re: [EpiData-list] Skip and fill
Aisa asked on skip and fill. With the current version you can do what you like by changing the sequence to:
V16a Number of cattle
(then set jumping to v17 if v16a is = 0) v16b Number of productive female cattle
v17a Number of goats
V17b Number of productive female goats
..... etc.
Regards Jens Lauritsen
On 05/28/2012 05:05 AM, epidata-list@lists.umanitoba.ca wrote:
Will there be some advanced skip and fill routines in future versions of epidatamanager.
V16a Number of cattle
V16b Number of goats
V16c Number of sheep
Etc.
V17a Number of productive female cattle
V17b Number of productive female goats
V17c Number of productive female sheep
Etc.
V18a Value of cattle
V18b Value of goats
V18c Value of sheep
Suppose V16a equals "0" or is "SYSMIS" V17a and V18a should be system missing.
I could not find it in the current version.
Regards,
Aiso
EpiData-list mailing list EpiData-list@lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list
_______________________________________________ EpiData-list mailing list EpiData-list@lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list
______________________________________________________________________ This email has been scanned by the Symantec Email Security.cloud service. For more information please visit http://www.symanteccloud.com
If you have any question, please contact MCRI IT Helpdesk for further assistance. ______________________________________________________________________
______________________________________________________________________ This email has been scanned by the Symantec Email Security.cloud service. For more information please visit http://www.symanteccloud.com ______________________________________________________________________