The ACCESS Procedure for Relational Databases CREATE Statement 299
ASSIGN Statement
Indicates whether SAS variable names and formats are generated
Applies to: access descriptor
Interacts with:
FORMAT, RENAME, RESET, UNIQUE
Default:
NO
ASSIGN <=>YES | NO | Y | N;
NO
enables you to modify SAS variable names and formats when you create an access
descriptor and when you create view descriptors that are based on this access
descriptor.
YES
generates unique SAS variable names from the first eight characters of the DBMS
column names. If you specify
YES, you cannot specify the RENAME, FORMAT,
RESET or UNIQUE statements when you create view descriptors that are based on
the access descriptor.
Details
The ASSIGN statement indicates whether SAS variable names are automatically
generated and whether users can change SAS variable names and formats in the view
descriptors that are created from the access descriptor. Each time the SAS/ACCESS
interface encounters a CREATE statement to create an access descriptor, the ASSIGN
statement is reset to the default
NO
value.
During an access descriptor’s creation, you use the RENAME statement to change
SAS variable names and the FORMAT statement to change SAS formats.
When you specify
YES, names are generated according to the following rules:
with
YES, you can change the SAS variable names only in the access descriptor
the SAS variable names that are saved in an access descriptor are always used
when view descriptors are created from the access descriptor; you cannot change
them in the view descriptors
the ACCESS procedure only allows names up to eight characters.
CREATE Statement
Creates a SAS/ACCESS descriptor file
Applies to: access descriptor or view descriptor
CREATE libref.member-name.ACCESS | VIEW <password-option>;
libref.member-name
