@Jyuen204 wrote:
If I change it to an XML file format, it sends me a file with *.xml and I do not want that either.
I tried using ODS EXCEl instead of ODS EXCELXP and that did not work and still generated the same error.
I would use the XLSX option but I do not know why all of my formatting options are thrown out the window. Unless there is a completely different set of syntax required to format each column differing from what i coded for XLS...
ods tagsets.ExcelXP options(sheet_interval="none" sheet_name='Monthly Summary Report' AUTOFIT_HEIGHT="yes" absolute_column_width='43,9,9,9,9,9,9');
...
ods tagsets.ExcelXP close;
You didn't close your ODS EXCEL file properly in the code you posted or specify the options.
Change them all to ODS EXCEL and ensure the names are the same in the new tagset.
The options are listed here and most seem to be valid, except AUTOFIT_HEIGHT.
ods excel options(sheet_interval="none" sheet_name='Monthly Summary Report' absolute_column_width='43,9,9,9,9,9,9');
ods excel close;
https://documentation.sas.com/?docsetId=odsug&docsetTarget=p09n5pw9ol0897n1qe04zeur27rv.htm&docsetVersion=9.4&locale=en#p0258wnlz15ubrn1vqfalp6l4hjz
... View more