Hi Cynthia,
I downloaded excelxp tagset. I now have the following code.
Is it possible to center the column "# of coils" to the center of the excel spreadsheet? I cannot select a column like you suggested above because I have other proc reports that will display on the same sheet with more columns which will then cause this first proc report to still look aligned to the left.
Also, my title does not display because it only displays to the width of the column "# of coils." If I make the cellwidth larger of the column I can get the full title to display. Any advice on this also?
GOPTIONS ACCESSIBLE; %LET RV=%SYSFUNC(APPSRV_HEADER(CONTENT-TYPE,APPLICATION/VND.MS-EXCEL)); %LET RV=%SYSFUNC(APPSRV_HEADER(CONTENT-DISPOSITION,ATTACHMENT; FILENAME="RUST_RPT_%sysfunc(today(),MMDDYY8.).XLS")); ODS PATH work.templat(update) sasuser.templat(read) sashelp.tmplmst(read); ods listing close;
ODS tagsets.excelxp file=_WEBOUT style=styles.journal_borders options(sheet_interval='none' sheet_name='Rust' embedded_titles='yes' orientation='portrait' suppress_bylines='yes');
proc report data=WORK.APPEND_TABLE_0038 nowd; column color no_of_coils ; TITLE1 f='Calibri' h=12pt "Rust Prevention Report: %TRIM(%QSYSFUNC(DATE(), NLDATE20.))"; TITLE2 f='Calibri' h=11pt "TPC Slit Coils"; TITLE3 f='Calibri' h=10pt "6-10 days: Yellow > 10 days: Red";
compute no_of_coils;
if color = 'yellow' then call define ('no_of_coils','style','style=[background=yellow]'); if color = 'red' then call define ('no_of_coils','style','style=[background=red]');
endcomp;
define no_of_coils / display '# of coils'; define color / display noprint;
; run;
... View more
