DIMENSION= Data Set Option

Specifies whether the database creates dimension tables or fact tables.

Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Category: Data Set Control
Default: NO
Data source: Aster
See: DIMENSION= LIBNAME option, PARTITION_KEY= LIBNAME option, PARTITION_KEY= data set option

Table of Contents

Syntax

DIMENSION=YES | NO

Syntax Description

YES

specifies that the database creates dimension tables.

NO

specifies that the database creates fact tables.

Last updated: February 3, 2026