Hello!
I am trying to put horizontal lines between subject identifiers in a RTF output and the following comes close:
compute before subjid / style={bordertopcolor=black bordertopwidth=3};
line '';
endcomp;
However, I want a solution that does not create an extra blank line inserted as this creates too much white space. Thanks in advance.
Hi:
Without seeing all your code or the style that you are using, it is hard to guess what the rest of your code looks like. But do you want something like the cyan-colored lines in the attached screenshot?
If so, instead of doing a COMPUTE before, try just using a COMPUTE for SUBJID with a CALL DEFINE statement to change the _ROW_ style attributes, as shown in the test code below.
cynthia
ods listing close;
options center orientation=portrait nodate nonumber
topmargin=1in bottommargin=1in
rightmargin=1in leftmargin=1in;
data test;
set sashelp.class;
subjid=catt(sex,age);
run;
title; footnote;
ods rtf file='c:\temp\bordertest.rtf' style=journal;
proc report data=test nowd;
column subjid name height weight;
define subjid / group ;
define name / order;
define height / sum;
define weight / sum;
compute subjid ;
if subjid gt ' ' then
call define(_row_,'style',
'style={bordertopcolor=cyan bordertopwidth=3}');
endcomp;
run;
ods rtf close;
Hi:
Without seeing all your code or the style that you are using, it is hard to guess what the rest of your code looks like. But do you want something like the cyan-colored lines in the attached screenshot?
If so, instead of doing a COMPUTE before, try just using a COMPUTE for SUBJID with a CALL DEFINE statement to change the _ROW_ style attributes, as shown in the test code below.
cynthia
ods listing close;
options center orientation=portrait nodate nonumber
topmargin=1in bottommargin=1in
rightmargin=1in leftmargin=1in;
data test;
set sashelp.class;
subjid=catt(sex,age);
run;
title; footnote;
ods rtf file='c:\temp\bordertest.rtf' style=journal;
proc report data=test nowd;
column subjid name height weight;
define subjid / group ;
define name / order;
define height / sum;
define weight / sum;
compute subjid ;
if subjid gt ' ' then
call define(_row_,'style',
'style={bordertopcolor=cyan bordertopwidth=3}');
endcomp;
run;
ods rtf close;
Great, thanks Cynthia.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.