Updating excel file (adding spreadsheet ) using ODS

[deleted_user]

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)

sheet1:proc freq output
sheet2:proc tabulate output
sheet3:proc print output

Waiting for the valuable replies.

Thanks Inadvance.

[andreas_lds]

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.

[Peter_C]

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 .

[deleted_user]

Thanks for reply.

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

Thanks.

[Peter_C]

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.