ERROR: Character expression requires a character format.

Jayreed34 — Wed, 09 Oct 2024 20:06:45 GMT

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 ;

Re: ERROR: Character expression requires a character format.

ballardw — Wed, 09 Oct 2024 20:43:40 GMT

Since the only format you show is Dollar18.2 that means that your variable apc.fee_2024 is not numeric.