Thanks for replying ChrisNZ, Proc export does work but I want to use the functionality of ODS Excel (as I want to format output with title etc.) like in below code. ods excel file="path/Report.xlsx"; ods excel options( sheet_name = 'Acct_Num&ABCD_BCD&ABC'); title1 "Report Monday"; proc report data=sashelp.cars; column _all_; run; title; ods excel close; In above code sheet name is getting trimmed to 'Acct_Num&ABCD_BCD&AB'.(20 Characters) If I use 'Acct_NumandABCD_BCDandABC' (25 Characters) is not getting trimmed. Need to know the reason behind this, Or any possible solution. Thanks.
... View more