Hello everyone

Just to share my experience with you. As you know I had a problem reading my rec file in epidata analysis.We finally solved the problem after my colleague went through all the records (1065) in excel sheet. We found that one numeric field was initially entered in a wrong way, something that epidata entry accepted it when we imported the data from excel into epidata.

Thanks all for your suggestions, help and time Mohammed

On Mon, May 28, 2012 at 7:00 PM, epidata-list-request@lists.umanitoba.cawrote:

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. Re: Re: EpiData-list Digest, Vol 103, Issue 7 (epidata-list@lists.umanitoba.ca)
2. Re: data export problem still exists in EpiData Manager 1.1.1? (epidata-list@lists.umanitoba.ca)
3. Skip and fill (epidata-list@lists.umanitoba.ca)

---

Message: 1 Date: Sun, 27 May 2012 13:02:55 -0400 From: epidata-list@lists.umanitoba.ca Subject: Re: [EpiData-list] Re: EpiData-list Digest, Vol 103, Issue 7 To: epidata-list@lists.umanitoba.ca Message-ID: BLU0-SMTP76ED7500E68885741E88D6FD070@phx.gbl Content-Type: text/plain; charset="us-ascii"

Do you have text fields in the data - especially fields that may contain special characters?

You can import a lot of data from excel - for example, I just loaded a test data set with 4401 records:

Loading data from clipboard, please wait... First line: (clipboard) id n m q r w t u c d e f g h i j k l m Separator: Tab (tab: 79236)(semicolon: 0)(comma: 0)(space: 0) Lines: 4402 (incl. field names) File name :from clipboard Fields: 19 Total records: 4401 Included: 4401

I you can import 50 lines, then I suspect there is a problem with one of the records that follows.

if you want me to try to diagnose the problem, you can send your .rec and .chk files to me

charlesknightsbridge (at) gmail.com

I'll have a look and then delete everything, including the e-mail.

Jamie

On 2012-05-27, Mohammed wrote:

...

I also exported the file, 1065 records, into excel and when I tried to

copy

...

and import it into epidata analysis immediately, the software shut down immediately. It only works with 50 records.

Thanks

---

Message: 2 Date: Sun, 27 May 2012 13:16:27 -0400 From: epidata-list@lists.umanitoba.ca Subject: Re: [EpiData-list] data export problem still exists in EpiData Manager 1.1.1? To: epidata-list@lists.umanitoba.ca Message-ID: BLU0-SMTP851C14F03D177087DF4691FD070@phx.gbl Content-Type: text/plain; charset="us-ascii"

Does Stata support UTF-8 with chinese characters? I see on their support site a lot of questions about this, but no answers. Stata V12 infile statement has no support for extended character sets:

3. ASCII or EBCDIC data can be read.

(from http://www.stata.com/help.cgi?infiling)

Jamie

On 2012-05-26, at 8:23 PM, epidata-list@lists.umanitoba.ca wrote:

...

in EpiData Manager 1.1.1 I still can't normally export .epx to Stata

.dta file

---

Message: 3 Date: Mon, 28 May 2012 07:35:54 +0430 From: epidata-list@lists.umanitoba.ca Subject: [EpiData-list] Skip and fill To: epidata-list@lists.umanitoba.ca Message-ID: 001801cd3c7e$cfa69880$6ef3c980$@gmail.com Content-Type: text/plain; charset="us-ascii"

Will there be some advanced skip and fill routines in future versions of epidatamanager.

For instance I work currently on a household survey where I ask about livestock.

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@lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list

End of EpiData-list Digest, Vol 103, Issue 10

---