The ACCESS Procedure for PC Files |
Requirement: | This statement is required. |
Valid: | for DBF, DIF, WK1, WK3, WK4, Excel 4, Excel 5, and Excel 95 file formats under Windows operating environments |
Applies to: | view descriptor |
Interacts with: | RESET |
Not allowed with: | UPDATE |
SELECT ALL|<'column-identifier-1'>...<'column-identifier-n'>; |
Details |
The SELECT statement specifies which PC file columns in the access descriptor to include in the view descriptor. This is a required statement, and you can use it only when you create view descriptors. You cannot use the SELECT statement when you update a view descriptor.
If you use an editing statement, such as SELECT, it must follow the CREATE statement when you create a view descriptor.
See the CREATE Statement for more information about statement order.
The SELECT statement can take one or more of these arguments:
includes in the view descriptor all columns that were defined in the access descriptor and that were not dropped.
can be either the column name or the positional equivalent from the LIST statement. This is the number that represents the column's place in the access descriptor on which the view is based. To select the first three columns, submit this statement:
SELECT 1 2 3;
If the column name contains lowercase characters, special characters, or national characters, enclose the name in quotation marks. You can select as many columns as you want in one SELECT statement.
SELECT statements are cumulative within the same view creation. Submit these SELECT statements to select columns 1, 5, and 6.
SELECT 1; SELECT 5 6;
To clear all your selections when creating a view descriptor, use the RESET ALL statement. You can use another SELECT statement to select new columns.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.