Hi I have ran with the following code with 30,000 records and it took only 12 sec , but I am not able to open the xls file and take so long to open a file with 5000 records. When I changed ods msoffice2k to ExcelXP and removed all fomatting in the proc report and ran with 30,000 records, it took 4 hours to run the program. Can any one give advice, how can I optimize this time issue or any thing wrong with my coding?
LIBNAME mylib 'C:\TEMP';
ods tagsets.msoffice2K path="C\TEMP" file=FILENAME.XLS rs=none
style=minimal options(doc='QUICK'
Sheet_Name='Report'
Orientation='LANDSCAPE'
Embedded_Titles='YES'
Embed_Titles_Once='YES'
Suppress_Bylines='YES'
Sheet_Interval='NONE'
Convert_Percentages='YES'
Skip_Space='3,0,1,1,1'
Absolute_Column_Width='40,7,12,9,9,9,10,7,10,9,9,10,9,9,9,9,9,9,9'
);
run;
TITLE;
OPTIONS NOBYLINE;
PROC REPORT DATA=mylib.INDATA NOWINDOWS;
COLUMN VAR1 VAR2 VAR3 VAR4 VAR5 VAR6 VAR7 VAR8
VAR9 VAR10 VAR11 VAR12 VAR13 VAR14 VAR15 VAR16
VAR17 VAR18 VAR19;
DEFINE VAR1 / DISPLAY 'VAR1'
STYLE(COLUMN)={HTMLSTYLE='mso-number-format:00000'};
DEFINE VAR2 / DISPLAY 'VAR2';
DEFINE VAR3 / DISPLAY 'VAR3'
STYLE(COLUMN)={HTMLSTYLE='mso-number-format:000000000000'};
DEFINE VAR4 / DISPLAY 'VAR4';
DEFINE VAR5 / DISPLAY 'VAR5';
DEFINE VAR6 / DISPLAY 'VAR6' FORMAT=COMMA13.;
DEFINE VAR7 / DISPLAY 'VAR7';
DEFINE VAR8 / DISPLAY 'VAR8'
STYLE(COLUMN)={HTMLSTYLE='mso-number-format:00000'};
DEFINE VAR9 / DISPLAY 'VAR9';
DEFINE VAR10 / DISPLAY 'VAR10';
DEFINE VAR11 / DISPLAY 'VAR11';
DEFINE VAR12 / DISPLAY 'VAR12'
STYLE(COLUMN)={HTMLSTYLE='mso-number-format:000000000000'};
DEFINE VAR13 / DISPLAY 'VAR13';
DEFINE VAR14 / DISPLAY 'VAR14';
DEFINE VAR15 / DISPLAY 'VAR15';
DEFINE VAR16 / DISPLAY 'VAR16';
DEFINE VAR17 / DISPLAY 'VAR17';
DEFINE VAR18 / DISPLAY 'VAR18';
DEFINE VAR19 / DISPLAY 'VAR19';
RUN;
ods _all_ close;
ods listing;
ods results;
ods trace off;
Thanks
Inp