Before you invoke the Tabulate Formatter, you must perform several steps. These steps vary depending on the mode in which you are invoking the formatter (batch or interactive). One of the steps instructs you to set your SAS system options. The following explains which options you must set to use the Tabulate Formatter.
You must set your line size to a value that is less than or equal to 195. You can set line size using the OPTIONS statement when you start your SAS session, by using the OPTIONS window once your SAS session is running, or by including it in your SAS program. If you set your line size after you start your SAS session and you plan to capture PROC TABULATE output interactively, be sure to clear your Output window before running the TABULATE procedure.
For example, if you want to set the line size to be 190 characters, your OPTIONS statement would look like the following:
OPTIONS LS=190;
SAS software uses the form characters to construct the outline for the PROC TABULATE output. You must indicate a set of form characters using either the FORMCHAR system option or the FORMCHAR option of PROC TABULATE. Examples of both methods are shown below.
OPTIONS FORMCHAR=value;
where value is the hexadecimal values for the characters.
PROC TABULATE FORMCHAR=value <other TABULATE options>;
where value is the hexadecimal values for the characters.
The following table lists the recommended values. These values are sufficient for most output.
Character Set Form Characters ASCII '82838485868788898A8B8C'x EBCDIC 'B2B3B4B5B6B7B8B9BABBBC'x DBCS '02030405060708090A0B0C'x
If the recommended form characters do not work for you, you can specify an alternate set of form characters.
If the suggested form characters do not work for your data, you can specify an alternate set of characters. When specifying the form characters, follow these guidelines:
Choose characters that are not used in your data.
Specify the form characters using either the FORMCHAR system option or the FORMCHAR option of PROC TABULATE.
Specify the formchar argument when you invoke the Tabulate Formatter.
The following shows one method for defining an alternate set of form characters. You can use any method and any set of form characters that meet the above guidelines and work with your use of the Tabulate Formatter.
%let myforms='f2f3f4f5f6f7f8f9fafbfc'x;
%tab2htm(runmode=b,
capture=on);
PROC TABULATE FORMCHAR=&myforms
<other TABULATE options>;
<PROC TABULATE code>
RUN;
%tab2htm(capture=off,
formchar=&myforms,
<other arguments>);