Hi All, We have a report with column header labels a little longer than the usual (we have column descriptions in multiple languages), so we are using angular headers to accommodate the lengthy labels. (using tagattr="rotate=75") option. we also want to align the text to center both vertically and horizontally using just and vjust options, but we are not able to get the desired output. Seems the tagattr option is overriding the other style statements. Please find the sample code snippet and report snapshot (actual and required output) . Is there any other way round to get the desired effect. Thanks in advance. Regards, Chandra Sample Code: ods path work.templat(update) sashelp.tmplmst(read); proc template; define style styles.myreportExcel; parent = styles.sansPrinter ; style fonts from fonts /         'TitleFont2' = ("Arial",14pt,Bold Italic)                        'TitleFont' = ("Arial",11pt,Bold)                    'StrongFont' = ("Arial",12pt,Bold)                                'EmphasisFont' = ("Arial",12pt,Italic)                            'FixedEmphasisFont' = ("Courier",11pt,Italic)                                'FixedStrongFont' = ("Courier",11pt,Bold)                                    'FixedHeadingFont' = ("Courier",11pt,Bold)                                    'BatchFixedFont' = ("Courier",9pt)                            'FixedFont' = ("Courier",11pt)                                                'headingEmphasisFont' = ("Arial",9pt,Bold Italic)                'headingFont' = ("Arial",9pt,Bold)                              'docFont' = ("Arial",10pt)  ;   style angle_header from header /   font_size = 9pt   just = center   vjust = center   tagattr = 'rotate:75'     ; end; run; quit; filename dash_rpt "&rpt_output./class_report..xls"; options center missing=''; title; ods html close; ods listing close; ods tagsets.excelxp file=dash_rpt style=styles.myreportExcel options( Sheet_Name="class" row_heights="40,15" row_height_fudge = "15" default_column_width="7.5, 5,7.5, 5.5" width_fudge='0.8' Orientation='Portrait' Embedded_Titles='Yes' skip_space='1,1,0,0,1' ); TITLE1 J=LEFT H=12PT BOLD "Student Report"; TITLE2 J=L  H=12PT BOLD  " Week 08 (2012-02-22 to 2012-02-28)"; PROC REPORT DATA= sashelp.class NOWD MISSING CONTENTS='' SPLIT="*" STYLE(HEADER)={BACKGROUND=white FOREGROUND=black font_size = 9pt vjust=center JUST=CENTER}; COLUMN  Name Sex Age Height Weight;   DEFINE Name/ STYLE(COLUMN)=[JUST=Left] style(header)=angle_header; DEFINE sex / STYLE(COLUMN)=[JUST=C] style(header)=angle_header; DEFINE age / DISPLAY style(header)=angle_header; DEFINE height / style={tagattr="format:###,###,###"} style(header)=angle_header DISPLAY; DEFINE weight/ style={tagattr="format:###,###,###"} style(header)=angle_header  DISPLAY; COMPUTE height;       IF height gt 60 THEN DO;         CALL define("height",'style','style={background=lightgrey font_weight=bold }') ;         END;     ENDCOMP;   COMPUTE weight ;       IF weight gt 100  THEN DO;         CALL define("weight",'style','style={background=lightgrey font_weight=bold }') ;     END;   ENDCOMP; label name="Student Name"     sex ="Gender"     Age ="Age of /* the student"     height = "Height of /* the student"     weight= "Weight of  /* the student"     ;     run; title1; title2; ods tagsets.Excelxp close; ods html close; ods listing; PROC TEMPLATE;     DELETE styles.myreportExcel; RUN; ... View more

Hi all, I am creating a trending report using Proc Tabulate procedure. The class variables have many levels in it. I am trying to add the level value to the summary variable label. For example, if I want to showcase total attended hours for boys and girls separately over various weeks and years. I would like to keep my total hours label as week1 total hours, week2 total hours , week3 total hours and year to date values as 2011 year to date, 2012 year to date etc., PROC TABULATE DATA=attendance ; class gender/ MISSING; class  WEEK/DESCENDING; class Year; TABLE attendance_status all='Total', (YEAR=''* (Gender=''*(WEEK='' all='Total') all="Year to Date")) *(n='attended_hours' *f=comma20. colpctn='attendance_PERCENT' *f=PCTFMT.); RUN; currently I am getting a static 'Total' and 'Year to Date' labels for week and Year columns respectively. Is there a way to add the variable value to the auto calculated summary variables in proc tabulate (something like autoname option in proc Means procedure)? Thank you very much in advance. Cheers, Chandra ... View more