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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.