I'm wondering why we get the same result with both discreteorder=unformatted and discreteorder=formatted.
With unformatted I would have expect something like
2-Female (F), 1-Male (M) and 3-Missing (X)
not
1-Male (M), 2-Female (F), 3-Missing (X)
proc format;
value $sex 'F' = '2-Female'
'M' = '1-Male'
'X' = '3-Missing';
run;
data class;
set sashelp.class;
if age=13 then sex='X';
run;
*format statement only;
title 'discreteorder=unformatted';
proc sgplot data=class;
vbarbasic sex / group=sex;
format sex $sex.;
xaxis discreteorder=unformatted;
run;
title 'discreteorder=formatted';
proc sgplot data=class;
vbarbasic sex / group=sex;
format sex $sex.;
xaxis discreteorder=formatted;
run;
title;
with valuesformat= it would work as expected
title 'discreteorder=unformatted';
proc sgplot data=class;
vbarbasic sex / group=sex;
xaxis discreteorder=unformatted valuesformat=$sex.;
run;
... View more