If you aren't exceeding those limits it may be the content of one or more records. If I wanted see if that were the case I would be tempted to export portions of the data set, using FirstObs and OBS dataset options and see if the problem is restricted to specific records. for instance proc export data = population (obs=1) /* to limit to the first record*/                           outfile = "Path name here\The file name .xlsx"                           dbms = xlsx replace; sheet='Population'; run; proc export data = population (obs=240000) /* to limit to the first 240000 records*/                           outfile = "Path name here\The file name a.xlsx"                           dbms = xlsx replace; sheet='Population'; run; proc export data = population (firstobs=240001) /* to make a separate file of those after 240000*/                           outfile = "Path name here\The file name b.xlsx"                           dbms = xlsx replace; sheet='Population'; run; And to find if the problem exists within a specific range proc export data = population (firatobs=100000 obs=240000) /* first record is 100000 and export additional  140000 records*/                           outfile = "Path name here\The file name a.xlsx"                           dbms = xlsx replace; sheet='Population'; run; ... View more