topic Re: ODS EXCEL - LOGO in New SAS User

ODS EXCEL - LOGO

DLROW — Tue, 08 Jan 2019 17:23:12 GMT

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.

Re: ODS EXCEL - LOGO

Reeza — Tue, 08 Jan 2019 17:28:55 GMT

ODS EXCEL does support logos.

This paper goes over how to add a logo:

https://support.sas.com/resources/papers/proceedings16/SAS5642-2016.pdf

I think you need to use the macro included with the paper to include the logos though.

@DLROW wrote:

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.

Re: ODS EXCEL - LOGO

DLROW — Tue, 08 Jan 2019 17:39:56 GMT

Got the answer. It works now... I didn't add

proc gslide;
run; quit;

after image style..

ODS LISTING CLOSE;

proc gslide; /*Missed this*/
run; quit; /*Missed this*/
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 " ;

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;