SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

Leading spaces not preserved when exporting to xlsx Excel format?

Reply
N/A
Posts: 1

Leading spaces not preserved when exporting to xlsx Excel format?

Hi,

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 ?????

Post a Question
Discussion Stats
  • 0 replies
  • 434 views
  • 0 likes
  • 1 in conversation