I am adding up tot_osha and per_osha using rbreak summarize. However, I would like to change the sum of per_osha to 100. How do I accomplish this? Thank you. proc report data=csbu3 nowd contents="Claims" out=test style(header)=[font_weight=bold background=CX90D9D7 /*very light bluish green*/]; options missing=''; column ydoi1 task1 tot_osha per_osha; define ydoi1 / noprint; define task1 / 'Task'; define tot_osha / analysis "2011 YTD Total" style(column)={background=CXE599A7}; define per_osha / analysis "% of 2011 Total" style(column)={background=orange}; rbreak after / summarize; compute per_osha;   if _break_="_RBREAK_" then per_osha=100; endcomp; run; ... View more

I would like to change the background to yellow when ydoi=2010. ydoi equals 2010 and 2011. Any ideas? Thank you. proc report data=month_tots1 nowd contents="Claims" out=test style(header)=[font_weight=bold background=CX90D9D7 /*very light bluish green*/]; options missing=''; column mdoi ydoi, (msd_tot o_tot); define mdoi / group "Month" format=mof. order=data style(column)={just=l}; define ydoi / across "" format=ydoif. order=data; define msd_tot / 'MSD'; define o_tot / 'OD'; compute mdoi;   if mdoi=. then call define(_row_,"style","style=[background=CXE599A7]"); endcomp; run; ... View more

Currently the header background color (ie CXBBBFAC) is only shown for ydoi1, clm_num, bop_grp, and task. Does anyone know why the header background color is not being displayed for oergo1, msd1, and fall1? Everything else works as expected. proc format; value ydoif 2010="2010"              2011="2011 YTD" ; value $colorf 'Yes'='Yellow' ; run; ods tagsets.excelxp file="C:\file.xls" style=journal options(frozen_headers='1'       autofit_height='yes'       absolute_column_width='8,9,18,14,8,6,9'    sheet_interval='none' sheet_name='Corp'    embedded_footnote='yes') ; proc report data=class5 nowd contents="Claims" out=test style(header)=[font_weight=bold background=CXBBBFAC /*yellowish grey*/]; options missing=''; column ydoi1 clm_num task bop_grp oergo1 msd1 fall1; define ydoi1 / '' format=ydoif. style(column)={font_weight=bold just=l}; define clm_num / 'Claim #' width=14 style(column)={just=l}; define task / 'Task'; define bop_grp / 'Body Part'; define oergo1 / 'Office' style={background=$colorf.}; define msd1 / 'MSD' style={background=$colorf.}; define fall1 / "STF" style={background=$colorf.}; compute clm_num;   if clm_num = "" then call define(_row_,"style","style=[background=CXE599A7]" /*light pink*/); endcomp; run; ... View more

I sorted by id and date (mm/dd/yy). I need to create a running count by id and job (while keeping the dates in order). How do I create the variable count? id date job count 1 1/1/10 x 1 1 1/15/10 y 2 1 2/2/10 y 2 1 4/1/10 x 3 1 5/1/10 x 3 1 4/2/11 z 4 2 4/3/09 x 1 2 4/6/09 m 2 2 5/8/09 m 2 2 6/8/10 m 2 2 7/8/10 y 3 2 7/8/11 m 4 2 8/8/11 m 4 ... View more