topic Re: Multiple sheets with panel display in xls in ODS and Base Reporting

Multiple sheets with panel display in xls

Kayalvizhi — Fri, 12 Jul 2019 14:41:34 GMT

I need to create a XLS worksheet report ,in which the tables displayed in panels and having multiple tabs in worksheet.

So I used msoffice2k_x tagset for having the side-by-side display of tables(but it created only one sheet per workbook) .

Then created separate worksheets and tried combining worksheet_source option.But it seems like it stores the hyperlink and not the actual file.

Can you someone help me with storing the files permanently or an alternative approach ?

Thank,

Kayal

Re: Multiple sheets with panel display in xls

ballardw — Fri, 12 Jul 2019 15:05:45 GMT

First question: Do you actually want an XLS (as in the years ago replaced file format) or XLSX, the current file format?

The files are quite different.

Re: Multiple sheets with panel display in xls

Reeza — Fri, 12 Jul 2019 15:22:40 GMT

I'm not aware of a better way to get side by side tables in SAS right now unfortunately. If you know some R it's pretty basic to get data into Excel where you need it but it's not formatted either. How complicated is your report structure? Any option of building an Excel template and using SAS to populate it? That's usually my workaround.

Re: Multiple sheets with panel display in xls

VDD — Fri, 12 Jul 2019 15:23:27 GMT

how about something like this

ods html close;
ods excel file = "C:\Myresults.xlsx"
    options (contents = 'on');
proc print data = work.a_counts noobs;
proc print data = work.b_counts noobs;
proc print data = work.ac_counts noobs;
proc print data = work.bc_counts noobs;
run;

ods _all_ close;
ods html;

Re: Multiple sheets with panel display in xls

Reeza — Fri, 12 Jul 2019 15:31:11 GMT

ODS HTML doesn't support multisheets, without a lot of work arounds at least. ODS EXCEL doesn't support side by side tables 😞