-
ALTERPW
-
specifies whether a password is required
to alter the data set.
1 |
the data set is alter protected. |
0 |
the data set is not alter protected. |
-
ANOBS
-
specifies whether the engine knows the number
of observations.
1 |
the engine knows the number of observations. |
0 |
the engine does not know the number
of observations. |
-
ANY
-
specifies whether the data set has observations
or variables.
-1 |
the data set has no observations
or variables. |
0 |
the data set has no observations. |
1 |
the data set has observations and
variables. |
-
ARAND
-
specifies whether the engine supports random
access.
1 |
the engine supports random access. |
0 |
the engine does not support random
access. |
-
ARWU
-
specifies whether the engine can manipulate
files.
1 |
the engine is not read-only. It can
create or update SAS files. |
0 |
the engine is read-only. |
-
AUDIT
-
specifies whether logging to an audit file
is enabled.
1 |
logging is enabled. |
0 |
logging is suspended. |
-
AUDIT_DATA
-
specifies whether after-update record images
are stored.
1 |
after-update record images are stored. |
0 |
after-update record images are not
stored. |
-
AUDIT_BEFORE
-
specifies whether before-update record images
are stored.
1 |
before-update record images are stored. |
0 |
before-update record images are not
stored. |
-
AUDIT_ERROR
-
specifies whether unsuccessful after-update
record images are stored.
1 |
unsuccessful after-update record
images are stored. |
0 |
unsuccessful after-update record
images are not stored. |
-
CRDTE
-
specifies the date that the data set was
created. The value that is returned is the internal SAS datetime value for
the creation date.
Tip: |
Use the DATETIME. format
to display this value. |
-
ICONST
-
returns information about the existence
of integrity constraints for a SAS data set.
0 |
no integrity constraints. |
1 |
one or more general integrity constraints. |
2 |
one or more referential integrity
constraints. |
3 |
both one or more general integrity
constraints and one or more referential integrity constraints. |
-
INDEX
-
specifies whether the data set supports
indexing.
1 |
indexing is supported. |
0 |
indexing is not supported. |
-
ISINDEX
-
specifies whether the data set is indexed.
1 |
at least one index exists for the
data set. |
0 |
the data set is not indexed. |
-
ISSUBSET
-
specifies whether the data set is a subset.
1 |
at least one WHERE clause is active. |
0 |
no WHERE clause is active. |
-
LRECL
-
specifies the logical record length.
-
LRID
-
specifies the length of the record ID.
-
MAXGEN
-
specifies the maximum number of generations.
-
MAXRC
-
specifies whether an application checks
return codes.
1 |
an application checks return codes. |
0 |
an application does not check return
codes. |
-
MODTE
-
specifies the last date and time that the
data set was modified. The value returned is the internal SAS datetime value.
Tip: |
Use the DATETIME. format
to display this value. |
-
NDEL
-
specifies the number of observations in
the data set that are marked for deletion.
-
NEXTGEN
-
specifies the next generation number to
generate.
-
NLOBS
-
specifies the number of logical observations
(the observations that are not marked for deletion). An active WHERE clause
does not affect this number.
-1 |
the number of observations is not
available. |
-
NLOBSF
-
specifies the number of logical observations
(the observations that are not marked for deletion) by forcing each observation
to be read and by taking the FIRSTOBS system option, the OBS system option,
and the WHERE clauses into account.
Tip: |
Passing NLOBSF to ATTRN
requires the engine to read every observation from the data set that matches
the WHERE clause. Based on the file type and file size, reading these observations
can be a time-consuming process. |
-
NOBS
-
specifies the number of physical observations
(including the observations that are marked for deletion). An active WHERE
clause does not affect this number.
-1 |
the number of observations is not
available. |
-
NVARS
-
specifies the number of variables in the
data set.
-
PW
-
specifies whether a password is required
to access the data set.
1 |
the data set is protected. |
0 |
the data set is not protected. |
-
RADIX
-
specifies whether access by observation
number (radix addressability) is allowed.
1 |
access by observation number is allowed. |
0 |
access by observation number is not
allowed. |
Note: A data set that is accessed
by a tape engine is index addressable although it cannot be accessed by an
observation number.
-
READPW
-
specifies whether a password is required
to read the data set.
1 |
the data set is read protected. |
0 |
the data set is not read protected. |
-
TAPE
-
specifies the status of the data set tape.
1 |
the data set is a sequential file. |
0 |
the data set is not a sequential
file. |
-
WHSTMT
-
specifies the active WHERE clauses.
0 |
no WHERE clause is active. |
1 |
a permanent WHERE clause is active. |
2 |
a temporary WHERE clause is active. |
3 |
both permanent and temporary WHERE
clauses are active. |
-
WRITEPW
-
specifies whether a password is required
to write to the data set.
1 |
the data set is write protected. |
0 |
the data set is not write
protected. |