Syntax: icount({}) Return: Numeric. Returns the count of multiple expressions; duplicate data is counted only oncedistinct,count
Description: Based on one or more specified columns, keep unique records. Optionally delete records with duplicates, deldistinct
Description: Count the number of distinct members in a sequence. Syntax: A.icount(x) icount(x1,…,xn) Equivalent to A.isequence,count,distinct
Description: Generate a new sequence by combining distinct members of two sequences in order. Syntax: A%B A%x x%A Note: distinct, member, new sequence