I am trying to generate a Table 1 and export to excel. The Table 1 is created and depicted in Stata output window, but I am consistently getting an export error to Excel:
_xlshwritestrcol(): 9901 Stata returned error
export_excel_write_file(): - function returned error
export_excel_export_file(): - function returned error
<istmt>: - function returned error
This is the stata code I am using:
table1_mc, by(income) vars (age contn \ sex bin \ race cat \ education cat \ smk2cat bin \ bmi contn \ teeth contn \ tot_fat contn \ kcal contn \ HDL contn \ LDL contn \ triglyc contn ) onecol saving(table1IP.xls, replace)
_xlshwritestrcol(): 9901 Stata returned error
export_excel_write_file(): - function returned error
export_excel_export_file(): - function returned error
<istmt>: - function returned error
This is the stata code I am using:
table1_mc, by(income) vars (age contn \ sex bin \ race cat \ education cat \ smk2cat bin \ bmi contn \ teeth contn \ tot_fat contn \ kcal contn \ HDL contn \ LDL contn \ triglyc contn ) onecol saving(table1IP.xls, replace)