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:
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.
//The rows in the column named colname are filled with the series 0, 3, 6, 0, ... until all rows are filled.
//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).
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.