BookmarkSubscribeRSS Feed
sascode
Quartz | Level 8
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?
6 REPLIES 6
PaigeMiller
Diamond | Level 26

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

--
Paige Miller
Ksharp
Super User
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."
sascode
Quartz | Level 8
Thank you, I will try.
sascode
Quartz | Level 8

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

Ksharp
Super User

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

Catch up on SAS Innovate 2026

Nearly 200 sessions are now available on demand with the SAS Innovate Digital Pass.

Explore Now →
How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 6 replies
  • 3749 views
  • 0 likes
  • 3 in conversation