DATASETS Procedure
- Syntax
Procedure SyntaxPROC DATASETS StatementAGE StatementAPPEND StatementATTRIB StatementAUDIT StatementCHANGE StatementCONTENTS StatementCOPY StatementDELETE StatementEXCHANGE StatementEXCLUDE StatementFORMAT StatementIC CREATE StatementIC DELETE StatementIC REACTIVATE StatementINDEX CENTILES StatementINDEX CREATE StatementINDEX DELETE StatementINFORMAT StatementLABEL StatementMODIFY StatementREBUILD StatementRENAME StatementREPAIR StatementSAVE StatementSELECT Statement - Overview
- Concepts
- Results
- Examples Removing All Labels and Formats in a Data SetManipulating SAS FilesSaving SAS Files from DeletionModifying SAS Data SetsDescribing a SAS Data SetConcatenating Two SAS Data SetsAging SAS Data SetsODS Output Getting Sort Indicator InformationUsing the ORDER= Option with the CONTENTS StatementInitiating an Audit File
INDEX CREATE Statement
Creates simple or composite indexes for the SAS
data set specified in the MODIFY statement.
| Restriction: | Must be in a MODIFY RUN group |
| See: | Understanding SAS Indexes in SAS Language Reference: Concepts |
| Example: | Modifying SAS Data Sets |
Syntax
INDEX CREATE index-specification-1 <...index-specification-n>
</ <NOMISS> <UNIQUE> <UPDATECENTILES= ALWAYS | NEVER | integer>>;
</ <NOMISS> <UNIQUE> <UPDATECENTILES= ALWAYS | NEVER | integer>>;
Required Argument
- index-specification(s)
-
can be one or both of the following forms:
- index=(variables)
-
creates a composite index. The name that you specify for index is the name of the composite index. It must be a valid SAS name and cannot be the same as any variable name or any other composite index name. You must specify at least two variables.
Note:The index name must follow the same rules as a SAS variable name, including avoiding the use of reserved names for automatic variables, such as _N_, and special variable list names, such as _ALL_. For more information, refer to “Rules for Words and Names in the SAS Language” in SAS Language Reference: Concepts.
Optional Arguments
- NOMISS
-
excludes from the index all observations with missing values for all index variables.When you create an index with the NOMISS option, SAS uses the index only for WHERE processing and only when missing values fail to satisfy the WHERE expression. For example, if you use the following WHERE statement, SAS does not use the index, because missing values satisfy the WHERE expression:
where dept ne '01';
Refer to SAS Language Reference: Concepts.Example:Modifying SAS Data Sets
- UNIQUE
-
specifies that the combination of values of the index variables must be unique. If you specify UNIQUE and multiple observations have the same values for the index variables, the index is not created.Example:Modifying SAS Data Sets
- UPDATECENTILES=ALWAYS | NEVER | integer
-
specifies when centiles are to be updated. It is not practical to update centiles after every data set update. Therefore, you can specify the percentage of the data values that can be changed before centiles for the indexed variables are updated. The following is a list of valid values:
- ALWAYS | 0
-
updates centiles when the data set is closed if any changes have been made to the data set index. You can specify ALWAYS or 0 and produce the same results.
- integer
-
specifies the percentage of values for the indexed variable that can be updated before centiles are refreshed.
Alias:UPDCENDefault:5 (percent)