You use the COUNT function
in a SELECT statement to return the requested number of rows in a
table.
The following list describes
what is returned by using the different versions of the COUNT function:
Form 1: COUNT(expression)
returns the number
of rows from a table that do not have a null value.
Form 2: COUNT(*)
returns the number
of rows in a table.
Form 3: COUNT(DISTINCT expression)
returns the number
of rows in expression that
have unique values. SAS missing values are included in the results.
Null values are not included in the results.
You can use an aggregate
function to produce a statistical summary of data in the entire table
that is listed in the FROM clause or for each group that is specified
in a GROUP BY clause. The GROUP BY clause groups data by a specified
column or columns. When you use a GROUP BY clause, the aggregate function
in the SELECT clause or in a HAVING clause instructs FedSQL in how
to summarize the data for each group. FedSQL calculates the aggregate
function separately for each group. If GROUP BY is omitted, then all
the rows in the table or view are considered to be a single group.