I need to add a line after a group variable. The following code works. The line appears after all groups of observations. But I need it have only after first group of observations. How to write a code.Thanks.
compute after grp/style={protectspecialchars=off};
line '\brdrt\brdrs ';
endcomp;
This kind of question should be posted at another forum ODS and Base Reporting Cynthia is there .
Here is an example:
proc report data=sashelp.class nowd;
column age weight;
define age/group;
define weight/display;
compute after age/style(lines)={backgroundcolor=yellow};
n+1;
len=ifn(n=1,20,0);
dummy=' ';
line dummy $varying20. len;
endcomp;
run;
Thanks for your answer. It is worked. But it results in a wide line with yellow background. I need to keep normal line. Can you please modify the code. Thanks
??
Remove
/style(lines)={backgroundcolor=yellow};
I am sorry that I am asking you again. I need a line ___________________________________________ like this. How to get this line after first group of observations. Thanks.
Just a guess, but try combining your original code and @Ksharp code. Basically keep the n, which counts the number of groups and then add an if to your line statement.
OK.
dummy='\brdrt\brdrs ';
And don't forget :
compute after grp/style={protectspecialchars=off};
Updated
Thank you all. It worked.
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.