RE: EpiData-list Digest, Vol 119, Issue 8
Dear All Stuck with exporting issues with epidata manager to SPSS Can anyone give me some advice-many data are merged in the same column in the SPSS file Thanks
Dr Thambu David S Professor and Head Medicine Unit 2 Christian Medical College, Vellore 632004, India
________________________________________ From: epidata-list-bounces@lists.umanitoba.ca [epidata-list-bounces@lists.umanitoba.ca] On Behalf Of epidata-list-request@lists.umanitoba.ca [epidata-list-request@lists.umanitoba.ca] Sent: Thursday, September 12, 2013 10:31 PM To: epidata-list@lists.umanitoba.ca Subject: EpiData-list Digest, Vol 119, Issue 8
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:
1. Select Field for Validation (epidata-list@lists.umanitoba.ca) 2. Automatic Unique Identifier and Double Entry Verification Mode (epidata-list@lists.umanitoba.ca)
----------------------------------------------------------------------
Message: 1 Date: Thu, 12 Sep 2013 10:36:38 +0300 From: epidata-list@lists.umanitoba.ca Subject: [EpiData-list] Select Field for Validation To: epidata-list@lists.umanitoba.ca Message-ID: CAJ=nXPa0C5oQjNGx452y9XqwDt8pDumOXQDAEZSEkNvg976Oyw@mail.gmail.com Content-Type: text/plain; charset=ISO-8859-1
Dear Jammie,
I tried copying a pair but it required re-arraging the check file. I thought there was another way out. Thank you!
Kizito.
------------------------------
Message: 2 Date: Thu, 12 Sep 2013 10:48:29 +0300 From: epidata-list@lists.umanitoba.ca Subject: [EpiData-list] Automatic Unique Identifier and Double Entry Verification Mode To: epidata-list@lists.umanitoba.ca Message-ID: CAJ=nXPa9Z3xudowxWRSG5tTBxkhcrQryZt-w0=6LbPuUGAMAaQ@mail.gmail.com Content-Type: text/plain; charset=ISO-8859-1
Dear Listers,
I wanted to do data validation using the Double Entry Verification mode, but when I used an automatically generated unique identifiers for the records it could not prompt even when there was discordance.
What is the solution?
Kizito
On 10 September 2013 23:25, 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:
- EpiC data export fails on STATA8 option (epidata-list@lists.umanitoba.ca)
- Re: EpiC data export fails on STATA8 option (epidata-list@lists.umanitoba.ca)
Message: 1 Date: Mon, 9 Sep 2013 16:30:06 +0000 From: epidata-list@lists.umanitoba.ca Subject: [EpiData-list] EpiC data export fails on STATA8 option To: "'epidata-list@lists.umanitoba.ca'" epidata-list@lists.umanitoba.ca Message-ID: 3C0AEE4CAF2E224B99497B5018BED09703D91D@mx02.ispm.unibe.ch Content-Type: text/plain; charset="us-ascii"
Dear listers,
I'm trying to convert EpiData files to Stata format. I've stumbled upon a problem similar to the one described by Jan in a post from 2008:
http://lists.umanitoba.ca/pipermail/epidata-list/2008q3/001082.html
(This is the only reference I've been able to find on the list and Google)
My command and output are as follows:
C:\test>EpiC.exe e STATA8 PEDPATIENT28032012ES * REPLACE
EpiC - the EpiData command application version 3.1.2 14. Nov. 2006 (C) Copyright 2002-2006 - EpiData Association, http://www.epidata.dk Programmed by M.Bruus. Design: JM.Lauritsen & M.Bruus
0 % doneException EAccessViolation in module EpiC.exe at 00061B3F. Access violation at address 00461B3F in module 'EpiC.exe'. Write of address 022AC000.
The files are converted correctly when I use "STATA" option, but since it converts to Stata 6 version I don't get the correct variable names whenever they are too long. I've tested it on two machines: one running Windows Server 2008, and one on Linux (using Wine). The files are converted correctly using EpiData 3.1 GUI.
Are there any solutions to this problem?
Thanks a lot for help, radek
Message: 2 Date: Mon, 09 Sep 2013 23:17:36 +0200 From: epidata-list@lists.umanitoba.ca Subject: Re: [EpiData-list] EpiC data export fails on STATA8 option To: epidata-list@lists.umanitoba.ca Message-ID: 522E3AF0.7040303@epidata.dk Content-Type: text/plain; charset=ISO-8859-1; format=flowed
The EpiC command system from 2006 will not be fixed, but we will consider developing a similar command line tool with the new system functionality (epx).
In other words - until this is done you have to do the process repeatedly with the new software, which handles all new versions of Stata (at least until v12)
The template parser could be the first part of such a batch/cmd stand alone tool.'
Regards Jens Lauritsen EpiData Association On 09/09/2013 06:30 PM, epidata-list@lists.umanitoba.ca wrote:
Dear listers,
I'm trying to convert EpiData files to Stata format. I've stumbled upon
a problem similar to the one described by Jan in a post from 2008:
http://lists.umanitoba.ca/pipermail/epidata-list/2008q3/001082.html
(This is the only reference I've been able to find on the list and
Google)
My command and output are as follows:
C:\test>EpiC.exe e STATA8 PEDPATIENT28032012ES * REPLACE
EpiC - the EpiData command application version 3.1.2 14. Nov. 2006 (C) Copyright 2002-2006 - EpiData Association, http://www.epidata.dk Programmed by M.Bruus. Design: JM.Lauritsen & M.Bruus
0 % doneException EAccessViolation in module EpiC.exe at 00061B3F. Access violation at address 00461B3F in module 'EpiC.exe'. Write of
address 022AC000.
The files are converted correctly when I use "STATA" option, but since
it converts to Stata 6 version I don't get the correct variable names whenever they are too long. I've tested it on two machines: one running Windows Server 2008, and one on Linux (using Wine). The files are converted correctly using EpiData 3.1 GUI.
Are there any solutions to this problem?
Thanks a lot for help, radek
EpiData-list mailing list EpiData-list@lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list
EpiData-list@lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list
End of EpiData-list Digest, Vol 119, Issue 7
------------------------------
________________________________________ EpiData-list@lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list
End of EpiData-list Digest, Vol 119, Issue 8 ********************************************
My own test of a large data set (part of CDC's BRFSS data for one year), using the most recent alpha test: EpiData Entry Client Program Version: 1.5.0.10 r292 Core version: 1.5 r767 FPC Version: 2.6.2 Platform: i386-Darwin Filename: /Data/BRFSS/brfss.epx XML Version: 3 Field count: 60 Record count: 2509
Export to SPSS: all fields are exported in the appropriate fashion, except for: 1) the final field in the .txt file is missing the last character/digit. 2) the SPSS record description in the .sps file changes a 10-character string to a 30-character string. Every field from that one forward is incorrect. This field starts in column 92. The record descriptor should be: ... vegedayx 89-91 xpsu 92-101(A) xststr 102-106 ... but is ... vegedayx 89-91 xpsu 92-121(A) xststr 122-126 ...
I haven't explored enough to know how consistent this is.
So you might be able to fix the import just by editing the .sps file to match the field positions to the correct columns in the .txt file
Jamie
On 2013-09-13, at 5:39 AM, epidata-list@lists.umanitoba.ca wrote:
Dear All Stuck with exporting issues with epidata manager to SPSS Can anyone give me some advice-many data are merged in the same column in the SPSS file Thanks
Dr Thambu David S
participants (1)
-
epidata-list@lists.umanitoba.ca