[Limdep Nlogit List] (no subject)

wgreene at stern.nyu.edu wgreene at stern.nyu.edu
Fri Oct 2 07:17:24 EST 2009


Sharmistha. "Compatibility mode" in excel 2007 does not work. The file is only compatible with older versions of excel. There are undecipherable codes in there. You should either convert to .csv format or use a true 2003 version of excel to make the file.
Bill Greene

Bill Greene/646-596-3296/wgreene at stern.nyu.edu

-----Original Message-----
From: Sharmistha Nag <nags at onid.orst.edu>

Date: Thu, 01 Oct 2009 14:09:19 
To: Limdep and Nlogit Mailing List<limdep at limdep.itls.usyd.edu.au>
Subject: Re: [Limdep Nlogit List] (no subject)


Hi Barry,
I have saved the file in excel 97-2007 (compatibility mode) format. I  
am quite surprised that part of it is loading the rest is not. May be  
I will have to use 2003 version and check. Thanks.
Sharmistha Nag
Dept of Agricultural & Resource Economics
OREGON ST UNIV


Quoting Barry Quinn <b.quinn at qub.ac.uk>:

> Hi sharmistha,
>
> Are you using excel 2007 ???
>
> It creates files which most stats packages can't read regardless of
> what way you save them ....
>
> The best thing to do is get an earlier version of excel 2003 or
> earlier and save the file as excel 4.0 worksheet .. This is probably
> the most bulletproof version for importing data...
> Make sure any variable names are 8 characters or less before importing
> also
>
>
>
> On 1 Oct 2009, at 21:54, "Sharmistha Nag" <nags at onid.orst.edu> wrote:
>
>> I am trying to import an excel file (saved as xls) into limdep.
>> Everytime I try to do that I find the first few and the last few
>> observations are loaded into the data editor but a huge portion in the
>> middle of the dataset is missing.
>> Can anybody please point out the error? Thanks.
>> Sharmistha Nag
>> Dept of Agricultural & Resource Economics
>> OREGON ST UNIV
>>
>>
>>
>>
>> _______________________________________________
>> Limdep site list
>> Limdep at limdep.itls.usyd.edu.au
>> http://limdep.itls.usyd.edu.au
> _______________________________________________
> Limdep site list
> Limdep at limdep.itls.usyd.edu.au
> http://limdep.itls.usyd.edu.au
>
>


_______________________________________________
Limdep site list
Limdep at limdep.itls.usyd.edu.au
http://limdep.itls.usyd.edu.au


More information about the Limdep mailing list