These commands were introduced in GraphPad Prism 6.04 and 6.0e. The idea is to specify a block (range) of cells to write to a text file already specified in an OpenOutput command.
Syntax: WBlock [row(s)] [column(s)] <row label> <;>
Rows
The parameter for rows can designate a single row, a row down to a blank row, a range of rows , or a list of rows which can be in any order. You must have used the OpenOutput script command first to specify where the results will be written.
What you enter |
How Prism interprets it |
7 |
Only row 7. Of course, row 7 is the row labeled with a 7 in front of it, so row 0 is the column titles. |
“7” |
Only row 7 |
“7-“ |
Start at row 7 and keep going until you hit a blank row |
“7-12” |
Start at row 7 and end at row 12. Note that the second number is the ending row, not the number of rows. |
“7, 11, 9, 8” |
Specified rows in that order. |
Columns
The parameter for columns can designate a single column, a column across until an empty column, a range of columns, or a list of columns which can be in any order. You must have used the OpenOutput script command first to specify where the results will be written.
What you enter |
How Prism interprets it |
3 |
Only column 3. The column of row titles (if it exists) is column 0. Column 1 is column A, but for some results there are no A, B, C column labels. |
“3-3” |
Only column 3. The column with titles is 0, so in the example above, this is the “significant” column |
“3” |
Only column 3. |
“3-“ |
Start at column 3 and keep going right until a column is empty (or the end of the table). |
“3, 4” |
Columns 3 and 4 |
“3-6” |
Columns 3, 4, 5 and 6. |
“3, 8, 4” |
Columns 3, then 8 then 4. Note that the order in the results will not match the order in the Prism table. Also note that I included spaces after the commas which are ignored. |
“3,8,4” |
“ |
Row label
The parameter row label would must be quoted text. That text will appear as the first item in every row output. If the WBlock command ends with a semicolon, then there is no delimeter (no tab, no space, no comma) after that text. If there is no semicolon, then the row label text is separated from the next column just like all the columns are separated (tab unless an alternative is specified in OpenOutput command). If there is no row label (as it is an optional parameter), then a semicolon at the end of the command is ignored and has no impact.
The WTBlock command has the same syntax as WBlock. Note that the label is applied to each row as output (which is each column in the Prism table)
WTBlock [row(s)] [columns to include] <row label> <;>
Here are results of one way ANOVA followed by Dunnett's test from Prism 6.04 (the results show two new columns that were not in prior releases):
The results are shown here as tables. In fact, they will be tab-delimited text (or comma delimeted, if that is set in the OpenOutput command).
Example 1
WBlock "7-", "6,4", "PSummary"
WBlock "7-", "6,3", "Significant?"
The results will be as shown below. Here it is a table. In fact it will be tab delimited text. (The delimeter is set in the OpenOutput script command, and defaults to tabs).
Psummary |
B |
**** |
Psummary |
C |
ns |
Psummary |
D |
* |
Psummary |
E |
ns |
Significant? |
B |
Yes |
Significant? |
C |
No |
Significant? |
D |
Yes |
Significant? |
E |
No |
Example 2
WBlock "7-", "6,4", "PSummary";
WBlock "7-", "6,3", "Significant?";
The results will be as shown below. Note the semicolon after the labels, so in both cases the label and the columnID column run together.
PsummaryB |
**** |
PsummaryC |
ns |
PsummaryD |
* |
PsummaryE |
ns |
Significant?B |
Yes |
Significant?C |
No |
Significant?D |
Yes |
Significant?E |
No |
Example 3
WBlock "7-", "7,4", "PSummary"
WBlock "7-", "7,3", "Significant?"
Here there is no semicolon, so the labels have their own column.
Psummary |
Treated |
**** |
Psummary |
Treated+Antagonist |
ns |
Psummary |
Treated+Agonist |
* |
Psummary |
Solvent Blank |
ns |
Significant? |
Treated |
Yes |
Significant? |
Treated+Antagonist |
No |
Significant? |
Treated+Agonist |
Yes |
Significant? |
Solvent Blank |
No |
Example 4
WTBlock "7-", “7,3,4”
Treated |
Treated+Antagonist |
Treated+Agonist |
Solvent Blanks |
Yes |
No |
Yes |
No |
*** |
Ns |
* |
ns |
Example 5
WTBlock, “7-“, 3, “Significant?”
Significant? |
Yes |
No |
Yes |
No |