Help using Base SAS procedures

Output in Excel with 10 lines gaps

Reply
Contributor
Posts: 66

Output in Excel with 10 lines gaps

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 .
Super User
Posts: 9,681

Re: Output in Excel with 10 lines gaps

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]
Ask a Question
Discussion stats
  • 1 reply
  • 92 views
  • 0 likes
  • 2 in conversation