Using SAS 8.2--> SAS/EIS specifically on a Unix environment, where the users submit their query with a remote submit, and where the results are placed on a local path on there pc.
When they use the Export to Excel function, the user will receive a windows screen with an error. When I look at the SAS-logs it seems that, with the export function via PROC DBLOAD, reaches a maximum limit within EXCEL of 16.383 rows. This is documented by Microsoft, but than it's said that this limit is reached with the columns. So i'm starting to get confused.
This is the SAS-log:
ERROR: The maximum number of rows has been exceeded, no more observations will be loaded.
ERROR: Insert failed for obs number 16384.
Then again, I'm trying to export the same data as a SAS Data Set. No problem so far. The next step is to use the Export function that's available in the toolbar. I export the SAS dataset as a .xls file--> no problem.
I'm openingen the newly created .xls form in Excel 2000 and all data is shown. --> finally no problem. But still, via the 'normal'users way of working, it fails with the column maximum of 16.383, while the used variables are rows....
proc dbload data=WORK._EXPORT_
dbms=excel ;
path = "M:\DOCUME~1\xxxxxxx\LOCALS~1\Temp\3\_SAS0002.XLS";
version=/*5*/7;
limit=0;
putnames=yes;
label;
WARNING: Label set. Use reset command to use SAS labels.
reset ALL;
load;
run;
Who has an idea of what isn't working proparly? Thanks in advance!
Daniël@LogicaCMG