ERROR: Character expression requires a character format.

[Jayreed34]

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 ;

[ballardw · Accepted solution]

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