[EpiData-list] How should EpiData Analysis read a CSV (CommaSeparated File)

epidata-list at lists.umanitoba.ca epidata-list at lists.umanitoba.ca
Fri Mar 10 06:57:34 CST 2006


Hello!

I totally agree with you Max on this question. 

Cheers,
Bellinda


-----Original Message-----
From: epidata-list-bounces at lists.umanitoba.ca
[mailto:epidata-list-bounces at lists.umanitoba.ca] On Behalf Of
epidata-list at lists.umanitoba.ca
Sent: Thursday, March 09, 2006 6:35 PM
To: epidata-list at lists.umanitoba.ca
Subject: Re: [EpiData-list] How should EpiData Analysis read a CSV
(CommaSeparated File)

Hello Jens,

I would strongly argue that a missing is a missing and a 0 (zero) is  
a very distinct value - hence never turn missings into zero by  
default...
or in short: Option 2
Bests
    Max

On 10 Mar 2006, at 10:21, epidata-list at lists.umanitoba.ca wrote:

> A question has come up.
>
> Please consider how you find reading of a CSV file in analysis  
> appropriate:
>
>
> In a csv file the following data is found:
> id, s, pos, sex, ill
> 1,.,.,f,0
> 2...... etc (rest of records)
>
> The data in line can be interpreted in two ways:
> Option 1:
> ID= 1
> s= 0.0
> pos=0.0
> SEX = "f" ill = 0
>
> Option 2:
> ID= 1
> s= .
> pos=.
> SEX = "f" ill = 0
>
> In other words the question is how to read ",.," should it be:
> Option 1: as 0.0                  (which is current behaviour)
> or Option 2: .
>
> Any comments on desired behaviour appreciated.
>
> regards
>
> Jens Lauritsen
> EpiData Association
> _______________________________________________
> EpiData-list mailing list
> EpiData-list at lists.umanitoba.ca
> http://lists.umanitoba.ca/mailman/listinfo/epidata-list

_______________________________________________
EpiData-list mailing list
EpiData-list at lists.umanitoba.ca
http://lists.umanitoba.ca/mailman/listinfo/epidata-list


More information about the EpiData-list mailing list