I have found some pages about this problem,typically there is an idea about "adding type="c" ",however the problem still exists. Could someone kindly tell me why and how to fix?The attachment is data for this question and column purc_amt is numeric while other are char type. data mcc;
set mcc_code(rename=(mcc=start mcc_desc=label)) end=last;
retain start label;
fmtname="mccdesc";
type="c";
run;
proc sql noprint;
insert into mcc
set start="other"
,label=""
,fmtname="$mccdesc"
,type="c";
quit;
proc format cntlin=mcc;run;
... View more