I am creating a XML document using EXCELXP tagset in SAS on os/390 system.
Right now my tagset options look like this:
ODS TAGSETS.EXCELXP FILE=GERMANY
OPTIONS(SHEET_NAME = 'Germany'
ORIENTATION = 'LANDSCAPE'
SUPPRESS_BYLINES = 'YES')
It is creating a EXCEL document and it works fine. The problem happens when there exists German characters in the EXCEL sheet. I am able to see German characters on host file. How ever in the first line of XML document If I include encoding="windows-1251" after the version in this cell, then the German characters looks good when I download from host or FTP from host to any server. Can anyone please help what to do in my SAS program to write encoding in the XML document while using EXCELXP.
on which version of the tagset is your system operating?
Installed with a production release of SAS913 on zOS are out-of-date features of excelXP that have been much enhanced after that distribution. On my windows SAS92 the note produced is[pre]NOTE: This is the Excel XP tagset (Compatible with SAS 9.1.3 and above, v1.94, 09/09/12)[/pre]I expect it to be different on your zOS, but it must be updated if you are still operating with a version before v1.7. The summary of enhancements can be seen at http://support.sas.com/rnd/base/ods/odsmarkup/excelxp_help.html .
Been quite some time since I raised my voice on any SAS forum. Experimenting with EXCELXP on z/OS with SAS 9.1.3 this thread caught my attention. Not only this. It actually helped me solve my problem. That is, I am able to produce a multisheet excel file (stored in a zFS file and served through z/OS's web server) with data, labels and even sheet names containing german umlauts.
Let the code speak for itself:
/*------- top of sample code ------*/
x 'umask 002' ;
%include tgs(excelxp) / nosource2 ;
%sysfunc(ifc(&syscc ge 4,%str(endsas,)) ;
ods listing close ;