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)?
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;
So not in the user defined titles but in a separate BY LINE?
Use the option NOBYLINE.
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.
So not in the user defined titles but in a separate BY LINE?
Use the option NOBYLINE.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: