topic Re: ods exce output report in SAS Programming

ods exce output report

JHE — Tue, 16 May 2017 16:38:15 GMT

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

Re: ods exce output report

PaigeMiller — Tue, 16 May 2017 17:02:45 GMT

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.

Re: ods exce output report

JHE — Tue, 16 May 2017 17:31:17 GMT

Attached.

Re: ods exce output report

PaigeMiller — Tue, 16 May 2017 17:51:26 GMT

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.

Re: ods exce output report

JHE — Tue, 16 May 2017 18:22:15 GMT

Thank you. Will do.

Re: ods exce output report

Ksharp — Wed, 17 May 2017 13:31:40 GMT

Here are some resource you can refer to .

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

Re: ods exce output report

JHE — Wed, 17 May 2017 13:58:29 GMT

Thank you reply to me.

will read and try.

Re: ods exce output report

Ksharp — Wed, 17 May 2017 14:14:56 GMT

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

Re: ods exce output report

JHE — Wed, 17 May 2017 14:42:53 GMT

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;

Re: ods exce output report

JHE — Thu, 18 May 2017 20:24:56 GMT

see atatch doc. Thank you.