I dont think it is possible to create the numeric format and character format from the same dataset using proc format CNTLIN option.
You have to create separate datasets for numeric format and character format then use separate proc format CNTLIN option.
data have;
type='N';
fmtname='range';
hlo='L';
start=.;
end=10000;
label='<= 100,000';
output;
type='N';
fmtname='range';
hlo=' ';
start=100001;
end=250000;
label='> 100,000';
output;
type='N';
fmtname='range';
hlo=' ';
start=250001;
end=400000;
label='> 250,000';
output;
type='N';
fmtname='range';
hlo=' ';
start=400001;
end=500000;
label='> 400,000';
output;
type='N';
fmtname='range';
start=500001;
end=.;
hlo='H';
label='> 500,000';
output;
run;
data have2;
/*character format*/
type='C';
fmtname='$sexsg';
start='F';
label='Female';
output;
type='C';
fmtname='$sexsg';
start='M';
label='Male';
output;
run;
proc format cntlin=have fmtlib;
run;
proc format cntlin=have2 fmtlib;
run;
... View more
