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.
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.
Ready to level-up your skills? Choose your own adventure.