Hi all-- Does anyone know how to modify the style of a spanned header? So, how do you change the font, size, background color ect. Thanks! proc report data=All_Spec_Med_Qs_TotalScore nowd headline headskip style(column)={just=c font_size=11pt font_face= 'Arial Narrow'cellwidth=2in} style(header)={font_size=11 pt font_face= 'Arial Narrow' FONT_WEIGHT =BOLD background=cxcccccc}; column  ('Special Medical Review Overall Score' totalAwarded Total_Possible  Final_score) ; define Final_score / display style(column)={ cellwidth=2in}; run; ... View more

Hi all-- I'm having some trouble writing titles into 3 proc report statements which all appear on one page. Any advice on to add the titles in would be greatly appreciated. Thanks! title1 'Special Medical Review Total Score'; proc report data=All_Spec_Med_Qs_TotalScore nowd headline headskip style(column)={just=c font_size=11pt font_face= 'Arial Narrow'cellwidth=2in} style(header)={font_size=11 pt font_face= 'Arial Narrow' FONT_WEIGHT =BOLD background=cxcccccc}; column    totalAwarded Total_Possible  Final_score ; define Final_score / display style(column)={ cellwidth=1.8in}; run; title2  Special Medical Review Quality Score; proc report data=Spec_Med_Quality_Qs_TotalScore nowd headline headskip style(column)={just=c font_size=11pt font_face= 'Arial Narrow'cellwidth=2in} style(header)={font_size=11 pt font_face= 'Arial Narrow' FONT_WEIGHT =BOLD background=cxcccccc}; column totalAwarded Total_Possible  Final_score; define Final_score / display style(column)={ cellwidth=1.8in}; run; title3 Special Medical Review Compliance Score ; proc report data=Spec_Med_Comp_Qs_TotalScore  nowd headline headskip style(column)={just=c font_size=11pt font_face= 'Arial Narrow'cellwidth=2in} style(header)={font_size=11 pt font_face= 'Arial Narrow' FONT_WEIGHT =BOLD background=cxcccccc}; column totalAwarded Total_Possible  Final_score; define Final_score / display style(column)={ cellwidth=1.8in}; run ... View more

Hello all— I’m very new to creating graphs with SAS. Does anyone know of any very VERY easy to understand code examples/templates for these types of charts: 1. Trended bar charts 2. Numerical tables/Charts that easily show percent change in revenue by Month to Month and Year to Year. I have been searching all over the internet and I’m not sure what’s appropriate and the examples on the SAS site I found a little confusing.  I assume one of the trickier steps is organizing your dataset correctly before you make the chart.  Any help is greatly appreciated!!! ... View more

Hi— The code below produces a comment box in the header of an excel column. This is issue is, when the excel generates, the font size inside the box is too big and I need to make the size of the box bigger. Is this possible? Thanks! define Q1 / display style(header)={just=center background=yellow flyover= 'If the response to Question Q1 is NO (FASP is missing) then questions that depend on a FASP being available are skipped. Those skipped questions receive a 0 for the numerator which will decrease the total amount of points possible.'} style(column)={cellwidth=2in }; ... View more

Hi-- I have column with a bunch of records that indicate a rating level. The rating level is manually entered. Column Responses look like this: -2LOW  12,very high                                                                                                                     12-veryhigh   3,moderate    9,high- final risk rating very high  0-Low     risk score 11 LOW     I would like to try and clean up the responses. Is there a way to make a conditional format that does something like this?: If anywhere in the cell, there is a -2 = ‘Case Risk Rating: Low -2’ If anywhere in the cell, there is a 12 = ‘Case Risk Rating: Very High 12’ If anywhere in the cell, there is a 3 = ‘Case Risk Rating: Moderate 3’ If anywhere in the cell, there is a 9 = ‘Case Risk Rating: High 9’ If anywhere in the cell, there is a 0 = ‘Case Risk Rating: Low 0’ If anywhere in the cell, there is a 11 = ‘Case Risk Rating: Very High 11’ If anywhere in the cell, there is a LOW = ‘Case Risk Rating: Low’ 99=SKIPPED Thanks! ... View more

