In reply to Tina.

Instead of the PROC EXPORT, try this:

ods excel file='\test1.xlsx';
proc print data=test1;
run;
ods excel close;