topic Exporting more than 1048576 into csv using base sas 9.4 proc export in SAS Procedures

Exporting more than 1048576 into csv using base sas 9.4 proc export

Solly7 — Tue, 03 Dec 2019 11:46:58 GMT

hi i need help in Exporting more than 1048576 into csv/xlsb/xlsx file using base sas 9.4 .

I need to work on report using excel but my rows always limits to 1048576 when i use below code to export

proc export
data = Final_Rollup
outfile = 'C:\Users\msbla\report.xlsb'
dbms = excel replace;
run;

Re: Exporting more than 1048576 into csv using base sas 9.4 proc export

Kurt_Bremser — Tue, 03 Dec 2019 11:51:05 GMT

Use the proper dbms= value:

proc export
  data = Final_Rollup
  outfile = 'C:\Users\msbla\report.csv'
  dbms = csv
  replace
;
run;

A csv file is only limited by available disk storage. Note that you can't import it into Excel, but who uses Excel for data containing a million rows anyway?

Re: Exporting more than 1048576 into csv using base sas 9.4 proc export

unison — Tue, 03 Dec 2019 14:20:18 GMT

As Kurt suggested, use CSV for this.

From Microsoft:

Excel 2007 and above supports 2^20 rows, i.e. 1048576 rows. They are just numbered from 1 to 1048576.

https://answers.microsoft.com/en-us/office/forum/office_2013_release-excel/why-does-an-excel-spreadsheet-end-at-1048576-and/0007c3c4-0785-45a4-ad63-78b930773a5e

-unison