ods exce output report

[JHE]

ods excel format report,  two proc reports, but need side by side on the excel page. see attach format. how to ?  please advise if anyone knows.

Thank you

Joanne Jin

[PaigeMiller]

Can you show us a screen capture of your Excel output? I am reluctant (and most people are reluctant) to open Excel files or other executable files.

[JHE]

Attached.

[PaigeMiller]

I would create a SAS dataset which has this structure, including an empty column as a separator, and then use ODS EXCEL and PROC REPORT.

[JHE]

Thank you. Will do.

[JHE]

see atatch doc. Thank you.

[Ksharp]

Here are some resource you can refer to .

http://blogs.sas.com/content/sgf/2017/02/20/tips-for-using-the-ods-excel-destination/

[JHE]

Thank you reply to me.

will read and try.

Spoiler

[Ksharp]

http://support.sas.com/rnd/base/ods/odsmarkup/msoffice2k/index.html

[JHE]

I have tried  this methos before, it needs 'tagsets.msoffice2k_x',  it dose not working in our SAS EG envirement for unknow reason....  

If  it works woul dbe idealy and wonderful.

So far my system would not support this 'tagsets.msoffice2k_x'.

  Paneling

You can create simple paneling using the PANCOLS= option, which places tables and graphs side-by-side in the worksheet. You can you also add this with other options to enhance the presentation of the worksheet.

  ods tagsets.msoffice2k_x  file="c:\temp\trash\test\panels.xls"
      options(panelcols="3") style=normal;