Error message with malmq

[Sam]

Thanks for providing such a wonderful tool for calculating Malmquist Index. much appreicated.

I have a problem in running the malmq code and would like to seek for advice here. My dataset comprises three inputs variables (ivar1, ivar2, and ivar3) and one output variable (ovar) with dmu being identified as the ticker codes for all the listed US company. The time period variable is the fiscal year.

My problem is I would like to restrict the malmq index within each fama-french 48 industry, so I have the code typed as:

forvalues x= 1/48 {
malmq ivar1 ivar2 ivar3 = ovar if ind == x' & year >=1987, period (year) saving (malmq_indx')
}

However, there are five lines of error messages:

1.
No Solution(No more candidate for entering variable):[DMUi=16][LOOP=6]CRS-IN-SI-PI

Or

No Solution(LOOP greater than maxiter):[DMUi=34][LOOP=16001]CRS-IN-SI-PII

Or

No error message for this line

1. lp_phase1() : 3301 subscript invalid
2. dealp() : - function returned error
3. _dealp(): - function returned error
4. < istmt >: - function returned error

I have tried to re-install the malmq.ado and re-run the ldeo.do file as instructed, I have also tried to run the code without the loop, so the code I have ran is:

malmq ivar1 ivar2 ivar3 = ovar if ind == 1 & fyear >=1987, period (year) saving (malmq_ind1)

However, same error messages appeared again.

I have attached an extract of my dataset here.

Thanks for looking at my problem, much appreciated.

[Choonjoo Lee]

Hello!
Could you generate 'dmu' variable or a variable for dmu with the string type format?
Program requires the dmu variable in the string type.
And let me know if the problem persist?

[Sam]

Thanks for the reply.

I think the program also works fine when the dmu is in double/float. I actually figured out the error messages are because of the unbalanced panael data. So I first type "xtset comp_code year, yearly", then "tsfill, full", and then generate the dmu "gen dmu = comp_code" and the ind variable "by comp_code, sort : egen ind_1= mean(ind)"

And re-run the code:

forvalues x= 1/48 {
malmq ivar1 ivar2 ivar3 = ovar if ind_1 == x' & year >=1987, period (year) saving (malmq_ind x ')
}

And it works this time.

[Harun Rashid]

Hi Choonjoo Lee and Sam,
I am having the same problem when I run the malmq command using the attached data.
malmq i_s i_b i_op i_b i_gr i_lp = o_p, ort(in) period(year) saving(eff_output)
The errors I get are as follows.

• dealp(): 3301 subscript invalid
  dealp(): - function returned error
  <istmt>: - function returned error
  r(3301);
  *
  Could any of you please help me to solve this problem?

[Serena]