Need to print two datasets side by side in one excel sheet

[vikaskubde]

I have 2 tables and I need to export both tables in same worksheet side by side, not one below another.

I used sheet_interval='name
It gives me the result one below another, however I need output side by side in same sheet.

I also tried with start_at option as well, but not getting the desire output.

[data_null__]

show the code

[vikaskubde]

Start_at= option does not seem to be working?

Is there anyway it can be done in ODS Excel? Please let me know. Any help will be very much appreciated.

Thank you, vikas

[vikaskubde]

Ods excel file='d:/report.xlsx';
Ods excel options(sheet_name='one' sheet_interval='none');
Proc print data=class;
Run;
Ods excel options(sheet_name='two' start_at='4,5')
Proc print data=cars;
Run;
Ods excel close;

[Reeza]

ODS EXCEL doesn't support tables side by side.

You can merge the tables if you want and then try and display but its still a bit wonky. Feel free to add it in under ballotware as a feature suggestion.

[data_null__]

From the documentation

Tip	This option cannot be changed in the middle of a sheet.

[vikaskubde]

So is there any option to print two data sets in same excel sheet side by side.

[Reeza]

I think ODS HTML or ODS MSOFFICE2K but they generate an HTML/XML files. Unfortunately I don't know of a simple SAS only solution at this moment.

If I need reports like that I usually build an Excel template, link the data to source tables in other worksheets (same workbook) and then I export out and replace the source data and the tables update automatically.