Running this code and coming up with the error above. Any suggestions on how to successfully run?     proc sql ; create table max_line_apc as select legacy_claim_id ,line_id ,apc_fee ,max_apc_fee from OPSURG6 where apc_fee not in (0, .) order by legacy_claim_id, apc_fee desc ; quit ; ... View more

proc sql ; create table op_build1 as  select a.*              ,apc.fee_2024 as apc_fee format dollar18.2              ,apc.fees as apc_pricing_fee               ,apc.indicator as apc_indicator              ,mircm.final_fee as hosp_cm_curr_fee               ,mirma.final_fee as hosp_ma_curr_fee               ,typec.indicator as ip_only_flag from op_hosp_join as a                 left join apc_fee as apc on a.adj_proc_code = apc.cpt_code                 left join MIRCMFees as mircm on a.adj_proc_code = mircm.cpt_code                left join MIRMAFees as mirma on a.adj_proc_code = mirma.cpt_code                left join Type_C as typec on a.adj_proc_code = typec.code ; quit ;   ... View more