BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
HitmonTran
Pyrite | Level 9

I am using the BY statement in proc report  but it's display the BY variables in the titles that I don't want.  I tried using title10="  "; but it still display. 

How do I get rid of it (see the red circle in screenshot below)?

 

 

HitmonTran_0-1642020643344.png

 

 title8 j=l "Laboratory Parameter: #byval2";
  title9 height=9pt j=l "Treatment Group: &trt";

    proc report data=final nowindows spacing=1 headskip headline split='|' spanrows;
      by trtgrp param;

      column  avisitn avisit atoxgrn lbtox (/*"^S={borderbottomcolor=black borderbottomwidth=1} Baseline Result"*/'Baseline Result' col1-col5);
 
	  define avisitn   / order noprint;
	  define avisit    / group " " style(column)={asis=on width=2.8in just=left} style(header)={just=center};
	  define atoxgrn   / order noprint;
	  define lbtox     / order " " style(column)={width=1.4in just=left} style(header)={just=left};
	  define col1      / display "Normal" style(column)={width=.9in just=center} style(header)={just=center};
	  define col2      / display "Grade 1" style(column)={width=1.2in just=center} style(header)={just=center};
	  define col3      / display "Grade 2" style(column)={width=1.2in just=center} style(header)={just=center};
	  define col4      / display "Grade 3" style(column)={width=1.2in just=center} style(header)={just=center};
	  define col5      / display "Grade 4" style(column)={width=1.2in just=center} style(header)={just=center};
 

	 compute after avisitn;
	     line @1 " ";
	  endcomp; 
 
  run;

 

1 ACCEPTED SOLUTION

Accepted Solutions
Tom
Super User Tom
Super User

So not in the user defined titles but in a separate BY LINE?

Use the option NOBYLINE.

View solution in original post

2 REPLIES 2
PaigeMiller
Diamond | Level 26
title;

This gets rid of all titles.

 

Alternatively, you could just remove the specific titles you don't want. Depending on the user interface you are using, you could access them individually; in base SAS you type title into the text bar at the top right and modify the titles individually.

--
Paige Miller
Tom
Super User Tom
Super User

So not in the user defined titles but in a separate BY LINE?

Use the option NOBYLINE.

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
  • 2 replies
  • 967 views
  • 1 like
  • 3 in conversation