Hi, I used the following code to get SAS output in Excel. Variable" Location " is already formatted. "By location" is used to create a seperate table for each location. Attached is the example for one of the tables created.You can see everything else (title, data, headers, ect) are in the right style (Times New Roman, 10pt) except for the text "LOCATION=Distance Education". Is there any way to change the style of "LOCATION=Distance Education" so it has Times New Roman as Font_Face and 10pt as Font_Size? proc template; define style styles.newstyle; parent = styles.minimal; style data/ background = white foreground = black font_style = Roman font_weight = medium font_size = 10pt font_face = "Times New Roman" textalign=center verticalalign=middle; style header/ background = white foreground = black font_style = Roman font_weight = medium font_size = 10pt font_face = "Times New Roman"; style systemtitle/ background = white foreground = black font_style = Roman font_weight = medium font_size = 10pt font_face = "Times New Roman" style table/ cellspacing=0 cellpadding=7 FRAME=BOX RULES=all borderwidth = 1pt END; RUN; ODS TAGSETS.EXCELXP FILE='C:\xxx\ODSOUTPUT.XML' STYLE=newstyle OPTIONS (sheet_interval='none' sheet_name='TEST' embedded_titles='on' FITTOPAGE='YES' ORIENTATION='LANDSCAPE'); PROC TABULATE DATA=xxx MISSING ORDER=FORMATED; CLASS FP TERM_CODE location; TABLE FP=' ' ALL='Total', TERM_CODE=' '*(N='#'*F=COMMA6. PCTN<FP ALL>='%'*F=COMMA6.1); FORMAT LOCATION LOCATION. TERM_CODE $TERM.; BY LOCATION; run; ODS TAGSETS.EXCELXP CLOSE;
... View more