Output in Excel with 10 lines gaps

sas_ — Wed, 19 May 2010 06:03:40 GMT

Hi i am having 5 datasets i want to print them by using ods html in to same sheet.
But i want 10 lines gap between each datasets .

Re: Output in Excel with 10 lines gaps

Ksharp — Wed, 19 May 2010 12:30:15 GMT

You can try this.
It is a little trick.

[pre]
ods listing close;
ods html file="d:\download\whole.xls" style=sasweb;

title1 ' ';
title2 ' ';
title3 ' ';
title4 ' ';
title5 ' ';
title6 ' ';
title7 ' ';
title8 ' ';
title9 ' ';
title10 ' ';/*or only just title10 ' '; */

proc print data=sashelp.class ;
run;
proc print data=sashelp.company;
run;
proc print data=sashelp.library;
run;
ods html close;
ods listing;
[/pre]

topic Output in Excel with 10 lines gaps in SAS Procedures

Output in Excel with 10 lines gaps

Re: Output in Excel with 10 lines gaps