[Limdep Nlogit List] Data importing issue "please help"

[Arthur Caplan]

Hi Barry,

Have you tried saving your excel file in an earlier version, e.g., Excel 97-2003 Workbook (*.xls).  This has worked for me in the past.

Arthur

-----Original Message-----
From: limdep-bounces at limdep.itls.usyd.edu.au [mailto:limdep-bounces at limdep.itls.usyd.edu.au] On Behalf Of Barry Quinn
Sent: Wednesday, September 30, 2009 2:12 AM
To: Limdep and Nlogit Mailing List
Subject: Re: [Limdep Nlogit List] Data importing issue "please help"

Thanks for your swift reply ... This option I have thought of but  
Unfortunately I am a phd student so having to use precious funding to  
purchase another software package to deal with an issue in this one I  
would perfer to avoid ( due to the size of my data set over 250000  
data points the free version of stata/transfer does not convert the  
whole data set ) ..... If you could think of any obvious data  
characteristic issues ( aside from the ones I mentioned in previous  
email) which prevent limdep proper reading data I would be much  
appreciated..For eg
Does limdep limit decimal places ?
The limitation of 1024 characters per line in a text file !!! How to I  
figure out how many characters are in each text line ????

Many thanks for any help u can provide

Barry Quinn

On 30 Sep 2009, at 08:06, "Zhuo Shuaihe" <svicjo at yahoo.com> wrote:

> Try to use another software Stat/Transfer to onvert the data into  
> Limdep format. I always do that instead of importing.
>
> --- On Wed, 9/30/09, Barry Quinn <b.quinn at qub.ac.uk> wrote:
>
>> From: Barry Quinn <b.quinn at qub.ac.uk>
>> Subject: [Limdep Nlogit List] Data importing issue "please help"
>> To: "limdep at limdep.itls.usyd.edu.au" <limdep at limdep.itls.usyd.edu.au>
>> Date: Wednesday, September 30, 2009, 2:56 PM
>> [https://owa.qub.ac.uk/owa/8.2.176.2/themes/base/reply.gif]
>> Reply<https://owa.qub.ac.uk/owa/?ae=Item&t=IPM.Note&atttyp=embdd&id=RgAAAACYwMTvWDouR76LWeYHw5zbBwDfTxml%2bCCkSJjET5z1kHf5AABgdw3LAADfTxml%2bCCkSJjET5z1kHf5AHg%2bQnF8AAAJ&attid0=EADgeC73A8AwT7bUlwTqSBxX&attcnt=1# 
>> >
>>      [https://owa.qub.ac.uk/owa/8.2.176.2/themes/base/replyall.gif]
>> Reply to All<https://owa.qub.ac.uk/owa/?ae=Item&t=IPM.Note&atttyp=embdd&id=RgAAAACYwMTvWDouR76LWeYHw5zbBwDfTxml%2bCCkSJjET5z1kHf5AABgdw3LAADfTxml%2bCCkSJjET5z1kHf5AHg%2bQnF8AAAJ&attid0=EADgeC73A8AwT7bUlwTqSBxX&attcnt=1# 
>> >
>>   [https://owa.qub.ac.uk/owa/8.2.176.2/themes/base/forward.gif]
>> Forward<https://owa.qub.ac.uk/owa/?ae=Item&t=IPM.Note&atttyp=embdd&id=RgAAAACYwMTvWDouR76LWeYHw5zbBwDfTxml%2bCCkSJjET5z1kHf5AABgdw3LAADfTxml%2bCCkSJjET5z1kHf5AHg%2bQnF8AAAJ&attid0=EADgeC73A8AwT7bUlwTqSBxX&attcnt=1# 
>> >
>> [https://owa.qub.ac.uk/owa/8.2.176.2/themes/base/tbdv.gif]
>>     [https://owa.qub.ac.uk/owa/8.2.176.2/themes/base/clear.gif]
>> Close<https://owa.qub.ac.uk/owa/?ae=Item&t=IPM.Note&atttyp=embdd&id=RgAAAACYwMTvWDouR76LWeYHw5zbBwDfTxml%2bCCkSJjET5z1kHf5AABgdw3LAADfTxml%2bCCkSJjET5z1kHf5AHg%2bQnF8AAAJ&attid0=EADgeC73A8AwT7bUlwTqSBxX&attcnt=1# 
>> >
>>              [https://owa.qub.ac.uk/owa/8.2.176.2/themes/base/close.gif 
>> ]
>> <https://owa.qub.ac.uk/owa/?ae=Item&t=IPM.Note&atttyp=embdd&id=RgAAAACYwMTvWDouR76LWeYHw5zbBwDfTxml%2bCCkSJjET5z1kHf5AABgdw3LAADfTxml%2bCCkSJjET5z1kHf5AHg%2bQnF8AAAJ&attid0=EADgeC73A8AwT7bUlwTqSBxX&attcnt=1# 
>> >
>>   [https://owa.qub.ac.uk/owa/8.2.176.2/themes/base/crvtprt.gif]
>>
>>
>>
>>
>> Hi,
>>
>>
>>
>> I have been trying for a long time to import data but, with
>> little complete success.
>>
>>
>>
>> 1)      When using a .xls format Limdep
>> ALWAYS gives message “NLOGIT has encountered a problem and
>> needs to close”
>>
>> 2)      When using .txt or .csv files and
>> going through the command window using the following
>> command
>>
>> Read ; Nobs=2519 ;Nvar=82
>> ;names=marka,id,DV,year,t,neglng1,lng2,lng3,lng4,lng5,lnx1,lnx2,lnx3
>>
>> ,lnb, 
>> lnbd, 
>> lng2sq, 
>> lng3sq, 
>> lng4sq,lng5sq,lnx1sq,lnx2sq,lnx3sq,lnbsq,lnbdsq,lng2lng3,lng2lng4,
>>
>> lng2lng5, 
>> lng3lng4, 
>> lng3lng5, 
>> lng4lng5,lng2lnx1,lng2lnx2,lng2lnx3,lng3lnx1,lng3lnx2,lng3lnx3,
>>
>> lng4lnx1, 
>> lng4lnx2, 
>> lng4lnx3,lng5lnx1,lng5lnx2,lng5lnx3,lng2lnb,lng3lnb,lng4lnb,lng5lnb,
>>
>> lng2lnbd, 
>> lng3lnbd, 
>> lng4lnbd, 
>> lng5lnbd,lnx1lnx2,lnx1lnx3,lnx1lnb,lnx1lnbd,lnx2lnx3,lnx2lnb,
>>
>> lnx2lnbd, 
>> lnx3lnb, 
>> lnx3lnbd, 
>> t1, 
>> t2,t3,t4,t5,t6,t7,lnta,a,b,c,d,e,f,g,h,i,roa,roe,CI,emps,brhs,offBS
>>
>> ;file="C:\Documents and Settings\Barry\My Documents\My
>> Dropbox\cooperative banks\limdep.txt"$
>>
>>
>>
>> Received this output message
>>
>> “Last observation read from data file was
>> 2503”
>>
>> or for .csv “Last observation read from data file
>> was    2504”
>>
>>
>>
>>
>> The data set has been created in stata and exported to
>> excel then saved in the required format.
>>
>>
>> Why would Limdep not read all the observations??? The data
>> set has no missing values and there is no string or text
>> data  included!
>>
>>
>>
>> I would really appreciated any advice you can give....
>>
>>
>>
>> Kind regards
>>
>>
>>
>> Barry Quinn
>>
>>
>>
>>
>> _______________________________________________
>> 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