BookmarkSubscribeRSS Feed
deleted_user
Not applicable
I trying to create a spreadsheet with several tables next to each other into one worksheet.
I tried to do this with the ODS TAGSETS.EXCELXP, below each other is no problem.

I need to presentate differend kinds of info into one sheet.

Something similar is possible ODS PDF via LAYOUT and REGION.

Does someone has any idea how to realize this in a spreadsheet?

Thanks
3 REPLIES 3
Cynthia_sas
SAS Super FREQ
I do not think that ODS LAYOUT and ODS REGION will work with TAGSETS.EXCELXP. Tech Support could answer that one for sure.

If you switch to ODS and use an HTML-based tagset, then you MIGHT be able to open the HTML file with Excel and have the multiple tables respected. There is a tagset called HTMLPANEL, that will put HTML tables side by side -- it uses features of ODS LAYOUT and ODS REGION -- but since the result is "pure" HTML tags, then Excel MIGHT open the HTML file that you created with ODS HTMLPANEL. This tagset is not part of the installed set of tagset templates that are delivered with SAS and you would have to download it and read the documentation. I suggest getting it working so it looks good in a browser and THEN see how Excel deals with it. Generally, Excel doesn't like HTML 4 tags, so there's a chance that this will NOT work. Tech Support might know right away whether this is a good suggestion on not.

Your last choice might be to see what the TABLEEDITOR tagset does for you. It uses Javascript and HTML to create tables that can be sent to Excel. In spite of the name this is a pretty cool tagset that does MORE than just allow you to edit your tables. Again, Tech Support can help you with this tagset if you can't figure it out from the documentation.

For more information about these other tagsets, go to:
http://support.sas.com/rnd/base/ods/odsmarkup/
and follow the links for HTMLPANEL and TABLEEDITOR. To contact Tech Support, go to: http://support.sas.com/ and on the left hand side of the page, click on the link that says: "Submit a Problem".

cynthia
deleted_user
Not applicable
Hi Cynthia,

I took al look to the TABLEEDITOR and HTMLPANEL. Unfortunately these tagsets don't have the functionality I'm looking for.

Thanks for your help. I will ask SAS support for further information

Martin
OS2Rules
Obsidian | Level 7
I was wondering if you had tried using "named areas" on the Excel spreadsheet?

This is where you basically predefine the format of the report in Excel and name the block. You can create any number of named areas, side by side, or even on top of each other. Then using SAS you simply write the data into the named areas.

Here is a presentation that I attended on how to do this...

http://torsas.ca/downloads/PopulateCustomExcel.pdf

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 685 views
  • 0 likes
  • 3 in conversation