Hi. We are testing tagsets.excelxp for producing Excel spreadshits within SAS 9.2 Linux. For now, we are using RSUBMIT to Windows SAS server and DDE link to control Excel and write XLS files. So, we have download the latest ExcelXP tagsets v1.127 from : Base SAS: ODS MARKUP And we are using this little program to test Excel output on our Windows XP workstation running SAS 9.2 TS2M3 : ODS LISTING CLOSE; LIBNAME temp "C:\Temp"; ODS PATH temp.tmplmst(update) sashelp.tmplmst(read); %INCLUDE "C:\Temp\excltags.tpl"; ODS TAGSETS.ExcelXP FILE="C:\temp\ExcelXP_WINDOWS.xls"; PROC REPORT DATA=sashelp.class NOWINDOWS; COLUMN name sex age; DEFINE name / DISPLAY STYLE(Column) = [just=left]; DEFINE sex / DISPLAY STYLE(Column) = [just=center]; DEFINE age / DISPLAY STYLE(Column) = [just=right]; QUIT; ODS TAGSETS.ExcelXP CLOSE; So everything is OK (see ExcelXP_WINDOWS.xls file in attachment). But, running the same progam on our Linux server (Red Hat 5) with SAS 9.2 TS2M3 give us Excel file with all columns right aligned (see ExcelXP_LINUX.xls file in attachment). When you open and compare those 2 XLS/XML files, you can notice that : - Cell containing Alfred name use data__l style in ExcelXP_WINDOWS.xls : <Cell ss:StyleID="data__l" ss:Index="1"><Data ss:Type="String">Alfred</Data></Cell> - Cell containing Alfred name use data style in ExcelXP_LINUX.xls : <Cell ss:StyleID="data" ss:Index="1"><Data ss:Type="String">Alfred</Data></Cell> So first issue, Linux did not use data__l for left aligned column. But even with correct style, the issue still occur because data__l is not well defined : * Windows : <Style ss:ID="data__l" ss:Parent="data"><Alignment ss:WrapText="1" ss:Horizontal="Left"/> </Style> * Linux : <Style ss:ID="data__l" ss:Parent="data"><Alignment ss:WrapText="1" ss:Horizontal="Right"/> </Style> Is there any way to fix this issue ? Thanks. PS : Sorry for my english, I'm a french SAS user
... View more