xuelida 发表于 2013-6-16 13:30
如果搞不懂,就一句一句的运行,看运行结果,就能知道了
版主你好。我现在才有一点点摸着头脑了。。应该是先insert file,打开下载的编辑好了的CCEgauss6程序文件。用给的例子(CCEtestdata)是能得出结果了。但当我试用自己研究用的excel时,每次都会出现error G0058 : Index out of range。
按照给的pdf中的说法,我把其中写明的要改的地方都改了。如下:
/** Specify the directory and name of the output file **/
/************************************************************/
output file =
c:\\gausslt8.0\\CCEgauss6_22Aug08\\output2.txt RESET;
/************************************************************/
/** load cross section id, years, y_it, x_it (first sheet) **/
/************************************************************/
/* Specify the rage of first raw, variables names */
vname=xlsreadm("
c:\\gausslt8.0\\CCEgauss6_22Aug08\\Testdata2.xls","a1:e1",1,"");
/* Specify the range of the cross section varying regresssors, second raw onwards */
data=xlsreadm("
c:\\gausslt8.0\\CCEgauss6_22Aug08\\Testdata2.xls","a2:e73",1,"");
/*****************************************************************/
/** load cross sectionally common variables d_t (second sheet) **/
/*****************************************************************/
/** first of all, specify the number of "d" (except intercept) **/
nb_d=1;
if nb_d /= 0;
/* Specify the rage of first raw, variables names (SECOND EXCEL SHEET)*/
dname=xlsreadm("c:\\gausslt8.0\\CCEgauss6_22Aug08\\Testdata2.xls","b1:b1",2,"");
dname=dname[1,1:nb_d]; (当nb_d=3时,这里要做调整吗?)
/* Specify the rage of observed common factors z_t (SECOND EXCEL SHEET)*/
data_d=xlsreadm("c:\\gausslt8.0\\CCEgauss6_22Aug08\\Testdata2.xls","b2:b37",2,"");
endif;
/*****************************************************************/
/** specify the x which would not go for cross section averages **/
/*****************************************************************/
/** Column number in Excel (please put "0" if not applicable) **/
/** eg, no_xbar = {5 6}; **/
no_xbar = {0 };
/*****************************************************************/
/** specify the x and id, which has "zeros" due to normalisation**/
/*****************************************************************/
/** zero_x: Column number in Excel
zero_id: the id number
eg, zero_x = 5; zero_id = 3;
(zero_x = 0; zero_id = 0 if not applicable) **/
zero_x = 0; zero_id = 0;
/******************************************************************/
/** Whether the individual CCE estimation results are reported or not */
/*******************************************************************/
report=1; /*** report=0: not reported, report=1:reported at the end */
现在想请问版主的是:
1. 为什么会出现index out of range的情形?
2. 是否只用修改pdf中提到的需要修改的几条程序?——上述标
水红色的部分
(这里是否也需要修改??——因为我是
“月度数据”)
/** some outputs **/
"++++++++++++++++ <Preliminary Information on Panel Data> ++ ++++++++++++++++++++++++++++++++++++++++++++";
anames=("
Min(month)"~"Max(month)"~"Min(Ti)"~"Max(Ti)"~"N"~"mean Ti");)
3. 麻烦楼主帮我看看我下面上传的excel,这样的一种状况的话,在给的既定的程序上我上述的修改是否正确?
万分感谢!!
Testdata2.xlsx
(12.33 KB)