topic Re: Ods excel proc print two tables side by side in ODS and Base Reporting

Ods excel proc print two tables side by side

sascode — Thu, 12 May 2022 10:07:24 GMT

Hi,
I do have two tables, a and b. For comparison purposes, I need to export them in excel in same sheet but horizontally(side by side)
Trying with "start_at" option, it prints first table at specified Location using "start_at" but for the second table this option seems not to work.
Any help?

Re: Ods excel proc print two tables side by side

PaigeMiller — Thu, 12 May 2022 10:11:27 GMT

I'm pretty sure you cannot do this in ODS EXCEL.

Re: Ods excel proc print two tables side by side

Ksharp — Thu, 12 May 2022 10:12:01 GMT

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

NOTE: to use it , you need setup it firstly .
"to use this tagset, save the file msoffice2k_x.sas (Updated October 2015) to your computer and read Note 32394: Installing and Storing Updated Tagsets."

Re: Ods excel proc print two tables side by side

sascode — Thu, 12 May 2022 10:15:35 GMT

Thank you.

Re: Ods excel proc print two tables side by side

sascode — Thu, 12 May 2022 10:16:40 GMT

Thank you, I will try.

Re: Ods excel proc print two tables side by side

sascode — Fri, 13 May 2022 12:26:19 GMT

Hi,
Does it allow to print table a in sheet1 and table b in sheet 2 in same workbook?

Re: Ods excel proc print two tables side by side

Ksharp — Sat, 14 May 2022 05:06:10 GMT

Yes. I think so. Check option "sheet_interval=" . I remembered @Reeza has already answered it yesterday .