Total Factor productivty using malmq2 command

[Moosa Alsubhi]

Hi every body,,,

Currently i am conducting study to evlaute the productivty and the tehcnical efficiency of 18 public hospitals (DMUs) from 2010 to 2018, using DEA Malmaquist Productivty Index

i have creat a panel data in excel and then transfered it to stata 16 (attached)

DMU	Year	Beds	Annual Recurrent Expenditure	No. of Inpatient Days/year	No. of Outpatient visitis/year
1	2010	623	41.1	151445	155,481
2	2010	485	18.3	110,110	159,438
3	2010	142	9	21,900	147,474
4	2010	450	11.8	103,660	308,897
5	2010	100	1.6	10,220	12,188
6	2010	150	2.5	23,360	247,933
7	2010	301	8.8	62,780	158,004
8	2010	363	11.8	89,790	217,004
9	2010	235	7.2	57,670	145,057
10	2010	243	6.4	36,500	95,488
11	2010	191	6.1	48,545	71,948
12	2010	240	7.2	51,100	140,748
13	2010	40	0.6	6,205	27,662
14	2010	70	2.1	12,045	30,193
15	2010	94	3.3	14,235	219,728
16	2010	60	1.7	12,775	219,096
17	2010	80	2.1	18,980	41,332
18	2010	89	2.6	18,615	268,449
1	2011	623	51.3	142,349	169,807
2	2011	491	21.1	118,103	143,551
3	2011	134	10.2	25,550	155,636
4	2011	450	13.9	110,595	302,023
5	2011	100	1.9	9,855	10,235
6	2011	150	3.4	21,170	118,821
7	2011	301	10.1	63,875	160,023
8	2011	363	12.5	93,075	192,750
9	2011	235	8.1	60,590	135,531
10	2011	243	7.4	41,610	99,898

i used the following step:
1- xtset dmu year to verify the panal set and time
then i used the following command

malmq2 beds annualrecurrentexpenditure = noofinpatientdaysyear noofoutpatientvisitisyear,ort(i)period( year) trace

but i recived this error (option period() not allowed), so i really appreciat if anyone can help me with this issues

kind regards

[William Lisowski]

The output of help malmq2 does not describe a period() option, which is consistent with the error message you received. Having xtset your data, I am guessing that malmq2 uses that information and does not need you to tell it what the time variable is. Notice that in the examples shown by help malmq2 none of them specify a period.

[Moosa Alsubhi]

Thank you William for your response

i have tried to use examples shown by help malmq2 but i got this error notice ( <istmt>: 3499 sdf_o() not found)

the following is my command for each senarior

malmq2 beds annualrecurrentexpenditure = noofinpatientdaysyear noofoutpatientvisitisyear,global
malmq2 beds annualrecurrentexpenditure = noofinpatientdaysyear noofoutpatientvisitisyear, seq ort(i)
malmq2 beds annualrecurrentexpenditure = noofinpatientdaysyear noofoutpatientvisitisyear, seq ort(o) fgnz
malmq2 beds annualrecurrentexpenditure = noofinpatientdaysyear noofoutpatientvisitisyear, ort(i) rd sav(desktop)


kind regards
Moosa

[William Lisowski]

I installed malmq2 from SSC and had the same experience with the example from help malmq2.

I installed the latest version from the author's github site and the example worked.

ssc uninstall malmq2
net install malmq2, from("https://raw.githubusercontent.com/kerrydu/malmq2/master/")

[Moosa Alsubhi]

Thank you very much William and i do really appreciate your support , it works now

many thanks
Moosa

[clara owens]

Hello, My data is much the same as Moosa's above. I have followed all the steps above but I am returning with a different error. I would be REALLY grateful for any help, I've been stuck for a while trying to figure it out!

[clara owens]

I am happy to share my data if anyone know what to do :')

[Juan Price Elton]

Hello. The Adjacent Malmquist Index is known for being non-transitive, that is if M(1,2) measures TFP change between periods 1 and 2 and M(2,3) measures TFP change between periods 2 and 3, then we cannot say that M(1,2) times M(2,3) equals M(1,3). However, I suspect that if I estimate this with the malmq2 command and add the global option, I would be estimating a transitive Malmquist Index. Can anyone confirm if I am write or wrong. I would really appreciate it.

[nyamekye abban]

I installed malmq2 from SSC and had the same experience with the example from help malmq2.

I installed the latest version from the author's github site and the example worked.

ssc uninstall malmq2
net install malmq2, from("https://raw.githubusercontent.com/kerrydu/malmq2/master/")

hello, i followed this command but it shows host not found. any help please

[nyamekye abban]

i also tried malmq2 using this command malmq2 FDISt TLF= GDP PGDP TExIM InfDev . The results i had only included 3 decompositions. tfpch, tech, tecch. how can i get effch, sech and pech? thank you

[Victoria Romanova]

Hello, I have a problem with the malmq2 command. I enter the following: malmq2 X1 X2 X3 = Y, period(year), but I receive an error saying must specify timevar; use xtset. Could you help me with this? How should I specify timevar, and what should I do with xtset? I would be grateful if you wrote the right command.