I have 10 questions from a survey. Each question has possible values 1-5. I would like to create the following subscale averages: questions 1, 2 questions 3, 4, 5 questions 6, 7, 8, 9 questions 10 So, this means there would be a total of 4 means (mean1, mean2, mean3, mean4). Does anyone know how to do this with proc sql? Thank you. ... View more

When I set per_osha10.sum to 0.99 99% appears. However, when per_osha10.sum is set to 1.00 **% appears. I would like the output to show 100%. define per_osha10 / analysis format=percent5. style(column)={background=CXECEDEC cellwidth=1.5in}; rbreak after / summarize; compute per_osha10; if _break_="_RBREAK_" then per_osha10.sum=1.00; endcomp; Thank you. ... View more

The image does not appear when I use this line of code in my compute block "if per_osha11.sum<per_osha10.sum". However, if I change this line of my compute block to "if per_osha11.sum<20" the image shows up. I'm using ods pdf to output this table. Any ideas? Thank you. proc report data=task_tot5 nowd contents="Claims" out=test style(header)=[font_weight=bold background=CX90D9D7]; options missing='0'; column task1 tot_osha11 per_osha11 tot_osha10 per_osha10 ; define task1 / 'Task'; define tot_osha11 / analysis "Total 2011 YTD" style(column)={cellwidth=1in}; define per_osha11 / analysis "% of 2011 YTD Total" style(column)={cellwidth=1.1in}; define tot_osha10 / analysis "Total 2010" style(column)={background=CXECEDEC cellwidth=1in}; define per_osha10 / analysis "% of 2010 Total" style(column)={background=CXECEDEC cellwidth=1.1in}; rbreak after / summarize; compute per_osha11;   if task1 notin ("other*") then do;    if per_osha11.sum<per_osha10.sum then    call define (_col_,'style','style=[preimage="C:\GreenArrowDown.gif"]');   end;   if _break_="_RBREAK_" then per_osha11.sum=100; endcomp; run; ... View more

I'm currently receiving the following error for my "bar" variable. The max value of per_osha11 is 24. How do I fix this error? Thank you. ERROR: The width of bar is not between 1 and 98. Adjust the column width or line size. NOTE: This affects LISTING output. proc report data=task_tot3 nowd contents="Claims" out=test style(header)=[font_weight=bold background=CX90D9D7] style(report)=[frame=void rules=none cellpadding=1 cellspacing=0]; options missing='0'; column bar task1 tot_osha11 per_osha11; define task1 / 'Task'; define bar / '' style(column)=[cellwidth=75mm font_size=4pt font_face=webdings vjust=middle just=left cellpadding=0]; define tot_osha11 / analysis "Total 2011" style(column)={background=CXE599A7}; define per_osha11 / analysis "% of 2010 Total" style(column)={borderrightcolor=black borderrightwidth=1pt}; rbreak after / summarize; compute bar / char length=100;   barsize=round(per_osha11.sum*50);   if barsize gt 0 then   bar=repeat('67'x,barsize); endcomp; compute per_osha11;   if _break_="_RBREAK_" then per_osha11.sum=100; endcomp; compute tot_osha11;   if _break_="_RBREAK_" then call define(_row_,"style","style=[background=CXE599A7]");   if _break_="_RBREAK_" then task1="Total 2010 - 2011"; endcomp; run; ... View more

Excel has an option to add "data bars" (under Conditional Formatting) to tables. Does anyone know how to add "data bars" to a proc report "analysis" variable? I'm using tagsets.excelxp to output my proc report tables. proc report data=month_tots1 nowd contents="Claims" out=test style(header)=[font_weight=bold background=CX90D9D7]; options missing=''; column mdoi ydoi, (osha_tot); define mdoi / group "Month" format=mof. order=data style(column)={just=l}; define ydoi / across "" format=ydoif. order=data; define osha_tot / analysis 'Total'; run; Thank you. ... View more