determines whether the values for BUS_START and BUS_END can overlap between active records for the specified columns.
| Valid in: | DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software) |
|---|---|
| Category: | Data Set Control |
| Default: | column names separated by commas |
| Interaction: | allowed for the BUSINESS_TIME period |
| Data source: | DB2 z/OS |
| See: | TEMPORAL= data set option, BUSINESS_TIMEFRAME= data set option, SYSTEM_TIMEFRAME = data set option, BUSINESS_DATATYPE= data set option |
Table of Contents
a list of column names, separated by commas, for which business time period overlap is not allowed.
Here is an example that uses the OVERLAPS= option:
proc sql;
create table policy (dbnull=(_all_=no) temporal=business OVERLAPS='id,vin')
(id,int,vin varchar(10));
<additional statements>
quit;