[table of contents for nonframes version]

TABULATE

Description

The TABULATE command is used to create a two-dimensional display of terms extracted from two fields with ANALYZE.

Options

Display options available with the TABULATE command are:

Option	Used to display
Non-grid (default format)	Columns of information containing: Term numbers Number of documents Percentage of documents Terms for the primary display code Terms for the secondary display code
GRID	A two-dimensional table with: Terms for the primary display code listed on the vertical axis Terms for the secondary display code on the horizontal axis Total document count given at each intersection of the primary and secondary terms
DELIMITED	Delimited lines of information containing the number of documents the percentage of documents unique pairs of primary and secondary terms with the items separated by semicolons Note: This option is intended for use by post-processing applications

Note!

While in the TABULATE command you have the option to reformat the display using the same display fields.

Process

To use TABULATE, follow these steps:

Step	Action
1	ANALYZE an answer set specifying 2 fields for analysis.
2	Enter the TABULATE command line.
3	Respond to the prompts within TABULATE to set the display requirements.

Command Line	To use the TABULATE command, follow this sample format:
	=>	TABULATE	L-number	primary extraction field	secondary extraction field
		1	2	3	4

Example: => TABULATE L3 AU PY

Command Guidelines

Use the guidelines below to enter command line information:

Field	Guidelines
1	Type: TABULATE
2	Type: An L-number created with ANALYZE Default: The last L-number created
3	Type: a primary extraction (display) field code
4	Type: a secondary extraction (display) field code

Use the guidelines below to respond to prompts for display parameters within TABULATE. Note that the default for each prompt is listed in parentheses.

Prompt	Guidelines
DISPLAY AS GRID FORMAT (N), Y, or ?:	Type: To display terms: Y In a grid N In columns
DISPLAY PRIMARY (TOP 10), ENTIRE OR ?: or DISPLAY SECONDARY (TOP 10), ENTIRE OR ?:	Type: To display: ENTIRE All the terms TOP n Top n terms based on frequency of occurrence DGT n Terms with Document Counts Greater than n PGT n Terms with or Percentage Counts %GT n Greater than n m-n A range of terms
PRIMARY SORT ORDER (CURRENT), DOC, ALPHA, OR ?: or SECONDARY SORT ORDER (CURRENT), DOC, ALPHA, OR ?:	Type: To sort terms: ALPHA In alphabetical order CURRENT By the current ordering of the ANALYZE L-number DOC By the number of documents for each term PER By the percentage or % of documents for each term
PRIMARY SORT DIRECTION (DEFAULT), A, D, OR ?: or SECONDARY SORT DIRECTION (DEFAULT), A, D, OR ?:	Type: To sort terms: A In ascending order * From lowest to highest for number * From A to Z for alphabetic terms D In descending order * From highest to lowest for numbers * From Z to A for alphabetic terms Default: D for numbers, A for alphabetics

Notes: To receive the preceding prompts you must type TABULATE, in its entirety, in the command line. If an abbreviated form of TABULATE is used, defaults are assumed. The display format that is chosen determines which of the above prompts are issued.

Extraction Fields	All extraction fields, except the following, may be used with TABULATE.
	Patent number	CAS Registry Number
	Application number	Accession Number
	Priority number	Basic Index and similar fields
	To identify extraction fields and codes in the current file, at an arrow prompt type HELP EFIELDS.

Other Display Options

Other display options can be used with TABULATE. Follow the guidelines in the table below.

IF, you want to display	THEN, to the command line add	Example
The answer number with the terms	ANSWERS Note: ANSWER and GRID cannot be used in the same TABULATE command.	=> TABULATE L6 ICM PY ANSWERS
The terms in the delimited format for downloading	DELIMITED Or, at the reformatting prompt,type TABULATE DELIMITED	=> TABULATE L6 AU PY DELIMITED REFORMAT USING SAME DISPLAY FIELDS:(N), Y, ?: TABULATE DELIMITED
The appended search field code	DETAIL	=> TABULATE ICM PY DETAIL

Restricting Extracted Terms

You may instruct TABULATE to display terms only if they meet certain criteria.

IF, you want to display	THEN, to the command line add	Example
Only terms that contain a 1-20 character string	WITH followed by the character string in quotes	=> TABULATE L5 AU PY WITH "BARNETT"
Only terms that do not contain a 1-20 character string	NOT followed by the character string in quotes	=> TABULATE L3 AU PY NOT "MILLER"
Rules: When selecting from an ANALYZE L-number, WITH and NOT apply to both the term and the appended field code WITH and NOT may not be used in the same TABULATE command.

Example: Default Display

The following example shows use of the TABULATE command to display terms extracted with ANALYZE in the default display.

