yes, that's correct. but that code is working like it should, its not the ods tagsets.excelxp that is the problem. but you're right, that sheet_interval might not be valid for tagsets.excelxp, and is only working because of sheet_name='#BYVAL(fullknavn)' this code is the problem: ods excel options(sheet_interval='bygroup' sheet_name='#BYVAL(fullknavn)'); proc report data=kommuner_&f_nr. headline headskip nowindows noalias; column ("#BYVAL(fullknavn)" "&ar_input." '--'); by fullknavn; proc report doesn't resolve #BYVAL for column, it just prints #BYVAL(fullknavn). this is only a problem when i use ods excel, not ods tagsets.excelxp.
... View more