topic Re: Updating excel file (adding spreadsheet ) using ODS in ODS and Base Reporting

Updating excel file (adding spreadsheet ) using ODS

deleted_user — Wed, 24 Jun 2009 11:00:01 GMT

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.

Re: Updating excel file (adding spreadsheet ) using ODS

andreas_lds — Wed, 24 Jun 2009 11:54:47 GMT

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.

Re: Updating excel file (adding spreadsheet ) using ODS

Peter_C — Wed, 24 Jun 2009 11:55:58 GMT

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 .

Re: Updating excel file (adding spreadsheet ) using ODS

deleted_user — Wed, 24 Jun 2009 12:15:02 GMT

Thanks for reply.

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

Thanks.

Re: Updating excel file (adding spreadsheet ) using ODS

Peter_C — Wed, 24 Jun 2009 12:51:27 GMT

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.