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.
Private tables cannot be made current with Current Data Table().
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).
Use Project(0) to specify no project when running the expression in a project.
Returns for each row the value of the column n rows previous.
Adds a new column named "name" after the last column in dt. Unless otherwise specified, columns are numeric, continuous, and 12 characters wide.
Can also be used as a message: dt<<New Column.
See dt<<New Column("name", <“data type”>, <"modeling type">, Format("format", width), <Formula()>, <Set Values>, <properties>) in JSL Messages for details about the New Column function and message arguments.
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.
Removes a subscription to the data table list that has been added through Subscribe to Data Table List().