BookmarkSubscribeRSS Feed
aarathi
Calcite | Level 5

While using the Analysis variable in SAS, this variable heading automatically displayed in report. how to remove this heading. This is My code : 

 

proc report data=Work.Channelsummary Spanrows style(header)=[bordercolor=BLACK 
		background=#97291E foreground=white font=(zurichbt, 8pt) 
		font_weight=bold ] style(report)=[bordercolor=black borderwidth=1pt 
		font=(zurichbt, 8pt)] style(column)=[background=#FFFFFF bordercolor=#000000 
		font=(zurichbt, 8pt) vjust=middle 
		cellheight=.10in ] style(summary)=[font_face=White] center split='_';
	column('State & RH Channel Wise Summary :' Zone RHName)(('Total Allocation' 
		ChannelAllocation1, TotalCount))('Resolved' ChannelAllocation1, 
		TRCount)('Part Payment' ChannelAllocation1, PPCount)('Resolution %' 
		ChannelAllocation1, Resolved);

	/*row ('' Resolution)('TOTAL' COUNT ELB); */
	define Zone / 'Zone' group;
	define RHName / 'RH Name' group;
	define ChannelAllocation1 / group across;
	define TotalCount / analysis sum Width=5 center;
	define TRCount / analysis sum Width=5 center;
	define PPCount / analysis sum Width=5 center;
	rbreak before / summarize;
	compute before;

		if _break_='_RBREAK_' then
			do Zone="Total";
				call define (_row_, 'style', 'style=[background=CXFF8000 foreground=Black bordercolor=black font=(ZurichBt,8pt)font_weight=bold]');
			end;
	endcomp;
	define ChannelAllocation1 / across;
	define Resolved / analysis format=Percent11.0 center;
run;

title1;
5 REPLIES 5
Kurt_Bremser
Super User

Please use the "little running man" symbol to open a window for entering SAS code, and copy/paste the code there from EG (or Studio). The way you posted your code, it has no formatting at all.

Kurt_Bremser
Super User

Formatted code:

proc report
  data=Work.Channelsummary
  Spanrows
  style(header)=[
    bordercolor=BLACK
    background=#97291E
    foreground=white
    font=(zurichbt,8pt)
    font_weight=bold
  ]
  style(report)=[
    bordercolor=black
    borderwidth=1pt
    font=(zurichbt,8pt)
  ]
  style(column)=[
    background=#FFFFFF
    bordercolor=#000000
    font=(zurichbt,8pt)
    vjust=middle
    cellheight=.10in
  ]
  style(summary)=[
    font_face=White
  ]
  center
  split='_'
;
column
  ('State & RH Channel Wise Summary :' Zone RHName)
  (('Total Allocation' ChannelAllocation1,TotalCount))
  ('Resolved' ChannelAllocation1,TRCount)
  ('Part Payment' ChannelAllocation1,PPCount)
  ('Resolution %' ChannelAllocation1,Resolved)
;
/*row ('' Resolution)('TOTAL' COUNT ELB); */
define Zone / 'Zone' group;
define RHName / 'RH Name' group;
define ChannelAllocation1 / group across;
define TotalCount / analysis sum Width=5 center;
define TRCount / analysis sum Width=5 center;
define PPCount / analysis sum Width=5 center;
rbreak before / summarize;
compute before;
  if _break_ = '_RBREAK_'
  then do;
    Zone="Total";
    call define (_row_,'style', 'style=[background=CXFF8000 foreground=Black bordercolor=black font=(ZurichBt,8pt)font_weight=bold]' );
  end;
endcomp;
define ChannelAllocation1 / across;
define Resolved / analysis format=Percent11.0 center;
run;
title1;

Could you please supply a piece of the report and indicate which element you want removed?

aarathi
Calcite | Level 5

screenshot.png
aarathi
Calcite | Level 5

screen shot attached.


screenshot.png
How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 5 replies
  • 2451 views
  • 0 likes
  • 2 in conversation