topic Re: Add panelcols to tagsets.msoffice2k in ODS and Base Reporting

Add panelcols to tagsets.msoffice2k

mansour_ib_sas — Fri, 19 Oct 2018 16:57:57 GMT

Hello,

i have tagsets.msoffice2k to intaller et not tagsets.msoffice2k_x,

i want to add the option panelcols =

I thought about creating a new templete.

Someone has already developed this templete?

thank you

Re: Add panelcols to tagsets.msoffice2k

Cynthia_sas — Wed, 20 Feb 2019 00:07:30 GMT

Hi:
TAGSETS.MSOFFICE2K_X already has a PANELCOLS= option, as shown here: https://support.sas.com/rnd/base/ods/odsmarkup/msoffice2k/index.html and that web page has the instructions for how to run code to create that template locally.

Since the hard work has already been done to make a PANELCOLS= suboption, why would you want to reinvent the wheel?

If you do decide to pursue this on your own, you'll have to investigate and learn the PROC TEMPLATE code for modifying a TAGSET template and essentially duplicate what is already in TAGSETS.MSOFFICE2K_X.

Cynthia

Re: Add panelcols to tagsets.msoffice2k

mansour_ib_sas — Mon, 25 Feb 2019 15:11:14 GMT

Hello Cynthia,
I found this templete and I installed.
its disadvantage is that you can't create more sheet in the excel workbook.
Thank you

Re: Add panelcols to tagsets.msoffice2k

Cynthia_sas — Mon, 25 Feb 2019 15:53:13 GMT

Hi:
Actually, you can -- Microsoft did have a way in their HTML to link multiple HTML files together into one workbook. It was sort of a pain, though because you create a separate HTML file ahead of time for each sheet and then in your final step, you link them all together, as shown here: https://support.sas.com/rnd/base/ods/odsmarkup/msoffice2k/index.html#multiple note and there's a picture that shows how it works:

It's not as seamless as ODS EXCEL or ODS TAGSETS.EXCELXP. I guess it depends on how critical the side-by-side appearance is.

Cynthia

Re: Add panelcols to tagsets.msoffice2k

mansour_ib_sas — Mon, 25 Feb 2019 17:09:30 GMT

effectively, after installing tagsets.msoffice2k, i searched for the sheet_name option.
I will use this method HTML for my export.
Thank you Cynthia