This macro uses encounter dataset from the MSDD to count the number of distinct visits from a reference date and within a lookback period. More...

Detailed Description

This macro uses encounter dataset from the MSDD to count the number of distinct visits from a reference date and within a lookback period.

Reduce data to selected patients and time frame.
- Accept upper or lower case values for BYENC.
  - Any encounter type (or group of) can be specified.
- Make sure STARTDT or ENDDATE is never missing.
- Create format for strata.
- Allow one encounter per day.
- Create output table.
  - Containing the total number of encounters (both formatted and unformatted).
  - If requested, containing the number of encounters by encounter type (unformatted only).
- Assign &GROUPVAR. variable.

Program inputs

&ENCOUNTERFILE. (Dataset containing encounter data.)
&INDEXFILE. (Dataset containing patid and reference date from which the count will be computed.)

Program outputs

&OUTFILE. (Dataset containing the counts.)
work._indexfile (Dataset with the PatId, reference date, the number of total visits (both group and numeric), and if requested, the number of visits for each specified encounter type (numeric only).)

Usage

%ms_util(ENCOUNTERFILE=worktemp._baseenc,        
         INDEXFILE=_IndexFile,                 
         STARTDT=&MEDUTILANCHORFROM,
         ENDDT=&MEDUTILANCHORTO,
         INDEXDT=IndexDt,
         GROUPNAME="&itgroup.",
         UTILFROM=&MEDUTILFROM.,
         UTILTO=&MEDUTILTO.,
         CARESETTINGS=&listofcaresettings., 
         BYENC=Y,
         CSSTRAT=0 1 2-7 8+,
         OUTFILE=_ITUtil,
         STANDALONE=N);

Parameters

[in]	ENCOUNTERFILE	The name of the SAS dataset containing encounter data.
[in]	INDEXFILE	The name of the SAS dataset containing the PatId and reference date to compute the number of visits.
[in]	STARTDT	Start of evalaution period (IndexDt for non-Type4, IndexDt or EpisodeEndDt for Type4).
[in]	ENDDT	End of evalaution period (IndexDt for non-Type4, IndexDt or EpisodeEndDt for Type4).
[in]	INDEXDT	The name of the variable containing the reference date in INDEXFILE.
[in]	GROUPNAME	Name of group to assign in final dataset.
[in]	UTILFROM	Number of days, anchored on the STARTDT, to define the start of the window.
[in]	UTILTO	Number of days, anchored on the ENDDT, to define the end of the window.
[in]	CARESETTINGS	The encounter type (caresetting) to be used in the count macro.
[in]	BYENC	Type of output requested. "N" requests counts by all visits (with both the formatted and unformatted version of counts). "Y" requests unformatted counts by encounter type in addition to both the formatted and unformatted overall counts returned under "N". Note - by encounter type and overall will calculate totals differently (By encounter type allows one visit per day per encounter type. By overall allows only one visit per day). So if you compare the sum of encounter type counts to the overall counts, they may not match.
[in]	CSSTRAT	The grouping of counts that the user wishes to apply. Groups need to be separated by a space, intervals defined using "-" and use "+" if the last group is open ended.
[out]	OUTFILE	Name of the output dataset containing the counts.
[in]	STANDALONE	Y/N indicator as to whether this is a standalone execution of the macro.

SAS Macros Dependencies

None.

Note

- The INDEXFILE input file must contains PatId and a reference date.

As with all MS Programs, this macro assumes that the encounter table has been defined according to the MSCDM.
Eligibility criteria are assumed to have been checked (i.e., that patients are eligible for medical benefits in the UTILFROM-UTILTO interval).

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

	QRP