• esProc
Tutorial
Function Reference
Code Reference
User Reference
External Library Guide
Data File Tool Manual
DQL Tutorial
Cluster Server Manager Manual
SPL WIN Manual
• YModel
User Reference
JSON-style Parameter Guide
• ReportLite
User Reference
• Official Website

# fillcons()

Description:

Fill missing values using the specified constant value.

Syntax:

A.fillcons(v)

Note:

The function uses constant value v to fill missing values in sequence A. A is a vector or a matrix; v can be a scalar or a vector.

If v is a single value, fill all missing values with it; if v is a vector, enter each element to the position of missing value in the corresponding column of sequence A.

v’s length should be greater than or equal to the number of columns in sequence A. For filling by column, each member of v corresponds to the missing value position in a column of A; enter the members from left to right in order and ignore the extra member(s). If v’s length is less than the number of columns in sequence A, error will be reported.

Parameter:

 A A sequence v A constant value

Option:

 @n Treat non-numeric members in the sequence as nulls

Return value:

Sequence

Example:

 A 1 =[1,2,,,5,,7,8] 2 =A1.fillcons(999) Fill all missing values with the specified single value. 3 =[1,2,,,5,,7,8] 4 =[999,888,777,666,555,444,333,222,111] 5 =A3.fillcons(A4) Fill missing values by column. 6 =[[1,2,,,5,,7,8],[2,3,4,,,,5,]] 7 =A6.fillcons(999) Fill all missing values with the specified single value. 8 =[[1,2,,,5,,7,8],[2,3,4,,,,5,]] 9 =[999] 10 =A8.fillcons(A9) Same as A7. 11 =[[1,2,,,5,,7,8],[2,3,4,,,,5,]] 12 =A11.fillcons(A4) Fill missing values by column. 13 =["sss",2,,7,,90.9,"2"] 14 =A13.fillcons@n(A4) Treat the non-numeric member as null.