I need to group US medical Procedure Codes based on their ranges. It was easily implemented for CPT codes as they are all 5 byte numeric.
However, it is more difficult with HCPCS codes because they begin with an alpha followed by 4 numeric bytes. The ranges are unique per alpha. I want to use IntervalMatch only when the first byte of the two compare codes are the same, and then perform the function on the last 4 bytes. Example:
R0070-R0076 should be grouped as Diagnostic Radiology Services. I have an excel doc with the ranges set up with:
FromHCPCS, ToHCPCS, HCPCS Group
R0070, R0076, Diagnostic Radiology Services
Load Script below, where Service Cd is the field containing the CPT/HCPCS code
(ooxml, embedded labels, table is [HCPCS Mapping]);
I just don't know how to force IntervalMatch to only look at the last 4 bytes of my Service Cd, and also within an if statement based on the first byte, then return the original Service Cd to match to the original fact table.
Is this possible with IntervalMatch, or is there another method I should be using?