Proc print of multiple datasets using stored process generating two blank lines b/n results in excel

[pessi]

Hi,

I have stored process which prints  (by using proc print)multiple datasets in excel. I see there are two blank lines between the results.

Is that two blank lines between  results is default behavior?

Do we have any option to get only one blank line between results?

Here is the sample code. I've called in excel through a stored process. The result is having two blank lines between outputs.

proc print data=sashelp.class noobs;

run;

proc print data=sashelp.cars noobs;

 run;

proc print data=sashelp.class noobs;

run;

[Vince_SAS]

Which ODS destination are you using?

ods Excel file= ... ;
  proc print ... ;
ods Excel close;

or

ods tagsets.ExcelXP file= ... ;
  proc print ... ;
ods tagsets.ExcelXP close;

Vince DelGobbo

SAS R&D

[pessi]

I am not using anything. Just the above code.

I saved the code in a stored process and called the stored process by opening excel sheet.

[Vince_SAS]

Check the SAS log and post what you see.  SAS Enterprise Guide or the SAS Add-in for Microsoft Office might be issuing the statements on your behalf.

Vince DelGobbo

SAS R&D

[pessi · Accepted solution]

I got answer from SAS Technical support. Thanks for your response.

Yes, two blank lines between between the results generated by a stored process is expected.

Break each PROC PRINT in your stored process into separate stored processes so you can place the results in the desired location separately.

Or if you have SAS Add-in for Microsoft Office 8.0, you can insert individual pieces of stored process results into a workbook in the desired location. Here are a few SAS Add-in for Microsoft Office 8.0 video tutorials just in case you are interested in how to insert individual pieces of reports into a workbook: https://video.sas.com/category/videos/version-8