BUSINESS_TIMEFRAME= Data Set Option

lets you provide a date range or a datetime range to use when querying or modifying a temporal table.

Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Category: Data Set Control
Default: none
Requirement: DB2 z/OS with SAS 9.4
Data source: DB2 for z/OS
See: TEMPORAL= data set option, SYSTEM_TIMEFRAME= data set option, OVERLAPS= data set option,BUSINESS_DATATYPE= data set option

Table of Contents

Syntax

BUSINESS_TIMEFRAME=FROM date-or-datetime1 TO date-or-datetime2

Syntax Description

date-or-datetimeN

specifies the beginning or end of a time period that is used when you query or modify a table that contains temporal data. Use either a date or datetime value, depending on the value of the BUSINES_DATATYPE= data set option.

Last updated: February 3, 2026