QRP
 
Loading...
Searching...
No Matches
ms_findgap.sas File Reference

This macro finds any first date that is the first after a user defined gap (or the very first). More...

Detailed Description

This macro finds any first date that is the first after a user defined gap (or the very first).

  • Remove duplicate records by ADate and PatId.
  • Compute gaps when &GAP. is not equal to 0.
    • If &GAP. (washper) is 0, then all claims are deemed potential index dates with respect to own self.
    • Initialize gap and assign previous ExpireDt.
    • Reduce records to the first ADate per PatId.
  • Reapply gap against all claims (not just prior claim).
    • If &GAP. (washper) is 0, then all claims meet gap requirement.
    • If &GAP. (washper) is missing, then there are no prior claims as this has been already assessed.
Program inputs
  • &INFILE. (Dataset in which gaps are to be looked for.)
Program outputs
  • &OUTFILE. (Dataset with the gap condition applied.)

Usage

%ms_findgap(INFILE=_groupindex,
            OUTFILE=_pov12, 
            GAP=&WASHPER2.);
Parameters
[in]INFILEName of the dataset in which gaps are to be found.
[out]OUTFILEName of the output dataset with the gap condition applied.
[in]GAPGap value to look for between records according to gapby.

SAS Macros Dependencies

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