Has anyone been able to get the following example, http://support.sas.com/rnd/base/ods/odsmarkup/msoffice2k/index.html#multiple, to work with either SAS 9.13 or SAS 9.2 (TS2M3) and Excel 2003?
Even after fixing the syntax error, Excel reports back that the spreadsheet has a serious error.
TIA,
Kim LeBouton
Kim,
Don't tell Vince, but I've been able to avoid tagsets all of these years. However, that said, if you post your code and a sample data set, I'd be glad to take a look.
Art
Kim,
i have tried the sample under 9.2.3 with the minor correction
and the opening was without problems under excel2010
and after transportation of the file upon a pc whith excel2003
the htm file (even with a .xls suffix) was opening well
perhaps has the office 2003 the addon for reading .xlsx files
but in our matter as the code is html, i have no idea why you have had trouble
HTH
Andre
procsort data=sashelp.classout=test;
by age;
run;
ods tagsets.msoffice2k path="d:\temp" file="temp.html" newfile=output;
proc print data=test;
by age;
run;
ods tagsets.msoffice2k close;
ods tagsets.msoffice2k_x file="d:\temp\tempmultiple.xls" style=statistical
options(worksheet_source="11#d:\temp\temp.html,
12#d:\temp\temp1.html,
13#d:\temp\temp2.html,
14#d:\temp\temp3.html,
15#d:\temp\temp4.html,
16#d:\temp\temp5.html"
);
data _null_;
file print;
put "test";
run;
ods tagsets.msoffice2k_x close;
the content of tempmultiple.xls is the following text
<html xmlns:x="urn:schemas-microsoft-com:office:excel">
<head>
<meta name="Excel Workbook Frameset">
<meta name="Generator" content="SAS Software Version 9.2, see www.sas.com">
<meta http-equiv="Content-type" content="text/html; charset=windows-1252">
<title>SAS Output</title>
<style type="text/css">
<!--
-->
</style>
<script language="javascript" type="text/javascript">
<!--
function startup(){
}
function shutdown(){
}
//-->
</script>
<!--[if gte mso 9]><xml>
<x:ExcelWorkbook>
<x:ExcelWorksheets>
<x:ExcelWorksheet>
<x:Name>11</x:Name>
<x:WorksheetSource HRef="d:\temp\temp.html"/>
</x:ExcelWorksheet>
<x:ExcelWorksheet>
<x:Name>12</x:Name>
<x:WorksheetSource HRef="d:\temp\temp1.html"/>
</x:ExcelWorksheet>
<x:ExcelWorksheet>
<x:Name>13</x:Name>
<x:WorksheetSource HRef="d:\temp\temp2.html"/>
</x:ExcelWorksheet>
<x:ExcelWorksheet>
<x:Name>14</x:Name>
<x:WorksheetSource HRef="d:\temp\temp3.html"/>
</x:ExcelWorksheet>
<x:ExcelWorksheet>
<x:Name>15</x:Name>
<x:WorksheetSource HRef="d:\temp\temp4.html"/>
</x:ExcelWorksheet>
<x:ExcelWorksheet>
<x:Name>16</x:Name>
<x:WorksheetSource HRef="d:\temp\temp5.html"/>
</x:ExcelWorksheet>
</x:ExcelWorksheets>
<x:WindowHeight>12495</x:WindowHeight>
<x:WindowWidth>18900</x:WindowWidth>
<x:WindowTopX>60</x:WindowTopX>
<x:WindowTopY>45</x:WindowTopY>
<x:ProtectStructure>False</x:ProtectStructure>
<x:ProtectWindows>False</x:ProtectWindows>
</x:ExcelWorkbook>
</xml><![endif]-->
</head>
<body onload="startup()" onunload="shutdown()" class="Body" style=" text-align: center;">
<script language="javascript" type="text/javascript">
<!--
var _info = navigator.userAgent
var _ie = (_info.indexOf("MSIE") > 0
&& _info.indexOf("Win") > 0
&& _info.indexOf("Windows 3.1") < 0);
//-->
</script>
<div class="branch">
<a name="IDX"></a>
<h1 class="SystemTitle">Le Système SAS</h1>
<div>
<div align="center">
<table cellspacing="0" cellpadding="0" summary="Page Layout">
<tr><td>
<pre class="Batch" style=" padding: 7px; border-spacing: 1px; border: 1px solid #000000; text-align: left;">test
</pre></td></tr>
</table>
</div>
</div>
<br>
</div>
</body>
</html>
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.