I have the following let statements that are causing an error 22-322: %let Excel_Sheet_Name = cat("'",&Fleet_Type, " P/N 12 MOnth Rolling'"); %let Excel_File_Name = cat("'",&Fleet_Type, " MTBR.xml'"); 44 ods tagsets.excelxp path='\\Cmhprdfps22\data\MAINTENANCE\Reliability\Program Analyst Data\Dave P\SAS AutoBatch Exports\' 45 file=&Excel_File_Name 46 style=Grayscaleprinter; NOTE: Line generated by the macro variable "EXCEL_FILE_NAME". 46 cat("'","CE-560XL", " MTBR.xml'") 2 The SAS System 10:54 Tuesday, August 21, 2018 ___ 22 76 ERROR 22-322: Syntax error, expecting one of the following: DYNAMIC, NO_BOTTOM_MATTER, NO_TOP_MATTER, TITLE, URL. ERROR 76-322: Syntax error, statement will be ignored. 47 48 ods tagsets.ExcelXP options(sheet_label=' ' sheet_name=&Excel_Sheet_Name autofilter='yes'); NOTE: Line generated by the macro variable "EXCEL_SHEET_NAME". 48 cat("'","CE-560XL", " P/N 12 MOnth Rolling'") ___ 22 202 ERROR 22-322: Expecting a quoted string. ERROR 202-322: The option or parameter is not recognized and will be ignored. thanks for the help.
... View more