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.

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

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