The SAS Output Delivery System and reporting techniques

Updating excel file (adding spreadsheet ) using ODS

Reply
N/A
Posts: 0

Updating excel file (adding spreadsheet ) using ODS

Hi all,

I want to generate a excel file with 3 sheets.Each sheet will have output from each program(i have 3 programs).

So i tried with DDE ,but it is posting the data but not report(I.e output from any proc)

sheet1Smiley Tongueroc freq output
sheet2Smiley Tongueroc tabulate output
sheet3Smiley Tongueroc print output

Waiting for the valuable replies.

Thanks Inadvance.
Super Contributor
Posts: 262

Re: Updating excel file (adding spreadsheet ) using ODS

Have a look at the options for the excelxp tagset. Setting SHEET_INTERVAL to PROC and executing the three proc-steps within one ods-statement should create the requested layout.
Valued Guide
Posts: 2,175

Re: Updating excel file (adding spreadsheet ) using ODS

lots of ways with ODS, but I imagine your best start point would be http://support.sas.com/rnd/base/ods/odsmarkup/excelxp_demo.html .
N/A
Posts: 0

Re: Updating excel file (adding spreadsheet ) using ODS

Thanks for reply.

My problem is all my output are coming from different programs.

Thanks.
Valued Guide
Posts: 2,175

Re: Updating excel file (adding spreadsheet ) using ODS

have your different programs stop short of the "reporting" and add a final one that waits for your "non-reporting" programs to finish, then performs that final reporting stage.
If the "reporting" is too complex to place all in one, then use ODS DOCUMENT to collect the "reports" and PROC DOCUMENT to generate the ODS for excel, in one final job.
Ask a Question
Discussion stats
  • 4 replies
  • 118 views
  • 0 likes
  • 3 in conversation