I'm trying to dynamically set the Excel tab names for a series of proc reports.  I'm looking through a set of Departments using a macro to control the loop.  I was hoping that I could use the title of the proc report as the tab name but this does not seem to be an option.  If I could do something like   sheet_name = &title1 then it would work.  I tried feeding a macro variable to the sheet name but it looks like since the macro variable changes throughout the loop it doesn't work.   My structure is    ods Excel OPTIONS (embedded_titles='yes' ) ; ods escapechar='~'; %ShowUniversityLevel(); %callEmployeeBody(); %DepartmentsDisplay(); ods Excel close; ods Excel(id=VCU_Report_Printing1) close;   ... View more

For some reason this simple call of my proc report to change the orientation to landscape is staying is portrait.  Am I missing something?   OPTIONS orientation=landscape nodate; ods pdf file="/serverpath/my.pdf" ods escapechar='~'; /*proc report goes here*/ ods pdf close; ods pdf(id=VCU_Report_Printing1) close; ... View more