Hi Cynthia,
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.
Please advice.
Thanks,
Jag
Hi:
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.
cynthia
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 ' ';
endcomp;
run;
ods _all_ close;
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...
Thank you!
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.