Hi, I have a SAS program that creates a table of values (through multiple data and proc steps), and that ends with a Proc Export to export that table to one of the tabs of an Excel template (xls). PROC EXPORT DATA = work.abc OUTFILE= “mypath to Excel template\xyz_template.xls" DBMS=EXCEL REPLACE; SHEET="table1"; RUN; There is no pre-formatting in the 'table1' sheet of the template - only the column headings and some data that gets replaced when the proc export is run; every cell is in "General" format and aligned to center. After the export, some cells in the table are bottom aligned, and some (random ones) are center bottom aligned - and the strangest thing is that the latter cells are coloured (have a light blue background colour) and a black border around them). There is no specified colour or alignment style in my SAS program, so I don't understand where the formatting is coming from. I have tried deleting that sheet in the template altogether, as proc export creates a new one if it does not find one to replace, and this time the same type of formatting happened when proc export created the 'table1' sheet, except that the center-bottom-aligned cells now got coloured in a different colour (purple). I've attached a sample of how my Excel output looks like. Wondered if someone else encountered this issue. Thanks!
... View more