L2 ANALYZE L1 1- AU PY : 78 TERMS => TABULATE L2 AU PY DISPLAY AS GRID FORMAT (N), Y, OR ?:N DISPLAY PRIMARY (TOP 10), ENTIRE OR ?:. DISPLAY SECONDARY (TOP 10), ENTIRE OR ?:. PRIMARY SORT ORDER (CURRENT), DOC, ALPHA, OR ?:ALPHA PRIMARY SORT DIRECTION (DEFAULT), A, D, OR ?:. SECONDARY SORT ORDER (CURRENT), DOC, ALPHA, OR ?:. SECONDARY SORT DIRECTION (DEFAULT), A, D, OR ?:D A FEE WILL BE CHARGED. PROCEED? (Y), N, OR ?:. L2 ANALYZE L1 1- AU PY : 78 TERMS TERM # # DOC % DOC AU PY ------ ------ ------ -------------------------- ------ 1 2 7.41 BAKER, NORMAN F. 1 3.70 -- 1977 1 3.70 -- 1975 2 1 3.70 BARNETT, S. 1 3.70 -- 1994 3 1 3.70 BARNETT, SHARRON H. 1 3.70 -- 1988 4 1 3.70 BARNETT, SHARRON 1 3.70 -- 1996 - - - REFORMAT USING SAME DISPLAY FIELDS? (N), Y, OR ?:N

Notes: The display gives: The top 10 authors in the AU column For each author, the publication years in the PY column For each term, the number and percent of documents While within the TABULATE command you are given the option to reformat the information using the same display fields. Enter N to exit TABULATE without reformatting.

Example: GRID Display

The following example shows use of the TABULATE command to display terms extracted with ANALYZE in the GRID display.

L2 ANALYZE L1 1- AU PY : 78 TERMS => TABULATE L2 AU PY DISPLAY AS GRID FORMAT (N), Y, OR ?:Y DISPLAY PRIMARY (TOP 10), ENTIRE OR ?:. PRIMARY SORT ORDER (CURRENT), DOC, ALPHA, OR ?:ALPHA PRIMARY SORT DIRECTION (DEFAULT), A, D, OR ?:. SECONDARY SORT ORDER (CURRENT), DOC, ALPHA, OR ?:. SECONDARY SORT DIRECTION (DEFAULT), A, D, OR ?:D A FEE WILL BE CHARGED. PROCEED? (Y), N, OR ?:. L2 ANALYZE L1 1- AU PY : 78 TERMS PY ------------------------------------------------- AU 1998 1997 1996 1995 1994 1993 1991 1988 1983 1978 ------------------------ ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- BAKER, NORMAN F. 0 0 0 0 0 0 0 0 0 0 BARNETT, S. 0 0 0 0 1 0 0 0 0 0 BARNETT, SHARRON H. 0 0 0 0 0 0 0 1 0 0 BARNETT, SHARRON 0 0 1 0 0 0 0 0 0 0 BISHAI, SAMIR 0 1 0 0 0 0 0 0 0 0 COLBURN, EVERETT L., JR. 0 0 0 0 0 0 0 0 0 0 DEAN, SUSAN R. 0 1 0 0 0 0 0 0 0 0 DRYDEN, MICHAEL W. 0 1 0 0 0 0 0 0 0 0 EVILSIZER, MELODY 0 0 1 0 0 0 0 0 0 0 FITCH, JOANNE 0 0 0 1 0 0 0 0 0 0 - - - REFORMAT USING SAME DISPLAY FIELDS? (N), Y, OR ?:N

Notes: The display gives: The top 10 authors on the vertical axis The publication years on the horizontal axis The document count at each intersection of AU and PY While within the TABULATE command you are given the option to reformat the information using the same display fields. Enter N to exit TABULATE without reformatting.

Example: DELIMITED Display

The following example shows use of the TABULATE command to display terms extracted with ANALYZE in the DELIMITED display.

L2 ANALYZE L1 1- AU PY : 78 TERMS => TABULATE L2 AU PY DELIMITED DISPLAY AS GRID FORMAT (N), Y, OR ?:N DISPLAY PRIMARY (TOP 10), ENTIRE OR ?:. DISPLAY SECONDARY (TOP 10), ENTIRE OR ?:. PRIMARY SORT ORDER (CURRENT), DOC, ALPHA, OR ?:ALPHA PRIMARY SORT DIRECTION (DEFAULT), A, D, OR ?:. SECONDARY SORT ORDER (CURRENT), DOC, ALPHA, OR ?:. SECONDARY SORT DIRECTION (DEFAULT), A, D, OR ?:D A FEE WILL BE CHARGED. PROCEED? (Y), N, OR ?:. L2 ANALYZE L1 1- AU PY : 78 TERMS 1;3.70;BAKER, NORMAN F.;1977 1;3.70;BAKER, NORMAN F.;1975 1;3.70;BARNETT, S.;1994 1;3.70;BARNETT, SHARRON H.;1988 1;3.70;BARNETT, SHARRON;1996 1;3.70;BISHAI, SAMIR;1997 1;3.70;COLBURN, EVERETT L., JR.;1977 1;3.70;DEAN, SUSAN R.;1997 1;3.70;DRYDEN, MICHAEL W.;1997 1;3.70;EVILSIZER, MELODY;1996 1;3.70;FITCH, JOANNE;1995 REFORMAT USING SAME DISPLAY FIELDS? (N), Y, OR ?:N

Notes: The display gives: the number of documents the percentage of documents unique pairs of primary and secondary terms While within the TABULATE command you are given the option to reformat the information using the same display fields. Enter N to exit TABULATE without reformatting.

STN Assistance

If you enter just the TABULATE command, STN prompts you for all information necessary to complete the command. If you are unsure how to answer an STN prompt, enter a question mark (?) and STN provides more details. For more details on the TABULATE command, type HELP TABULATE.