OLIPHANT Procedure

DETAILS Statement

Queries information about the data in a SASHDAT file.

Querying File Details from HDFS

Syntax

DETAILS <details-statement-options>;

Details Statement Options

ALL

includes the number of rows for each SASHDAT file in the SAS output.

Alias ALLFILES

COLUMN

includes the column attributes for the specified SASHDAT file in the SAS output.

Alias COLUMNINFO

FILE=SASHDAT-file

specifies the name of the SASHDAT file to use. Do not specify a fully qualified HDFS path. Do not enclose the value in quotation marks. Do not include the SASHDAT filename suffix. The name is converted to lowercase and the filename of the SASHDAT file in HDFS must also be in lowercase.

Alias TABLE=

PATH='HDFS-path'

specify the fully qualified HDFS directory name.

Alias OUTDIR=

RECURSIVE

when FILE= is not specified, the details are reported for all SASHDAT files that are found in the path and child directories.

ROWCOUNT

includes the number of observations in the specified SASHDAT file.