BookmarkSubscribeRSS Feed
Calcite | Level 5
Hi SAS Experts,

I want to use the HTMLPANL tagset in Stored Process. To manually customize the report layout I need to specify ODS events. SAS BASE code example:

ods tagsets.htmlpanel file="manualpanel.html";

ods tagsets.htmlpanel event=row_panel(start);
ods tagsets.htmlpanel event=column_panel(start);

proc print data=sashelp.class;run;
proc print data=sashelp.class;run;

ods tagsets.htmlpanel event=column_panel(finish);

proc gchart data=sashelp.class;
hbar age / sumvar=height;

ods tagsets.htmlpanel event=row_panel(finish);

ods tagsets.htmlpanel close;

How can I specify the ODS events in the SAS Stored Process ? Thanks a lot.

Before you go too far down this road, can you explain what client applications you want to use to execute the stored process?? SAS Add-in for Microsoft Office, EG, Web Report Studio, the Information Delivery Portal???

The ODS HTMLPANEL tagset is generating HTML output. This type of output might not work in all the client applications. For example, Web Report Studio and PowerPoint will NOT accept or render HTML results from a stored process -- those 2 client applications only use SAS Report XML output.

If you use ODS HTMLPANEL to create an HTML file in Base SAS (without the platform being involved) and then open the HTML file in a browser, all will be good and rendered as you expect (so this means that the stored process you create will probably work OK in the Information Delivery Portal and EG once the code was turned into a stored process).

However, if you open your ODS HTMLPANEL output (from BASE SAS -- not as an SP) in either Word or Excel (not using AMO), you will see that neither product "panels" or renders the output in the same way as the browser does. This may argue against trying to use the HTMLPANEL destination.

Calcite | Level 5
Hi Cynthia,

sorry for the lack of information provided. I am going to use the SSP to create a html report delivered through SAS Portal. All I want is manually dispplay mixture of tables and graphs side by side. If HTMLPANL doesn't work , is there another way, ut using SSP and SAS Portal ? Thanks.
ODS HTMLPANEL should work IF your SP will be run in the Info Delivery Portal. No guarantee for other client apps.

This means that you will be using a SP that is extremely limited in where it can be run. If you are using the %STPBEGIN method, you could specify your ancillary statements this way:
ods &_ODSDEST event=row_panel(start);
ods &_ODSDEST event=column_panel(start);

ods &_ODSDEST event=column_panel(finish);
*.... end all code;

You may actually want to work with Tech Support on this question, because the HTMLPANEL tagset would normally code an <IMG> tag with a location on the local machine. The issue with the Platform and the Info Delivery Portal, is that you may have to return package results to get the images streamed correctly.




Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

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.

Get the $99 certification deal.jpg



Back in the Classroom!

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

View all other training opportunities.

Discussion stats
  • 3 replies
  • 2 in conversation