The SAS Output Delivery System and reporting techniques

Difference between Windows and Linux for ODS tagsets.excelxp output

Reply
New Contributor
Posts: 3

Difference between Windows and Linux for ODS tagsets.excelxp output

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 ssSmiley FrustratedtyleID="data__l" ss:Index="1"><Data ss:Type="String">Alfred</Data></Cell>

- Cell containing Alfred name use data style in ExcelXP_LINUX.xls :

<Cell ssSmiley FrustratedtyleID="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" ssSmiley Tonguearent="data"><Alignment ss:WrapText="1" ss:Horizontal="Left"/>

</Style>

* Linux :

<Style ss:ID="data__l" ssSmiley Tonguearent="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 Smiley Wink

SAS Super FREQ
Posts: 8,866

Re: Difference between Windows and Linux for ODS tagsets.excelxp output

Posted in reply to Mikael_BERTHO_CHU_44_fr

Hi:

  I believe that this is an issue for Tech Support. TAGSETS.EXCELXP is only building the XML file, as you noted. Excel is rendering the sheet. Since you can show that different forms of XML are generated on the different operating systems, one thing to check (in the SAS log) is whether the same verions of TAGSETS.EXCELXP is being used on both systems. I would expect your %include to fail on Linux, because I didn't think that Linux actually had C:\ drives. If your include is not working on Linux, then I'm not sure what version of the tagset template you're getting, but that's why I would recommend checking the log.

  If there is a known issue with Windows/Linux and TAGSETS.EXCELXP then Tech Support will know about it. If there is a need to involve the developers to fix the issue, then Tech Support can open a defect, if they verify that this is a defect.

  To open a track with Tech Support, fill out the form at this link:

http://support.sas.com/ctx/supportform/createForm

cynthia

New Contributor
Posts: 3

Re: Difference between Windows and Linux for ODS tagsets.excelxp output

Posted in reply to Cynthia_sas

Hi Cynthia.

I will open a track.

Of course, when I submit this sample program on our Linux server, I have changed path for %INCLUDE and ODS output Smiley Wink

Thanks.

Ask a Question
Discussion stats
  • 2 replies
  • 831 views
  • 3 likes
  • 2 in conversation