ms_attrition_cidacompute.sas File Reference

Selects observations (patient/episodes) to exclude and writes to a utility file the # excluded and remaining. More...

Detailed Description

Selects observations (patient/episodes) to exclude and writes to a utility file the # excluded and remaining.

• Standardize macro inputs
• Compute the number remaining after applying exclusion criteria
• Compute the number excluded by obtaining the value of remaining from the last row output to _attrition
• Write to _attrition the # excluded and remaining
• Increase macro variable LEVEL by 1

Program inputs

• &datafile. (Dataset containing records to assess exclusion criteria)

Program outputs

• _attrition (Dataset containing the following variables: level, claim_level, descr, excluded, remaining

Usage

ms_attrition_cidacompute(ATTRITIONTYPE=excl_member, DATAFILE=_keep, ATTRITIONFILE=_attrition, TOEXCLVAR=metagecondition, TOEXCLVALUE='N', CLAIM_LEVEL=Member, DESCR=Did not meet age range condition, INDEXVAR=indexdt REMAINING=, EXCLUDED=, DEBUG=N, ALWAYSEXCLUDEFROMDATA=N);

Parameters

[in]	ATTRITIONTYPE	Takes one of four values: excl_member => compute an exclusion step at patient level. excl_episode => compute an exclusion step at episode level. information => report remaining and excluded parameters provided to the macro skip => report previous step remaining and missing excluded with empty description.
[in]	DATAFILE	Name of dataset used to compute excluded and remaining patients or episodes.
[in]	ATTRITIONFILE	Optional name of output dataset. Defaults to _attrition
[in]	TOEXCLVAR	Variable used as exclusion criterion. If not specified will count number in &datafile as remaining without an exclusion
[in]	TOEXCLVALUE	Condition using ToExclVar used as exclusion criterion. Can be left blank if TOEXCLVAR is blank
[in]	CLAIM_LEVEL	Assign value to variable claim_level. This is used to differentiate assessment at the Member or Episode level in the output dataset, not in the attrition processing.
[in]	DESCR	Decription to include in output dataset
[in]	INDEXVAR	Variable containing the patient's index date. Required when attritiontype = excl_episode. Defaults to indexdt
[in]	REMAINING	Number of remaining patients or episodes to output for information attritiontype.
[in]	EXCLUDED	Number of excluded patients or episodes to output for information attritiontype.
[in]	DEBUG	Y/N indicator to save to library debug&group. a list of excluded patients or episodes. &group must be previously defined and library must already exist
[in]	ALWAYSEXCLUDEFROMDATA	Y/N indicator to remove rows from &datafile when attritiontype= excl_member/excl_episode regardless of whether there are exclusions. This should be set to Y when excluding rows but not episodes/members.

SAS Macros Dependencies

isdata().

Note

Macro variable LEVEL will be used (initialized to 1 if not previously defined) and will increase by 1 for each execution of this macro

Author

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