PROC SQL: Beyond the Basics Using SAS®

2.5. Summary

1. The available data types in SQL are 1) numeric and 2) character (see section 2.2).

2. When a table is created with PROC SQL, numeric columns are assigned a default length of 8 bytes (see section 2.2.1).

3. SAS tables store date and time information in the form of a numeric data type (see section 2.2.2).

4. A CHAR column stores a default of 8 characters (see section 2.2.3).

5. Missing or unknown information is supported by PROC SQL in a form known as a null value. A null value is not the same as a zero value (see section 2.2.5).

6. Comparison operators are used in the SQL procedure to compare one character or numeric value to another (see section 2.3.1).

7. Logical operators (AND, OR, and NOT) are used to connect one or more expressions together in a WHERE ...