Suppose that the Missing Value Codes column property is assigned to the x1 column to treat “999” as a missing value. Another column includes a formula that calculates the mean. To use the value “999” instead of a missing value to calculate the mean, use Col Stored Value() in the formula:
Mean( Col Stored Value( :x1 ), :x2, :x3 )
The name of the nth column as an expression (not a string).
Used for column formulas. Creates row by row the values beginning with the from value and ending with the to value. The number of steps specifies the number of values in the list between and including the from and to values. Each value determined by the first three arguments of the count function occurs consecutively the number of times that you specify. When the to value is reached, count starts over at the from value. If the from and to arguments are data table column names, count takes the values from the first row only. Values in subsequent rows are ignored.
Number, column reference, or expression. Count starts counting with this value.
Number, column reference, or expression. Count stops counting with this value.
For Each Row(:colname[row()]=count(0, 6, 3, 1))
//The rows in the column named colname are filled with the series 0, 3, 6, 0, ... until all rows are filled.
 
For Each Row(:colname[row()]=count(0, 6, 3, 2))
//The rows in the column named colname are filled with the series 0, 0, 3, 3, 6, 6, 0, ... until all rows are filled.
Count() is dependent on Row(), and is therefore mainly useful in column formulas.
Gets reference to the nth open data table or the table with the given name in a global variable.
Calculates the difference of the value of the column col in the current row and the value n rows previous to the current row.
Use Project(0) to specify no project when running the expression in a project.
Adds a new column named "name" after the last column in dt. Unless otherwise specified, columns are numeric, continuous, and 12 characters wide.
New Table("name", <visibility("invisible" | "private" | "visible")>, <actions>)
Optional quoted keyword. invisible hides the data table from view but lists it in the JMP Home Window and Window menu. private hides the table completely. visible shows the data table. "visible" is the default value.
Produces an arithmetic sequence of numbers across the rows in a data table. The stepSize and repeatTimes arguments are optional, and the default value for both is 1.
Subscripts for lists extract the ith item from the list, or the bth row and the cth column from a matrix.

Help created on 7/12/2018