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

Barry Quinn b.quinn at qub.ac.uk
Thu Oct 1 00:32:24 EST 2009


Hi Arthur

Yeah this didn't work unfortunately ... Good news is that BIll Greene  
very kindly cleaned my xls file and sent it back so problem fixed

Many thanks

Barry



On 30 Sep 2009, at 15:27, "Arthur Caplan" <arthur.caplan at usu.edu> wrote:

> 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
> _______________________________________________
> Limdep site list
> Limdep at limdep.itls.usyd.edu.au
> http://limdep.itls.usyd.edu.au


More information about the Limdep mailing list