This macro sets query period related dates for data driven queries. More...

Detailed Description

This macro sets query period related dates for data driven queries.

Monitoring file for Fixed Risk Window analysis:
- Type 2 and 3:
  - Add QA DP Max Date to file.
  - Determine date to use to determine last date of follow-up.
  - Add EndDate to monitoring file.
- Type 4:
  - Will extract maximum end date for group, then restrict in ms_createmicohorts.
    - Add QA DP Max Date to file
    - Determine date to use to determine last date of follow-up.
    - Add EndDate to monitoring file.
Looks 2+:
- Type 2 and 3:
  - Create monitoringfile to mimic looks.
  - Determine censor date for current look.
    - Add QA DP Max Date to file
    - Determine date to use to determine last date of follow-up.
    - Add EndDate to monitoring file.
- Type 4:
  - ERROR: (Sentinel) This functionality is not currently available.
Set query period macro variables:
- StartDate = start of surveillance period.
- EndDate = end of surveillance period (index date).
- ExpPeriodStartDt = look start date.
- ExpPeriodEndDt = look end date.
Take minimum StartDate and maximum EndDate.
Create non overlapping looks dates.
Assign calendar based global macro variables.
Save metadata file for type 2 and 3:
- First look and subsequent looks.

Program inputs

infolder.&METADATAFILE. (Dataset that defines the metadata generated for each time period request for sequential analysis.)
infolder.&MONITORINGFILE. (Dataset with monitoring period(s) for descriptive, inferential and sequential analyses.)

Program outputs

&MONITORINGFILE. (Dataset that defines the relevant query periods for execution.)
msoc.&RUNID._metadata_for_time_period_&PERIODIDSTART. (Dataset used when doing sequential SI analysis.)
work._metadata (Dataset containing metadata for types 2 and 3.)
work.looks (Dataset containing non overlapping looks dates.)
work.monitoringfile_agg (Dataset to set query period macro variables (min startdate and max enddate).)

Usage

%ms_setdatadrivenqueryperiod();

Author: Sentinel Coordinating Center (info@.nosp@m.sent.nosp@m.inels.nosp@m.yste.nosp@m.m.org)

	QRP