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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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