Sample 25640: HTML Tabulate Formatter Example
This example uses the HTML Tabulate Formatter, one of the HTML
Formatting Tools, to capture results generated by PROC TABULATE. The
Tabulate Formatter captures results in a method similar to the Output
Formatter. You indicate the start and end of capturing.
Marking the Start of Capturing
To begin capturing the output, insert the
Tabulate Formatter CAPTURE=ON statement. This captures all PROC TABULATE output until a CAPTURE=OFF statement is encountered.
Next, insert a SAS TITLE statement that contains embedded
HTML tags. These tags change the justification and
appearance of the text that will display in the HTML-formatted pages.
Then, insert the PROC TABULATE code. This procedure generates the output, which is captured by the Tabulate Formatter and
displayed on the HTML page.
Marking the End of Capturing
After the SAS code, add the following code to the end of the file:
%tab2htm(capture=off,
runmode=b,
openmode=replace,
htmlfile=final.html,
brtitle=Tabulate Formatter Example,
center=Y,
tsize=+3,
clcolor=blue,
rlcolor=blue,
twidth=90,
bgtype=image,
bg=marble1.jpg,
encode=N);
This turns capturing off and specifies the following arguments:
HTMLFILE=FINAL.HTML, which specifies the name of the HTML file.
BRTITLE=TABULATE FORMATTER EXAMPLE, which specifies the text that appears in the Web browser window title bar.
CENTER=Y, which centers all PROC TABULATE results on the HTML-formatted page.
TSIZE=+3, which increases the size of the font used for the title.
CLCOLOR=BLUE, which specifies blue column labels.
RLCOLOR=BLUE, which specifies blue row labels.
TWIDTH=90, which formats the table width as 90% of the HTML page.
BGTYPE=IMAGE, which indicates that you want to use an image as the background type. Specify the name of the image in the BG= argument.
ENCODE=N, which tells the Tabulate Formatter not to encode the angle brackets in any statements so that the Web browser can act on them as an HTML-formatting instruction.
These sample files and code examples are provided by SAS Institute
Inc. "as is" without warranty of any kind, either express or implied, including
but not limited to the implied warranties of merchantability and fitness for a
particular purpose. Recipients acknowledge and agree that SAS Institute shall
not be liable for any damages whatsoever arising out of their use of this material.
In addition, SAS Institute will provide no support for the materials contained herein.
options linesize=96 pagesize=54 nocenter nodate nonumber;
title '<IMG ALIGN=CENTER SRC=globeanm.gif> World Wide Product Sales Report';
%tab2htm(capture=on,
runmode=b);
proc tabulate data=sashelp.prdsal2 formchar='82838485868788898a8b8c'x;
table state,
(actual predict ) * (sum*f=dollar14.2 mean*f=dollar14.2);
var actual predict;
class state;
keylabel sum="Total";
keylabel mean="Average";
run;
%tab2htm(capture=off,
runmode=b,
openmode=replace,
htmlfile=final.html,
brtitle=Tabulate Formatter Example,
center=Y,
tsize=+3,
clcolor=blue,
rlcolor=blue,
twidth=90,
bgtype=image,
bg=marble1.jpg,
encode=N);
These sample files and code examples are provided by SAS Institute
Inc. "as is" without warranty of any kind, either express or implied, including
but not limited to the implied warranties of merchantability and fitness for a
particular purpose. Recipients acknowledge and agree that SAS Institute shall
not be liable for any damages whatsoever arising out of their use of this material.
In addition, SAS Institute will provide no support for the materials contained herein.
A sample output file is available here.
This example shows a table that provides actual and predicted product sales across different geographical areas. The results were produced by PROC TABULATE. The HTML Tabulate Formatter captured and converted the results into an HTML-formatted file.
| Type: | Sample |
| Topic: | Software Components ==> HTML Formatting Tools
|
| Date Modified: | 2006-12-07 13:24:48 |
| Date Created: | 2005-07-08 09:57:30 |
Operating System and Release Information
| SAS System | SAS/IntrNet | All | n/a | n/a |
