topic Re: proc report in SAS Procedures

proc report

knveraraju91 — Wed, 13 Jan 2016 21:42:07 GMT

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;

Re: proc report

Ksharp — Thu, 14 Jan 2016 01:45:57 GMT

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;

Re: proc report

knveraraju91 — Thu, 14 Jan 2016 02:13:57 GMT

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

Re: proc report

Ksharp — Thu, 14 Jan 2016 02:24:30 GMT

Remove

/style(lines)={backgroundcolor=yellow};

Re: proc report

knveraraju91 — Thu, 14 Jan 2016 02:47:22 GMT

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.

Re: proc report

Reeza — Thu, 14 Jan 2016 02:52:33 GMT

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.

Re: proc report

Ksharp — Thu, 14 Jan 2016 03:04:16 GMT

OK.

dummy='\brdrt\brdrs ';

And don't forget :

compute after grp/style={protectspecialchars=off};

Updated

Re: proc report

knveraraju91 — Thu, 14 Jan 2016 03:15:29 GMT

Thank you all. It worked.