Is there a better way to get output into an actual xls? I'm running 9.3 on 64bit windows server 2006r2 and office 2013 ods tagsets.excelxp path=xxxx file=spreadsheet.xml style xlsanspprinter; ods tagsets.excelxp options ( embedded_titles='yes' embedded_footnotes='yes' sheet_name='Reversibility' suppress_bylines='yes' width_points='1' width_fudge='1' absolute_column_width='100,100,100,100,100,100,100,100,100,100,100' autofit_height='yes' orientation='landscape' autofilter='No' frozen_headers='3' center_horizontal ='yes '); proc report;.... ods gtagsets.excelxp close; ods listing close; right now I'm using a vbscript kicked off by sas to convert the xml to xls Dim xlApp, xlWkb Set xlApp = CreateObject("excel.application") set fs = CreateObject("Scripting.FileSystemObject") SourceFolder="\\srv01\Reports\Reports\" TargetFolder="\\srv01\Reports\Reports\" for each file in fs.GetFolder(SourceFolder).files If Right(LCase(file.Name), 4) = ".xml" Then Set xlWkb = xlApp.Workbooks.Open(file) BaseName= fs.getbasename(file) FullTargetPath=TargetFolder & "\" & BaseName xlApp.DisplayAlerts=false xlWkb.SaveAs FullTargetPath, 51 xlApp.DisplayAlerts=true xlWkb.close wscript.sleep 5000 End If next fs.DeleteFile("\\srv01\Reports\Reports\\*.xml")
... View more