Formats are not applied correctly, using SAS 9.1.3 and PROC DBLOAD with
the FORMAT statement to create an Excel 5.0 worksheet.

To see this behavior:

  data mydata;
   input id $ Val1 9.3;
  cards;
  A001 12345.789
  A002   221.133
  A003  2910.915
  ;

  * creates excel worksheet with '0000000000' custom format;
  proc dbload dbms=excel
   data=work.mydata;
   path='c:\mydata1.xls';
   format Val1 10.;
   load;
  run;

  * creates excel worksheet with '00000000.0' custom format;
  proc dbload dbms=excel
   data=work.mydata;
   path='c:\mydata2.xls';
   format Val1 10.1;
   load;
  run;


  * creates excel worksheet with correct numeric '0.00' format;
  proc dbload dbms=excel
   data=work.mydata;
   path='c:\mydata3.xls';
   format Val1 10.2;
   load;
  run;

After running the sample program, simply open mydate1.xls into Excel and
right-click on any data in the "B" column to select Properties and
select "Format Cells".  This will show as a Custom format of type
"0000000000" which is incorrect.

This behavior is corrected in SAS 9.2.

A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

http://www.sas.com/techsup/download/hotfix/e9_sbcs_prod_list.html#013954

Operating System and Release Information

A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at: