Hi , From the posts, I understand that logo could not be added to Excel file from SAS. Is that true? How can I add logo along with title on the output result. ODS LISTING CLOSE; OPTIONS DEVICE=ACTXIMG; ODS EXCEL FILE= "\\Path" Options(SHEET_INTERVAL='NONE' SHEET_NAME='REPORT' SHEET_LABEL='' ORIENTATION='LANDSCAPE' FITTOPAGE='YES' EMBEDDED_TITLES='YES' AUTOFILTER="1-4" FROZEN_HEADERS="5" ABSOLUTE_COLUMN_WIDTH='17,17,20,20' ROW_HEIGHTS='0,0,0,20,0,0,0'); goptions iback='\\path\ logo.jpg' /**ADD LOGO***/ imagestyle=fit vsize=.62in hsize=3.86in ; title1 H=2.7 justify=left bcolor=STB color=white "ABCDEF"; title2 H=2 justify=left bcolor=STB color=white "ABCD "; title3 H=2 justify=left bcolor=STB color=white" EFGH " ; PROC REPORT DATA=WORK.PREVENTION_PHYSICAL nowd style(report)=[borderstyle=solid bordercolor=black BACKGROUND=TRANSPARENT verticalalign=T] style(header)=[background=silver color=black fontfamily=calibri fontsize=3 textalign=L verticalalign=T borderstyle=solid bordercolor=black] style(column)=[fontfamily=calibri fontsize=2.8 textalign=L verticalalign=T borderstyle=solid bordercolor=black tagattr="format:ddmmmyyyy"]; columns Date_OF_Birth Student_ID LAST_NAME FIRST_NAME; define Date_OF_Birth / display "DOB" format=date9.; define Student_ID / display "Student ID"; define LAST_NAME/ display "LAST NAME"; define FIRST_NAME / display "FIRST NAME"; RUN; ODS EXCEL CLOSE; Thanks.
... View more