BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
pessi
Obsidian | Level 7

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;

 

1 ACCEPTED SOLUTION

Accepted Solutions
pessi
Obsidian | Level 7

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

View solution in original post

4 REPLIES 4
Vince_SAS
Rhodochrosite | Level 12

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
Obsidian | Level 7

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
Rhodochrosite | Level 12

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
Obsidian | Level 7

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

sas-innovate-2024.png

 

Time is running out to save with the early bird rate. Register by Friday, March 1 for just $695 - $100 off the standard rate.

 

Check out the agenda and get ready for a jam-packed event featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events. 

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 871 views
  • 0 likes
  • 2 in conversation