If you license the SAS/ACCESS Interface to PC Files, and you want only the data and no colors or other markup, then this code gives you what you want:
* 206,160 rows and 22 columns;
data work.big_zipcode;
set sashelp.zipcode;
do i = 1 to 5;
output;
end;
run;
* All 206,160 rows and 22 columns written without an out-of-memory error;
proc export data=work.big_zipcode
file='C:\temp\big_zipcode.xlsx'
dbms=xlsx
replace;
run; quit;
Vince DelGobbo
SAS R&D
... View more