79461227

Date: 2025-02-23 12:46:57
Score: 2
Natty:
Report link

Thanks for all the suggestions. This seems to work well once the attributes are associated: LIST MBR.FILE BY.EXP MBR_NM MBR_UMID MBR_NM MBR_BTH MBR_AGE MBR_SEX MBR_PHONE MBR_GK_BD MBR_GK_ED MCARE_ID PROD_LOB GK_ADJ_CD RPT_PE WHEN ASSOCIATED (GK_CTRCT = "000226827 PCP313" AND GK_ADJ_CD = "" AND PROD_LOB = "MER" AND RPT_PE = "02/01/2025") ID.SUPP BREAK.ON GK_NM HEADER "'LC' Medicare-Risk Roster for 'B' 'LC' PE Date: 02/01/2025"

"With" doesn't seem to work with "Associated" no matter where it's placed in the query. I'm not certain why the 'B' option in the Heading fails to return the Break.On value.

Reasons:
  • Blacklisted phrase (0.5): Thanks
  • Long answer (-0.5):
  • No code block (0.5):
  • Self-answer (0.5):
  • Low reputation (1):
Posted by: Rich