[Limdep Nlogit List] Importing a matrix from Excel
Kevin Mahoney
kevin at DiagnosticDecisions.co.uk
Mon Nov 24 03:25:50 EST 2008
I have tried importing a block of cells from Excel, following the
instructions in R12.6.2
Using the following format:
Read; Rows = 12; Cols = 12; Matrix = ProbM $
1 0.666667 0.4 0.285714 0.222222 0.181818 0.153846 0.133333
0.117647 0.105263 0.095238 0.086957
0 0.333333 0.4 0.285714 0.222222 0.181818 0.153846 0.133333
0.117647 0.105263 0.095238 0.086957
0 0 0.2 0.285714 0.222222 0.181818 0.153846 0.133333 0.117647
0.105263 0.095238 0.086957
0 0 0 0.142857 0.222222 0.181818 0.153846 0.133333 0.117647
0.105263 0.095238 0.086957
0 0 0 0 0.111111 0.181818 0.153846 0.133333 0.117647 0.105263
0.095238 0.086957
0 0 0 0 0 0.090909 0.153846 0.133333 0.117647 0.105263
0.095238 0.086957
0 0 0 0 0 0 0.076923 0.133333 0.117647 0.105263 0.095238
0.086957
0 0 0 0 0 0 0 0.066667 0.117647 0.105263 0.095238 0.086957
0 0 0 0 0 0 0 0 0.058824 0.105263 0.095238 0.086957
0 0 0 0 0 0 0 0 0 0.052632 0.095238 0.086957
0 0 0 0 0 0 0 0 0 0 0.047619 0.086957
0 0 0 0 0 0 0 0 0 0 0 0.043478
produces
Error 4: READ - error reading NREC (NOBS) or NREC was not given.
regardless of whether I just highlight the Read line or the Read line +
the matrix when entering the command.
If I omit the $ symbol (as in Figure R12.15), the matrix appears to be
read but does not appear in the table of matrix names.
I'd be grateful for any advice or guidance
Kevin Mahoney
More information about the Limdep
mailing list