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

[Solly7]

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;

[Kurt_Bremser]

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?

[unison]

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-spreads...

-unison