10-12-2006 01:42 PM
10-12-2006 03:25 PM
11-04-2015 08:39 AM
Thank you for your response to this questions. I have got a similar scenario today and had to display a blank row after every subject. I followed your approach of using the compute after and it was working, however
i am get
ting two blank rows after every subject in the excel output.
compute after grp; line ' '; endcomp;
Could you please let me know the reason for it. It should have displayed only one blank row.
11-04-2015 12:54 PM
Adding your new comment to a very, very old post is not a good idea. I missed your new posting in the middle of all the previous posts. It would be better to start a new post and just include a link to the older post.
Since you only posted 3 lines of code and did not indicate your destination of interest (how you were getting output to Excel -- ODS HTML, ODS MSOFFICE2K, ODS TAGSETS.EXCELXP, etc) or the rest of your code, it is nearly impossible to make a constructive comment or suggestion.
But if I want to put a blank line after EVERY name in a subset from SASHELP.CLASS for example, I do NOT need a "helper" variable at all. See this example. When I run this example, I only get 1 blank line under every name in my subset.
ods html file='c:\temp\blank.html';
ods tagsets.excelxp file='c:\temp\blank.xml' style=htmlblue;
proc report data=sashelp.class(obs=5);
column name age sex height weight;
define name / order;
compute after name;
line ' ';
ods _all_ close;
10-02-2016 06:28 PM
Could you please answer my question? It is posted here: https://communities.sas.com/t5/ODS-and-Base-Reporting/Double-line-at-specific-location-in-proc-repor...
09-12-2007 06:25 PM