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 )
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.
Calculates the difference of the value of the column col in the current row and the value n rows previous to the current row.
A column name (for example, :age).
Returns for each row the value of the column n rows previous.
Can also be used as a message: dt<<New Column("name", attributes).
Optional quoted keyword. invisible hides the data table from view; it appears only in the JMP Home Window and the Window menu. private avoids opening the data table. visible shows the data table. "visible" is the default value. Using private data tables saves memory for smaller tables. However, for large tables (for example, 100 columns and 1,000,000 rows), using a private data table is not helpful because the data requires a lot of memory.
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.