SAS "Put" function for Leading zero exporting EXCEL or HTML 1

[noway320]

I am using put function for adding zero before the numeric Is there a way for it not to get lost when exporting to Excel or html?

 

[klaz2002]

This is a bug in Excel not SAS. I think that if you use the PROC EXPORT procedure you can get your leading zeros to show up.

data test;
 x= 7;
 y = put(x,z5.);
run;
proc export
    data = test
    outfile = "c:\temp\t1.xls"
    replace;
run;

I hope this helps you,
Klaz