Hello All: I have been trying to correct an issue I am having with the ExcelXP tagset (which I am new to). I have searched all over but have found no reference to a similar problem. First, the hardware and software context. I am running SAS 9.2 TS Level 2MO on a Windows machine with XP Professional version 5.1.2600 Service Pack 3. The version of Excel I have is 2003 (11.8346.8341). The ExcelXP tagset I am using is version 1.127 (although I have the same exact problems with 1.116 and 1.37). The code I am running just as a test is very simple (and copied right from http://support.sas.com/rnd/base/ods/odsmarkup/p236-31.pdf😞 ods tagsets.excelxp file = "c:\test\ExcelXP.xls"; proc reg data = sashelp.class; model Weight = Height Age; run; quit; ods _all_ close; The XML file I get is malformed. The only two closing tags that use a "?" are rendered instead as a "]" (closed bracket). <?xml version="1.0" encoding="windows-1252"] <?mso-application progid="Excel.Sheet"] If I go in and change the output file by hand and replace the "]" with "?>" I am then able to open the file in Excel, a web-browser or an XML editor. I thought the problem might have been in the tagset code but it looks like I would expect it to - it places a "?>" closing tag. put '<?xml version = "1.0"'; putq " encoding=" encoding; put "?>" CR CR; putl '<?mso-application progid="Excel.Sheet"?>'; Funny thing is that the WML tagset has an identical line for the "xml version" as the excelxp tagset, and when I run that one, it generates the proper XML. None of the ExcelXP tagsets, however, generate the proper close tag. In addition, the log shows a parsing error in a regex expression (see attached log). The error it points to seems to involve the replacement of a paren with a curly brace. I checked the tagset and it does not have a curly brace but a paren. If anyone has any suggestions, I would be most appreciative. Gene
... View more