PROC SQL: Beyond the Basics Using SAS, Second Edition

Chapter 2: Working with Data in PROC SQL

Introduction

Overview of Data Types

Numeric Data

Date and Time Column Definitions

Character Data

Missing Values and NULL

Arithmetic and Missing Data

SQL Keywords

SQL Operators and Functions

Comparison Operators

Logical Operators

Arithmetic Operators

Character String Operators and Functions

Summarizing Data

Predicates

Dictionary Tables

Dictionary Tables and Metadata

Displaying Dictionary Table Definitions

Dictionary Table Column Names

Accessing a Dictionary Table’s Contents

Summary

 

Introduction

PROC SQL is essentially a database language as opposed to a procedural or computational language. In addition to having two data types available in the SAS implementation of SQL, numerous extensions including operators, ...