STATA 导出EXCEL 行数过多 原因 及应对

myrj / 2023-08-24 / 原文

stata导出到EXCEL:

报错:

. export excel using "D:\te\安徽.xlsx",
> firstrow(variables)
observations must be between 1 and 1048576
r(198);

是因为XLSX最大行数限制

将文件分成多个导出,分别小于1048576即可

keep in 1/1048575

. export excel using "D:\te\安徽1.xlsx", firstrow(variables)
file D:\te\安徽1.xlsx saved