[Limdep Nlogit List] Reading Data from Office 2007

[Barry Williams]

Dear Robert and all,


Many thanks, this particular solution works. 

HOWEVER, be aware, if your data has a number of missing values in the
first few rows of any variable, the outcome will be for that variable to
be read is as entirely empty.  The solution is to put -999 in the first
cell for any variable with a number of missing observations up front,
instead of leaving the top cell empty, then you will be OK.

Kind Regards,

Barry


-----Original Message-----
From: Robert Iquiapaza [mailto:rbali at ufmg.br] 
Sent: Monday, 29 June 2009 8:49 PM
To: limdep at limdep.itls.usyd.edu.au; Barry Williams
Subject: Re: [Limdep Nlogit List] Reading Data from Office 2007

Here is Jill's suggestion, or use Stat Transfer
http://www.stattransfer.com/


--------------------------------------------------
From: "Jill Caviglia-Harris" <jlcaviglia-harris at salisbury.edu>
Sent: Friday, May 29, 2009 8:32 PM
To: <puneetdwivedi at gmail.com>; <limdep at limdep.itls.usyd.edu.au>
Subject: Re: [Limdep Nlogit List] Please suggest - data reading

> Puneet:
>
> If this problem occurs with the newest version of excel - I have found

> that if you open the excel table in Access and export as a wk1 file
you 
> will not have any trouble reading the file in LimDep.   You can use
the 
> code:
>
> read; file=filename.wk1;
> names=1; format=wk1$
>
> to read in the file.
>
> -Jill
>
> Jill Caviglia-Harris
> Associate Professor
> Economics and Finance Department
> Salisbury University
> Salisbury, MD 21801
> (410) 548-5591
>>>> Puneet Dwivedi <puneetdwivedi at gmail.com> 05/29/09 6:38 PM >>>
> Dear All,
> I am trying to import data from excel which has 21436 rows and 96 
> variables
> in NLOGIT 4.0. I have tried almost everything which comes to my mind
but
> still I have not got any success in importing the data. Can anybody
help?
> Any response will be appreciated.
> Regards
> Puneet Dwivedi
> _______________________________________________
> Limdep site list
> Limdep at limdep.itls.usyd.edu.au
> http://limdep.itls.usyd.edu.au


--------------------------------------------------
From: "Barry Williams" <bwilliam at bond.edu.au>
Sent: Monday, June 29, 2009 2:54 AM
To: <limdep at limdep.itls.usyd.edu.au>
Subject: [Limdep Nlogit List] Reading Data from Office 2007

> Dear Limdepers,
>
>
>
> My office computer has been converted to Office 2007, so I am now
having
> considerable trouble loading my data set into Limdep.
>
>
>
> I recall there was a discussion on this a while ago, but could not
find
> it in the archives.
>
>
>
> I would appreciate any suggestions as to the optimal method to
> successfully load an Excel 2007 file into LIMDEPO.
>
>
>
> Many thanks,
>
>
>
> Barry
>
>
>
>
>
> _______________________________________________
> Limdep site list
> Limdep at limdep.itls.usyd.edu.au
> http://limdep.itls.usyd.edu.au
>