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
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.
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;
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.
Ready to level-up your skills? Choose your own adventure.