This macro expands codes that were supplied by the user using ranges (-) and/or wilcards (*). More...

Detailed Description

This macro expands codes that were supplied by the user using ranges (-) and/or wilcards (*).

This macro can only be used with diagnosis claims.

Create dataset with instructions to manage code ranges dynamically.
Determine codes length for ranges of codes and no ranges of codes.
There must have at least one code to process.
- Get dynamic instructions to execute code ranges.
- Output ranges of codes and no ranges of codes by dynamic processing according to code length.
- Process wildcards.

Program inputs

Program outputs

Usage

%ms_processwildcards(INFILE=_diag, 
                     CODEVAR=code, 
                     OUTFILE=_diag);

Parameters

[in]	INFILE	The name of the sas dataset containing the codes to expand.
[in]	CODEVAR	The name of the sas variable containing the codes to expand.
[in]	CODETYPE	The name of the sas variable containing the code types of the codes to expand.
[out]	OUTFILE	The name of the output sas dataset containing the expanded codes.

Note: (1) When using the range operator, lengths of codes on both sides of the �-� MUST be the same and the use of * must also be the same on both sides (2) Wildcards (*) are always indicative of one character. For example, 250* will always expand into a four-digit code, never a five- digit code, while 250** will always expand into a five- digit code. Similarly, if a requestor would like ALL permutations of three-, four- and five- digit codes, they will need to specify it as such in the input file (i.e., 250, 250*, 250**). (3) If a digit value should be capped, multiple single entries should be specified intead of ranges. For example, if AMI codes where the 5th digit is always 0, 1 or 2 are required, 3 entries (410*0, 410*1 and 410*2) should be specified instead of a range (410*0-410*2) Supported Examples: Code="310-312" Expected: 310 to 312 Code="E123-E128" *Expected: E123 to E128 Code="250</em>" *Expected: 2500 to 2509 Code="250*-252*" *Expected: 2500 to 2529 Code="410*0-410*2" *Expected: 41000 to 41092 Code="410*0" *Expected: 41000 to 42090 5th digit always 0 Code="25*0*" *Expected: 25000 to 25909 4th digit always 0
Code="99**-9962" *Expected: 9900 to 9962 Code="140-208" *Expected: 140 to 208 Code="140**-208**" *Expected: 14000 to 20899

Not Supported Examples: Code="2841*-285*" Code="140*-15*"

None.

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

	QRP