Hi-- I'm having issues with specifying column width in excel when using ODS  tagsets.msoffice2k_x and proc tabulate. Below I have two proc tabulate statements. The first only statement generates one question frequency table and the next statement generates several. This is done so titles can be placed in the appropriate place in the spreadsheet.  The column widths I’ve defined are not generating correctly for all tables (the heights seem to be). When I run the program for just the first proc tabulate statement (so close ODS after the first table) the column widths work but if I output multiple tables the column widths do not hold even though they are written into the code for each table – the tables end up being very wide. I’m trying to format the spreadsheet so all the tables fit and the excel file prints appropriately. Any help is aperciated-- data test;   infile datalines dlm=',' dsd;   input Program_Name $ question response; return; datalines; "Program1 ",1,1 "Program1 ",1,0 "Program1 ",1,1 "Program1 ",1,0 "Program1 ",1,1 "Program1 ",1,1 "Program1 ",1,1 "Program1 ",1,0 "Program1 ",1,1 "Program1 ",1,0 "Program1 ",1,1 "Program1 ",1,1 "Program1 ",1,1 " Program2 ",1,1 " Program2 ",1,1 " Program2 ",1,0 " Program2 ",1,1 " Program2 ",1,1 " Program2 ",1,0 " Program2 ",1,1; Run; ods listing close;   ods tagsets.msoffice2k_x file="Z:\SAS\SASTESTS\test.xls"       options(                scale="100"                margin=".1in .1in .1in .1in"                print_header_margin=".2in"                print_footer_margin=".2in"                orientation="portrait"                papersize="legal" ods escapechar='^'; proc tabulate data=test (where=(question in('Q16a'))) style=[background=white foreground=black  font_face='Arial Narrow' font_size=10.5pt just=c cellwidth=.6in]; title1 "^S={font_face='Arial Narrow' font_weight=bold font_size=12pt} TITLE"; title2 "^S={font_face='Arial Narrow' font_weight=bold font_size=12pt} TITLE"; class question program_name / style={font_face='Arial Narrow' font_weight=bold font_size=11pt cellheight=50 }; class Responce / order=formatted style={font_face='Arial Narrow' font_weight=bold font_size=11pt cellwidth=.6in}; classlev question /style=[font_face='Arial Narrow' font_size=11pt]; classlev  program_name /style={font_face='Arial Narrow' font_size=10pt cellwidth=.6in cellheight=.4in just=l}; classlev Responce /style={font_face='Arial Narrow' font_size=11pt  }; table Question=' ', program_name =' ' all='Overall Agency Totals', Responce=' '*(n='Count'*f=best8. pctn='%'*f=p.) n='Count Total' pctn='% Total' *f=p. /style={font_face='Arial Narrow' font_size=11pt cellwidth=.6in} row=float  box={label='Count^{newline 1}Overall^_%' style={font_face='Arial Narrow' font_size=10pt font_weight=bold cellwidth=.6in}}; format question $ques.; format responce $resp.; keyword n pctn  / style=[font_weight=bold foreground=black  font_face='Arial Narrow' font_size=10pt just=c]; keyword all/ style=[font_weight=bold foreground=black  font_face='Arial Narrow' font_size=10pt just=l]; title; run; /*when I close ODS the column formatting does not hold*/ proc tabulate data=want (where=(question in('Q16b', 'Q17','Q18','Q19','Q22','Q23', 'Q23','Q23a','Q24','Q25','Q26'))) style=[background=white foreground=black  font_face='Arial Narrow' font_size=10.5pt just=c]; class question program_name / style={font_face='Arial Narrow' font_weight=bold font_size=11pt cellheight=50 }; class Responce / order=formatted style={font_face='Arial Narrow' font_weight=bold font_size=11pt}; classlev question /style=[font_face='Arial Narrow' font_size=11pt]; classlev  program_name /style={font_face='Arial Narrow' font_size=10pt cellwidth=.6in cellheight=.4in just=l}; classlev Responce /style={font_face='Arial Narrow' font_size=11pt  }; table Question=' ', program_name =' ' all='Overall Agency Totals', Responce1=' '*(n='Count'*f=best8. pctn='%'*f=p.) n='Count Total' pctn='% Total' *f=p. /style={font_face='Arial Narrow' font_size=11pt cellwidth=.6in } row=float  box={label='Count^{newline 1}Overall^_%' style={font_face='Arial Narrow' font_size=10pt font_weight=bold cellwidth=.6in}}; format question $ques.; format responce1 $resp.; keyword n pctn  / style=[font_weight=bold foreground=black  font_face='Arial Narrow' font_size=10pt just=c]; keyword all/ style=[font_weight=bold foreground=black  font_face='Arial Narrow' font_size=10pt just=l]; run; /*when I close ODS the column formatting does not hold*/ ods listing; ods _all_ close; ... View more

Hi all-- I was just wondering if someone could tell me what the differences between/ pros and cons of  MSOFFICE2K  vs tagsets.excelxp when creating ecxel spreadsheets/workbooks. Thank you-- ... View more

Hi all-- I have a proc transpose question. I would like to go from this: Year Office Safey Well-Being Admin Support staff trai FY11 Office1 .90 .67 .78 .99 To this:            Year FY11 Office Office1 Safey 0.9 Well-Being 0.67 Admin Support 0.78 staff training 0.99 I have been having a little trouble. proc transpose data=have; by var id run; Every combo I try  does not seem to work. Any help is greatly appreciated. Thanks ... View more