this is what i am doing but when the excel sheet opens up the title is there but when i open a new sheet in that workbook the title is not there ods tagsets.ExcelXP options( embedded_titles='yes' embedded_footnotes='yes' frozen_headers='4' frozen_rowheaders='no' sheet_name='NotonProblemlist' sheet_interval='table' autofit_height='yes' absolute_column_width='25,25,25,25,25,25,25,25' rowcolheadings='yes' Pages_FitWidth = '1' Pages_FitHeight='100' FitToPage = 'yes' ORIENTATION= 'LANDSCAPE' ); Proc report data=Final(where=(trim(left(ID)) = trim(left(&ID)))) split='^' contents="" /*style=seaside*/; TITLE1 JUSTIFY=left height=14pt color=white ''; TITLE2 JUSTIFY=left height=14pt COLOR=red bold "Title"; TITLE3 JUSTIFY=LEFT HEIGHT=12PT color=blue bold italic "Title2"; TITLE4 JUSTIFY=LEFT HEIGHT=12PT color=blue bold italic "title3";
... View more