Chapter Contents |
Previous |
Next |
The SQL Procedure |
See also: | column-modifier |
Featured in: | Creating a Table and Inserting Data into It |
column
CHARACTER|VARCHAR <(width)>
<column-modifier <column-modifier>...> |
column INTEGER|SMALLINT
<column-modifier <column-modifier>...> |
column DECIMAL|NUMERIC|FLOAT
<(width<,ndec>)>
<column-modifier <column-modifier>...> |
column REAL|DOUBLE PRECISION
<column-modifier <column-modifier>...> |
column DATE <column-modifier> |
column-modifier is described in column-modifier .
ndec is the number of decimals. PROC SQL ignores ndec. It is included for compatibility with SQL from other software.
width is the width of the column. The width field on a character column specifies the width of that column; it defaults to eight characters. PROC SQL ignores a width field on a numeric column. All numeric columns are created with the maximum precision allowed by the SAS System. If you want to create numeric columns that use less storage space, use the LENGTH statement in the DATA step.
Details |
Chapter Contents |
Previous |
Next |
Top of Page |
Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.