ms_processinputfilechecks.sas File Reference

This macro processes required integrity checks on QRP input files. More...

Detailed Description

This macro processes required integrity checks on QRP input files.

• Codes with wildcard checks:
  • Corresponding checks in input file checker:
    
    • I_001_016_CODE_WILDCARD
      
    • I_004_016_CODE_WILDCARD
      
    • I_006_012_CODE_WILDCARD
      
    • I_010_009_CODE_WILDCARD
      
  • Wildcard must be used only with ICD-9 (CODETYPE=09) DIAGNOSIS (when CODECAT=DX) codes.
    
  • When CODECAT=DX and CODETYPE=09, the only non-digit characters allowed are the letters 'E' and 'V' and the asterisk '*'.
    
• AGESTRAT checks:
  • Corresponding checks in input file checker:
    
    • I_002_010_AGESTRAT
      
    • I_002_017_AGESTRAT_SEQ
      
  • AGESTRAT must be a list of numeric ranges of the form Xu-Yu or Xu+, separated by a space where X, Y in N (natural numbers) and u is a unit (D, W, M, Q, Y, null).
  • AGESTRAT must have sequential and non overlapping values.
    
    • Warnflag is the dummy variable that indicates non-sequential or overlapping values in AGESTRAT.
      
• CC covariates checks:
  • Corresponding checks in input file checker:
    
    • I_004_007_CODE_NOTE7
      
    • I_004_015_CODECAT_CC_CODE
  • If CODECAT = CC, this field contains the algorithm for the combination of COVARNUM values, e.g., "1 and (2 or 3)" to describe an algorithm requesting presence of COVARNUM=1 and(COVARNUM=2 or COVARNUM=3).
    • Any combination of "and", "or", and "not" may be used in combination with parentheses to define algorithms.
      
  • When CODECAT='CC' then all numbers specified in CODE must be defined prior to the covariate definition.
    • If CODE= "1 AND 6", then the covariate number must be >= 7.
      
  • Get longest longbook period to meet enrollment requirements.
    
  • Select covariates codes (not combination of covariates).
    
  • Get minimum values for each anchoring type window.
    • They will be used when creating the cohorts to assess enrollment criteria.
      
  • Compute variables to assess enrollment in MFU window.
• Sequential numbers without gap checks:
  • Corresponding checks in input file checker:
    
    • I_008_001_ANALYSISNUM
    • I_009_001_PERIODID
  • Value must start at 1 and increment by 1 without gap.
• Sequential numbers without gap within distinct analysisgrp checks:
  
  • Corresponding checks in input file checker:
    
    • I_025_004_ADHERENCEID
    • I_027_004_ADHERENCEID
  • Value must start at 1 and increment by 1 without gap.
  • Should start with 1 and increment by 1 for each &groupField. in the file
    
  • Call SEQUENCE_IN_GROUP_HELPER for each unique value of &groupField.
    
• Monitoring file checks:
  • Corresponding checks in input file checker:
    
    • I_009_004_INDENDOPTIONS
      
    • II_025_002_PERIODID_RANGE
  • INDENDOPTIONS must be empty if INDENDDATE is specified.
    
  • INDENDOPTIONS must be set to FUPDRIVEN or DATADRIVEN otherwise.
    
  • INDENDOPTIONS must be set to FUPDRIVEN or left blank if SURVEILLANCEMODE is specified.
    
  • All PERIODID should be present in the range PERIODIDSTART-PERIODIDEND.
    
  • Must be empty if INDENDDATE is specified.
  • Must be set to FUPDRIVEN or DATADRIVEN otherwise.
  • Must be set to FUPDRIVEN or left blank if SURVEILLANCEMODE is specified.
    
  • All PERIODID in the range PERIODIDSTART-PERIODIDEND should be present in MONITORINGFILE.
    
• Categorical variables range checks:
  • Corresponding checks in input file checker:
    
    • I_012_007_CENSOR_OUTPUT_CAT
      
    • I_013_021_CENSOR_OUTPUT_CAT
      
    • I_013_026_FOLLOWUPTIME_CAT
      
    • I_016_013_AFDD_OUTPUT_CAT
    • I_016_014_CUMDOSE_OUTPUT_CAT
      
    • I_016_015_CFDD_OUTPUT_CAT
    • I_026_015_FOLLOWUP_CAT
      
  • Must be a list of numeric ranges of the form X-Y or X+, separated by a space where X, Y in N (natural numbers). Must be in sequential order.
    

Program inputs

• infolder.&COHORTCODES. (Dataset with codes used to define exposures and outcomes of interest.)
• infolder.&COVARIATECODES. (Dataset containing covariates codes excluding combination of covariates.)
• infolder.&INCLUSIONCODES. (Dataset with codes used to define additional cohort inclusion/exclusion criteria.)
• infolder.&PREGNANCYCODES. (Dataset for Type 4 cohort identification strategy.)
• infolder.&RISKSCORECODES. (Dataset for risk score calculation if requested.)
• infolder.&MFUFILE. (Dataset for most frequent utilization (MFU) assessment.)
• infolder.&MONITORINGFILE. (Dataset with monitoring period(s) for descriptive, inferential and sequential analyses.)
• infolder.&MULTEVENTFILE_ADHERE. (Dataset to specify multiple criteria to determine overall adherence for a Type 2 multiple events analysis.)
• infolder.&OVERLAPFILE_ADHERE. (Dataset to specify multiple criteria to determine overall adherence for a concomitant use analysis.)
• infolder.&OVERLAPFILE. (Dataset characterizing an overlap of primary and secondary treatment episodes during the observation window.)
• infolder.&TYPE1FILE. (Dataset required for a background rate calculation cohort identification strategy.)
• infolder.&TYPE2FILE. (Dataset required for an exposures and follow-up time cohort identification strategy.)
• infolder.&TYPE5FILE. (Dataset required for medical product utilization cohort identification strategy.)

Program outputs

• work._&COVARIATECODES. (Dataset of covariates codes excluding combination of covariates.)

Usage

%ms_processinputfilechecks();

Parameters

None.

SAS Macros Dependencies

None.

Author

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