Multiple sheets with panel display in xls

[Kayalvizhi]

Hi

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

[ballardw]

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.

[Reeza]

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.

[VDD]

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;

[Reeza]

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