Chapter Contents |
Previous |
Next |
DROP |
Optional statement | |
Applies to: | access descriptor |
Interacts with: | RESET, SELECT |
Syntax | |
Details |
Syntax |
DROP column-identifier-1 <...column-identifier-n>; |
Details |
An editing statement, such as DROP, must follow the CREATE and database-description statements when you create an access descriptor. See CREATE for more information on the order of statements.
The column-identifier argument can be either the column name or the positional equivalent from the LIST statement, which is the number that represents the column's place in the access descriptor. For example, to drop the third and fifth columns, submit the following statement:
drop 3 5;
If the column name contains special characters or national characters, enclose the name in quotes. You can drop as many columns as you want in one DROP statement.
To display a column that was previously dropped, specify that column name in the RESET statement. However, doing so also resets all the column's attributes (such as SAS variable name, format, and so on) to their default values.
Chapter Contents |
Previous |
Next |
Top of Page |
Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.