With the replacement of EBD data with TPA data, this tip is no longer required. TPA and PBM Replacement Data for EBD It is advised that data users omit all member records from SE 95442 (HealthAdvantage) where the value in the Employer Name field (ME082) begins with ASE or PSE. Find the SE 95442 member records related to the SE 99EBD1 member records by grouping on Hash ID (created by concatenating APCD Unique ID (ME998) and member gender (ME013)). Drop the SE 95442 records where the Employer Name field (ME082) begins with ASE and PSE. NOTE: A similar situation exists for SE 95448B however it is not the same issue. This prxmatch SAS function could be helpful: prxmatch("/(A|P)SE[^A]/i",ME032_GroupName) =1 |