R help - Dec 2011 - Mlogit missing value problem

Hi

After good advices i post this problem here again. Now the attached sambledata
is in csv form and it is a part of my real data. I have tried different
na.action operations but the result stays the same...

My code
> library(mlogit)
> library(foreign)
> z<-odbcConnectExcel("D:\\SAMBLEDATA.csv")
> y<-sqlFetch(z,"Taul1")
>
x=mlogit.data(y,choice="voittaja",shape="long",id.var="id",alt.var="numero")
> summary(mlogit(voittaja ~ Fa+Ie -1 , data=x, na.action=na.pass))
Error in if (abs(x - oldx) < ftol) { :
missing value where TRUE/FALSE needed

The reason for this error is in the row 563. There the choice has value 1 
and Ie has missing value. 
If the choice has value 0 and Ie has missing values, then there is no errors.

What should i do to make it work..?

Ville

Hi,

19.12.2011 11:12, Ville Iiskola wrote:
>
> Error in if (abs(x - oldx)<  ftol) { : missing value where TRUE/FALSE
> needed
>
> The reason for this error is in the row 563. There the choice has
> value 1 and Ie has missing value. If the choice has value 0 and Ie
> has missing values, then there is no errors.
>
> What should i do to make it work..?
How about excluding all rows having the combination "choice=1" and 
"Ie=NA" by using the function 'subset'? Or would this
destroy/skew your
data?

HTH,
Kimmo