topic Re: Need to print two datasets side by side in one excel sheet in ODS and Base Reporting

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

vikaskubde — Fri, 02 Nov 2018 15:16:29 GMT

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.

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

data_null__ — Fri, 02 Nov 2018 15:34:34 GMT

show the code

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

vikaskubde — Fri, 02 Nov 2018 15:34:37 GMT

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

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

vikaskubde — Fri, 02 Nov 2018 16:28:02 GMT

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;

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

Reeza — Fri, 02 Nov 2018 16:54:40 GMT

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.

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

data_null__ — Fri, 02 Nov 2018 17:01:36 GMT

From the documentation

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

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

vikaskubde — Fri, 02 Nov 2018 18:25:31 GMT

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

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

Reeza — Fri, 02 Nov 2018 18:28:29 GMT

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.