04-02-2013 03:15 PM
Just try this and see for yourself:
data fruits; input Fruit $char20.; datalines; Banana Apple Orange Lemon ; proc print; proc export data=fruits outfile="Fruits1.xls" dbms=EXCEL replace; proc export data=fruits outfile="Fruits2.xlsx" dbms=EXCEL replace; run;
Leading spaces are not preserved when exporting to xlsx Excel format but they are in xls old format.
Is this something overlooked in SAS Excel engine, a bug, a limitation of Excel Ace engine or it's designed as such ?????